Informacion de la Library Cache
PROMPT
PROMPT ******************************************** LIBRARY CACHE ***********************************************************
PROMPT
COLUMN y new_value sid NOPRINT
SELECT name||’_'||TO_CHAR(sysdate, ‘ddmonyy_hh24miss’) y FROM v$database;
SPOOL library_cache_&sid..txt
BREAK ON HASH_VALUE
SELECT hash_value, sql_text
FROM gv$sqltext
WHERE command_type = 3
ORDER BY 1, piece;
CLEAR BREAKS
SPOOL OFF