Oracle-L: Re: Shutting down oracle servers

From: Chris Berry <compjma_at_hotmail.com>
Date: Mon, 07 Apr 2003 10:59:23 -0800
Message-ID: <F001.0057C0C5.20030407105923@fatcity.com>

>From: "Nuala Cullen" <ncullen_at_catlogic.com>
>But what I would like to hear about rules of practise regarding shutting
>down the servers due to memory leakage.

If you can, the best solution is to fix the app that is leaking.

>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?

If you're running windows, you can use MaxMem from www.analogx.com to clean up memory leakage without restarting. (just remember that you're treating the symptoms and not the problem)

Chris Berry
compjma_at_hotmail.com
Systems Administrator
JM Associates

"Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken." -- Duke Leto Atreides

STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chris Berry
  INET: compjma_at_hotmail.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).

Received on Mon Apr 07 2003 - 13:59:23 CDT