Re: oracle11 logs, the sequel.
Date: 16 Jan 2008 12:23:53 GMT
Message-ID: <478df759$0$1341$834e42db@reader.greatnowhere.com>
On Wed, 16 Jan 2008 10:26:40 +0000, Mladen Gogala wrote:
> It would be rather trivial to load this into a table and index it by
> time,type and component. Of course, you'd need modules XML:arser and
> XML:arser::EasyTree. I will need to test DBMS_SYSTEM.KSDWRT.
>
DBMS_SYSTEM.KSDWERT still has only 2 arguments. Here is the call to KSDWRT: SQL> exec dbms_system.ksdwrt(2,'This is a test!');
PL/SQL procedure successfully completed.
Result produced was:
<msg time='2008-01-16T13:14:04.248+01:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
module='sqlplus_at_nwxp-mgogala.ot.hr (TNS V1-V3)' pid='8026'>
<txt>This is a test!
</txt>
</msg>
Normal alert log contains the expected text:
Wed Jan 16 13:14:04 2008
This is a test!
Module information looks quite useful. The script I posted earlier can be used to extract module information, too.
__
Mladen Gogala
http://mgogala.freehostia.com
Received on Wed Jan 16 2008 - 06:23:53 CST