Re: Percent of Shared Pool used
From: Andrew Allen <andrew.allen_at_handleman.com>
Date: Thu, 20 Feb 2003 17:35:50 GMT
Message-ID: <3E5504EA.3080401_at_handleman.com>
Date: Thu, 20 Feb 2003 17:35:50 GMT
Message-ID: <3E5504EA.3080401_at_handleman.com>
Why on earth would you want to flush the shared pool? Oracle uses a LRU algorythm to take care of flushing the oldest unused objects when spaces is needed. Flushing the shared pool will only hurt performance.
-- Andrew Allen Javier Villegas wrote:Received on Thu Feb 20 2003 - 18:35:50 CET
> Hi
>
> I want to make a query for find the percent of Shared Pool used, and if the
> percent is grater than 70 % run the alter system flush shared_pool;
>
> Do you know how can I do that ?
>
> Thanks in advance
>
> Javier Villegas
>
>
>