uptime
- From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 13 Sep 2012 12:32:29 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
