RE: uptime
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxx>
- To: "mcdonald.connor@xxxxxxxxx" <mcdonald.connor@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 13 Sep 2012 08:06:52 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
