Re: oracle11 logs, the sequel.

From: Mladen Gogala <>
Date: 16 Jan 2008 12:23:53 GMT
Message-ID: <478df759$0$1341$>

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=' (TNS V1-V3)' pid='8026'>  <txt>This is a test!

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 Received on Wed Jan 16 2008 - 06:23:53 CST

Original text of this message