Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Server up time
the view v$instance should give you all that you need. The uptime is
recorded in Julian days and seconds, so if you want to find out when it
was brought up do something like this
select to_char(to_date(a.value||b.value,'JSSSSS'),'YYYYMMDD HH24:MI:SS')
from v$instance a,
v$instance b
where a.key = 'STARTUP TIME - JULIAN'
and b.key = 'STARTUP TIME - SECONDS';
Frans Trip 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
Received on Wed Aug 11 1999 - 09:56:09 CDT