Re: Oracle uptime monitoring

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 16 Mar 2006 19:34:35 +0100
Message-ID: <4419afbb$0$27075$626a54ce@news.free.fr>

<robgtaylor_at_gmail.com> a écrit dans le message de news: 1142531448.410430.126220_at_e56g2000cwe.googlegroups.com...
| 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?
|

I don't read the article but the database is open when you receive the message "Completed: alter database open".

Regards
Michel Cadot Received on Thu Mar 16 2006 - 12:34:35 CST