I don’t know what it is today, but reading Tanel’s post about “Oracle 11g: Reading alert log via SQL“, I just wanted to see if I could manage to do it backwards. In principle you don’t have to use the statements below, because I noticed that the DBMS_SYSTEM.KSDWRT will do it for you automatically. The …
Monthly Archive: March 2009
Mar 24 2009
When is an XQuery Statement too Long?
I just saw Daniel Fink’s – OptimalDBA – blog post: When is a sql statement too long? When the following OTN XMLDB Forum post popped up in my mind… “xquery” versus “select xmlquery” and passing clauses. It tells the story about using bind variables and its performance issues, some alternative ways of dealing with things, charactersets and the ORA-19102 error (“XQuery string literal expected”), ORA-19114 (“Error during parsing the XQuery expression: string”) or ORA-01704 (“String literal too long”).
So when is a XQuery string too long…?
…
Mar 12 2009
Advert: Tanel Poder Seminar 2 and 3 April 2009 in Holland
Tanel Poder is coming to the Netherlands to do his seminar “Advanced Oracle Troubleshooting for DBAs and Performance Engineers“. I enjoyed his sessions greatly during Hotsos and if you are one off the lucky who can manage to attend during the 2nd and 3rd of April, organized by Anjo Kolk’s Miracle Benelux, in Holland, please …
Mar 12 2009
Hotsos 2009 – Final Words and Farewell
The symposium has finished. It was a great day with nice presentations from Robyn Sands, Chen Shapira, Dan Norris, Jonathan Lewis and a farewell and thank you speech from Gary Goodman. There are some lucky people who will attend tomorrow the training day with Jonathan Lewis. I will have to do some shopping for my …
Mar 11 2009
Hotsos 2009 – Expressions
I have looked multiple times at the video, posted here, and, just like the one from yesterday, I am amazed at the energy the pictures present, especially the expressions and gestures being used. I wondered if I would keep this up but seeing all those presenters (don’t mind me – I am getting in shape, …
Mar 10 2009
Hotsos 2009 – Foundations
During a Masterclass in 2005, I didn’t had the nerve to ask, and although with a little tremble, today I finally did… He autographed the book writing: “Support the Foundation!“, Chris Date, 3/9/3009… I always have and always will…As Chen Shapira called it: “Its like asking a rock star…”. So let the concert start ! …
Mar 09 2009
Hotsos 2009 – Silent Impressions
Mar 08 2009
Hotsos 2009 – For Absent Friends
The silence before the storm. Gerwin and I arrived yesterday at the OMNI Mandalay Hotel in Irving Texas. Currently Gerwin is working hard in finishing his presentation for Monday for the Hotsos Conference. I try to enjoy the silence, the quiet and easy pace things are going in the Hotel and in- and outside its …

Recent Comments