RE: uptime
Date: Thu, 13 Sep 2012 08:06:52 -0400
Message-ID: <AD4532B304E00C4F9AEFA0D338DF7DD10D964ED082_at_excnysm95banp.nysemail.nyenet>
Connor,
I've fought this fight years ago.
If they feel the need to restart the Window's server for reasons other than Oracle you are stuck.
But restarting because they think Oracle needs it is just wrong.
Ask them for empirical evidence (proof) showing that Oracle is leaking memory and is in need of a restart.
They will not be able to show you any. So you can respond that it looks like an personal choice - not a technical one.
That's really all you can do. Expose their reasoning for what it is.
Tom
-----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:06:52 CDT