Cry How To...

Clear the shared pool

To clear the shared pool, issue the following:

Alter system flush shared_pool;

This does not clear shared SQL and PL/SQL areas for SQL statements, stored procedures, functions, packages or triggers that are currently being executed or for SQL SELECT statements for which all rows have not yet been fetched.

It may be desirable to clear the shared pool before beginning performance analysis.