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 /