doc

    Name:   objremov.sql

    Author: Mark Gurry

    This script lists how many objects are being removed to 
    bring a new object into the shared pool.

#

ttitle 'Objects Pinned in Shared Pool'

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