uptime

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Thu, 13 Sep 2012 12:32:29 +0800
Message-ID: <CAB=aETD2tJ=BzSQBPOHs8N7=dDJAGag54mwaVmMLpr6VtAVFDg_at_mail.gmail.com>

Hi all,
I need to convince a client that they dont need restart their Oracle db (and their Windows server) every night.

Can anyone send me:

select to_char(min(logon_time),'DD/MM/YYYY HH24:MI:SS') started,   round(sysdate-min(logon_time),2) days
 from v$session

for any long-in-the-tooth Windows server they've got...

Thanks,
Connor

-- 
Connor McDonald
===========================
blog:   connormcdonald.wordpress.com
web:   http://www.oracledba.co.uk

"If you are not living on the edge, you are taking up too much room."
- Jayne Howard


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 12 2012 - 23:32:29 CDT