Tag: alert.log

March 25

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 content of my Oracle 11g log.xml file is as follows

 Starting ORACLE instance (normal)



So based on Tanel’s blog, could I do the same, but now with XMLDB functions (based on database version…

Here it goes.