Re: Easy way to find total uptime ?

In article <37CFABB6.39B4502B_at_vertis.nl>,   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 !
>

Look at v$instance. Note was a major change in the format from version 7.3 to 8.

In ver 8 you can:
OPS2> select sysdate - startup_time from v$instance;

SYSDATE-STARTUP_TIME

          1.87542824 <== that is 1.9 days

For version 7 I believe you code something like:  select sysdate - to_date(a. value,'J') + (b.value / 60 / 60 / 24)   from v$instance a,

       v$instance b
 where a.key = 'STARTUP TIME - JULIAN'
   and b.key = 'STARTUP TIME - SECONDS' DDC2> / SYSDATE-TO_DATE(A.VALUE,'J')+(B.VALUE/60/60/24)

                                     5.87640046

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 03 1999 - 09:06:25 CDT