Search notes:

Oracle: DBMS_SHARED_POOL

dbms_shared_pool can be used to

display the sizes of objects in the shared pool and
mark them for keeping or unkeeping (pin und unpin) in order to reduce memory fragmentation (see pinned objects in the Shared Pool)

Procedures

`aborted_request_threshold`
`keep`
`markhot`
`purge`	Remove («purge») objects (PL/SQL objects or SQL statements) from the shared pool
`sizes`	shows objects that occupy more than a given amount of memory in the shared pool.
`unkeep`
`unmarkhot`