Re: External Tables - Help Please
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: bnsarma@xxxxxxxxx
- Date: Mon, 21 Sep 2009 18:50:52 +0100
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@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
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
