Percent of Shared Pool used

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 - 10:33:17 CST