doc

    Name:    kept.sql

    Author:  Mark Gurry

    The following query shows objects that have been pinned in the 
    shared pool using the dbms_shared_pool.keep() procedure. 
#

SELECT name, type, kept
  FROM v$db_object_cache
 WHERE kept='YES';