Re: Easy way to find total uptime ?

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 4 Sep 1999 17:15:45 GMT
Message-ID: <7qrk41$3el$1@news.seed.net.tw>

Frans Trip <tripf_at_vertis.nl> wrote in message news:37CFABB6.39B4502B_at_vertis.nl...
> 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 !

Since you want to know the downtime,
the v$thread, v$instance, v$timer ....views are not helpful for you, they are available only when Oracle is open. Look at the ALERT log file to find out the timestamp when Oracle startup/shutdown. Received on Sat Sep 04 1999 - 12:15:45 CDT