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:
> 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
>
>
>
Received on Thu Feb 20 2003 - 11:35:50 CST
