René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -


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.
Use v$db_object_cache to display pinned objects.