Monthly Archive: March 2009

Mar 25 2009

Creating an alert log via XML/SQL

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 …

Continue reading »

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 …

Continue reading »

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 …

Continue reading »

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, …

Continue reading »

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 ! …

Continue reading »

Mar 09 2009

Hotsos 2009 – Silent Impressions

A Silent Impression before the Hotsos Symposium started… The Omni Mandalay Hotel premises on Sunday afternoon… …and a Tom encore, if you liked the music… Related posts: Hotsos 2009 – For Absent Friends Great start of Hotsos 2007 Hotsos 2008 Enjoying the Sun in Dallas OOW2K6 – Newbie 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 …

Continue reading »