DBMS_SHARED_POOL
This package allows access to information about sizes of the objects stored in the shared pool and marks them for keeping or not-keeping.
Procedures
The most relevant procedures are:
KEEP
: keeps an object in the shared pool, so it isn't subject to agingUNKEEP
: unkeeps an object from the shared poolPURGE
: purges the objectSIZES
: shows objects in the shared pool larger than the specified size