ckkept.sql

REM *************************************************************************** 
REM 
REM        TITLE:
REM        AUTHOR:
REM        DESCRIPTION:
REM
REM
REM
REM        USAGE W/ PARAMETERS:
REM        
REM        TABLES USED:
REM
REM  MODIFICATION ALLOWED (Y/N):	
REM  MODIFICATION HISTORY:
REM  WHO          WHEN         WHAT
REM  --------------------------------------------------------------------------
REM               MM/DD/YY     INITIAL CREATION
REM
REM ***************************************************************************
PROMPT *******************************
PROMPT Stored Packages and Procedures
PROMPT *******************************

col Owner format a8
col Kept format a7 heading "Pinned?"
col executions format 999,999,999 heading "Executions"


SELECT SUBSTR(owner,1,10) Owner,
       SUBSTR(name,1,25)  Name,
       sharable_mem       Share_Mem,
       executions,
       SUBSTR(kept||' ',1,4)   Kept,
       locks
  FROM v$db_object_cache
 WHERE kept like 'YES%'
 ORDER BY owner,executions, name, type
/