> 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:
>
>  [email protected]
>
> Can i do something with V$thread or V$timer ?
>
> The management wants to know the total uptime + total downtime !!!
>
> Please help me !
>

Answer1:

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.

Answer2:

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.