Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I tell how long an instance has been up?

Re: How can I tell how long an instance has been up?

From: Stan Brown <stanb_at_panix.com>
Date: Tue, 17 Sep 2002 19:05:50 +0000 (UTC)
Message-ID: <am7uee$q8v$1@reader1.panix.com>


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 Franklin
Received on Tue Sep 17 2002 - 14:05:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US