Thanx --> Re: any script to parse alert log ?!

Thanx Mladen.
i have got some scripts now.
i have to try one by one and find out which suits my need.

thanx u all.

Jp.

10-07-2003 09:09:24, Mladen Gogala <mgogala_at_adelphia.net> wrote:

>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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

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).