Re: uptime

From: Kellyn Pot'vin <kellyn.potvin_at_ymail.com>
Date: Thu, 13 Sep 2012 05:17:15 -0700 (PDT)
Message-ID: <1347538635.59660.YahooMailNeo_at_web121001.mail.ne1.yahoo.com>

Here's one of mine, Connor...

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

STARTED                   DAYS
------------------- ----------

01/02/2012 14:08:27     224.71

SQL>  
Kellyn Pot'Vin
Senior Technical Consultant
Enkitec
DBAKevlar.com
RMOUG Director of Training Days 2013

~Tombez sept fois, se relever huit!

---

 From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> To: oracle-l <oracle-l_at_freelists.org>; mcdonald.connor_at_gmail.com Sent: Thursday, September 13, 2012 5:26 AM Subject: Re: uptime  

We are on x64 Windows and we NEVER restart our servers.
>>> Connor McDonald <mcdonald.connor_at_gmail.com> 9/13/12 12:32 AM >>>
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




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

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

Received on Thu Sep 13 2012 - 07:17:15 CDT