RE: any script to parse alert log ?!

> Here is a good one:
> create or replace directory bdump as
> '/oracle/admin/o9i/bdump' / grant read on directory bdump to
> public / create table alert_log_ext ( line varchar2(2000) )
> organization external ( type oracle_loader default directory
> bdump access parameters
> (
> records delimited by newline
> nobadfile nologfile nodiscardfile
> fields (line char(132)
> )
> )
> location('alert_o9i.log') )
> reject limit unlimited
> /
>
> You can now write a PL/SQL or Java procedure to parse
> alert_log_ext table if your heart so desires. There is only
> one problem: this doesn't work if you don't have 9iR2.
Or if the database isn't up.....

I do like the idea though, could centralize all alert.logs and indeed listener.logs etc in one db.

Niall

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: niall.litchfield_at_dial.pipex.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).