Re: Easy way to find total uptime ?

On Fri, 03 Sep 1999 13:06:30 +0200, Frans Trip <tripf_at_vertis.nl> wrote:

>Hi There,
>
> I need to supply information about the Oracle database up-time.
> Where can i find this info in the database ?
>
> I need to present info about the availability of Oracle !!!
>
> Please mail your info to:
>
> tripf_at_vertis.nl
>
>Can i do something with V$thread or V$timer ?
>
>The management wants to know the total uptime + total downtime !!!
>
>Please help me !

You can always look at the timestamps in the database alert log for information about when it has been opened/closed. This may give you the best picture of the amount of time that the db has been down as well. There may also be an easy query from within the database dynamic tables - check the Administrator's Reference Guide.

• Lisa