Re: Percent of Shared Pool used

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 21 Feb 2003 05:41:38 +1100
Message-Id: <pan.2003.02.20.18.41.38.124220@yahoo.com.au>

On Thu, 20 Feb 2003 13:33:17 +0000, Javier Villegas wrote:

> 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

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.

This threatens to be a most "interesting" way of tuning a database.

Please don't go there!

Regards
HJR Received on Thu Feb 20 2003 - 12:41:38 CST