Re: Oracle uptime monitoring

robgtaylor_at_gmail.com wrote:
> In his book "Expert Oracle Database Architecture", Tom Kyte describes a
> method for generating uptime reports for an Oracle server.
>
> This section of the book is reproduced on the web here:
> http://www.dbazine.com/oracle/or-articles/kyte6
>
> He shows how you can query the alert log as an external table, looking
> for particular events in order to produce a report showing uptime
> statistics. I'd like to do a similar thing on one of my servers -
> possibly storing the results in a table. However I don't want to
> include periods of time when the database may have been up but only
> mounted rather than open.
>
> Can anyone suggest how I might edit Tom's example to achieve this goal?
> What phrases should I be looking for in the alert log?

Umm why don't you do the following:

1. startup nomount and look at what happens to the alert log
2. startup mount and look at alert log
3. startup and look at the alert log

What information are you missing if you follow that approach? Received on Thu Mar 16 2006 - 15:13:22 CST