RE: uptime

From: Patterson, Joel <Joel.Patterson_at_crowley.com>
Date: Thu, 13 Sep 2012 08:32:15 -0400
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA1C7580D4F4_at_JAXMSG01.crowley.com>

I worked a dozen or so windows boxes running oracle for a couple years. I had no leak issues. I also did not patch Microsoft stuff and forget what kind of schedule that entailed. Actually, oracle was surprisingly stable on the windows boxes.

I'm back on solaris now so the timings are probably not relevant, but a quick sample shows one database up for 362 days.

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Connor McDonald Sent: Thursday, September 13, 2012 12:32 AM To: oracle-l
Subject: uptime

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 Received on Thu Sep 13 2012 - 07:32:15 CDT