How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Posted on 08-Jun-2006 By Admin No Comments on How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) SELECT owner, name, type FROM v$db_object_cache WHERE kept = ‘YES’ AND TYPE = ‘CURSOR’; Oracle, SQL scripts