Re: Alert Log Batch

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 21 Jun 2002 07:30:54 +1000
Message-ID: <aethjf$hen$1@lust.ihug.co.nz>

First off, you should be reading the alert log every day (the first thing you do when you get in of a morning). So there's no excuse for a log which grows to humungous sizes: if you're reading it, trim it yourself.

Secondly, having read it, just delete it (well, back it up first, just in case). Oracle will create a brand new on when it finds the original missing.

Regards
HJR "Jamal Atfeh" <atfeh_at_hotmail.com> wrote in message news:4d26ceb8b7c651026b3c9c929e9adc9a.69968_at_mygate.mailgate.org...
> I have Oracle databade 8.1.6 under NT4
>
> the alert log keeps growing
>
> is there any batch which can deduct the first 1000 lines from the alert
> log and save it under another name
>
>
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Thu Jun 20 2002 - 16:30:54 CDT