Doc

    Name:  mostexec.sql

    Author Mark Gurry

    This script shows the execrutions in the shared pool with the 
    objects executed most listed first.

#

ttitle ' Executions of Objects in the  Shared Pool  - Most Executions First'

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