Re: External Tables - Help Please

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 21 Sep 2009 18:50:52 +0100
Message-ID: <7765c8970909211050g78229a9br19fca8c050800435_at_mail.gmail.com>

both dbconsole and grid control give you this out of the box if you have them -- so you could link to the page.

why not just rotate the alert.log each day?

On Mon, Sep 21, 2009 at 4:58 PM, BN <bnsarma_at_gmail.com> 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
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 21 2009 - 12:50:52 CDT