Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I tell how long an instance has been up?
In <156709aa.0209171053.1ed526a_at_posting.google.com> smontgomerie_at_hotmail.com (Steve) writes:
>select SYSDATE-logon_time "Days", (SYSDATE-logon_time)*24 "Hours"
>from sys.v_$session
>where sid=1
Thanks, that works perfectly.
-- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin FranklinReceived on Tue Sep 17 2002 - 14:05:50 CDT