Doc

    Name:  spooload.sql

    Author Mark Gurry

    This script shows the loads into the shared pool with the objects
    with the most loads listed first.

#


ttitle ' Loads into Shared Pool  - Most Loads First'

select  owner, name||' - '||type name, loads , sharable_mem 
  from v$db_object_cache where loads > 5 
   and type in ('PACKAGE', 'PACKAGE BODY', 'FUNCTION', 'PROCEDURE')
 order by loads desc;