Month: April 2011

Alert Log, DBA, Oracle, SQL, XML

SQL Access to the alert-log in 11g and an oddity

TweetShareSharePin0 SharesQuite a while ago I wrote about how to setup the alert log as an external table. Since then 11g has been introduced and is now widely used. It of course changes the location and makes the alert log an xml file. While it is possible to select from it using xml functions like Laurent Schneider does here, it is still a bit cumbersome. Tanel Poder (@TanelPoder) found a nicer way by usingĀ X$DBGALERTEXT which does a really nice job […]