Shutting down oracle servers

Hi all,

There was a posting recently about shutting down servers (due to net-work problem with my email folder I can n't access the particular emails)

And there were some interesting points made about NOT shutting down servers due to queries stored in SQL pool etc....

But what I would like to hear about rules of practise regarding shutting down the servers due to memory leakage.

We are running a 8.1.6 server on NT along with a Java application. We've had performance problems recently and in the past this was due to deadlocks - we've resolved this matter but sometimes shutting down the server does seem to improved performance for the short term. I'm also going to look into rebuilding indexes as well to see if this might be a problem. But one of the people that I work with says that servers should be shutdown on a regular basis due to memory leakage. Is this true? and Is there any other reason why you would shut down servers on a regular basis?

Thanks,

N.

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

------=_NextPart_000_0007_01C2FCF8.FC8811A0--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nuala Cullen
  INET: ncullen_at_catlogic.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



application/ms-tnef attachment: winmail.dat