Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Percent of Shared Pool used

Re: Percent of Shared Pool used

From: Tanel Poder <tanel_at_@peldik.com>
Date: Mon, 24 Feb 2003 01:00:13 +0200
Message-ID: <3e5951de_1@news.estpak.ee>


> If you're only using 70% of your shared pool, then you've over-sized it.
> Free memory inside a cache is wasted memory. And the very last thing you
> want to do is to flush the shared pool.

Hi,

flushing shared pool has helped me with performance during Oracle Applications upgrades several times. Of course this isn't a normal circumstance where thousands of packages are created in very short time..

Tanel. Received on Sun Feb 23 2003 - 17:00:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US