Tag: log.xml

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)
 


 LICENSE_MAX_SESSION = 0
 


 LICENSE_SESSIONS_WARNING = 0
 

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

Here it goes.