reading alert log

Hi all,
I am trying to come up with the sql query to read Alert Log.
I am trying to bring only "ORA-" lines between the two dates (today
asnd yesterday for instance). Does anyone have a query handy or point
me to the right direction, please?

Thanks,
Eugene

Why not just use GREP (or another similar command)?

Thaks for reply,
I am using Oracle 9i on Windows 2003 server

Jared Still has written something which I think
you can find on www.dbazine.com


--
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated March 9th 2005






"Eugene" <epipko@hotmail.com> wrote in message
news:1112377853.818404.195230@g14g2000cwa.googlegr oups.com...
> Hi all,
> I am trying to come up with the sql query to read Alert Log.
> I am trying to bring only "ORA-" lines between the two dates (today
> asnd yesterday for instance). Does anyone have a query handy or point
> me to the right direction, please?
>
> Thanks,
> Eugene
>

have you applied w2k3 SP1 yet?

(think in terms of penguin-like behavior of someone else being
first-in).

-bdbafh

On 2005-04-01, Eugene <epipko@hotmail.com> wrote:
> Hi all,
> I am trying to come up with the sql query to read Alert Log.
> I am trying to bring only "ORA-" lines between the two dates (today
> asnd yesterday for instance). Does anyone have a query handy or point
> me to the right direction, please?

Please see
http://www.adp-gmbh.ch/ora/admin/read_alert/index.html

hth
Rene

--
Rene Nyffenegger
http://www.adp-gmbh.ch/

I believe Connor has written a nice utility using external tables
in his book "Mastering Oracle PL/SQL: Practical Solutions".
In fact I think he has shown various ways to monitor the
alert log.


Anurag

Thank you all for your help,

Eugene

"Eugene" <epipko@hotmail.com> wrote in
news:1112381317.925555.280260@z14g2000cwz.googlegr oups.com:

> Thaks for reply,
> I am using Oracle 9i on Windows 2003 server
>

Are you bragging or complaining?

Install CYGWIN & you too can have access to all the great *nix command line
utilities; like grep.

look here for a solution ..

http://asktom.oracle.com/pls/ask/f?p...:1352202934074