Re: External Tables - Help Please
- From: Jared Still <jkstill@xxxxxxxxx>
- To: bnsarma@xxxxxxxxx
- Date: Mon, 21 Sep 2009 09:30:22 -0700
One method to try is to write a timestamp to the alert log at the beginning
of each day. Then just return
the rows following the timestamp.
eg:
begin
sys.dbms_system.ksdwrt(2,'ALERT LOG TIMESTAMP: ' ||
to_char(sysdate,'mm/dd/yyyy hh24:mi'));
end;
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
On Mon, Sep 21, 2009 at 8:58 AM, BN <bnsarma@xxxxxxxxx> wrote:
> Greetings
>
> I am using Oracle external tables to read alert log to display the content
> on a webpage
>
> Oracle Version :oracle 9.2.0.4 and oracle10grel2
>
> Looking for a sql to read Today's alert log contents only,
>
> Looked at uinsg AWK to create just todays file only, unless I run this
> every 2 mins or so, I wont see the latest alertlog info, dont want to go
> this route unless
> there is no other option
>
> Here is the SQL right now I am using to read last 100 lines, even this the
> Timestamp comes after the messages becase of DESC, not in the right order
>
> select rownum,text as "alert_${DB}.log" from
> (select alert_log.text, rank() over (order by rownum desc) r from
> alert_log)
> where r <= 100
>
> Appreciate your help
> --
> Regards & Thanks
> BN
>
Other related posts: