VIEW: SYS.DBA_RECOVERABLE_SCRIPT_HIST

Source

View Text - Preformatted

select oid, ctime, invoking_package_owner, invoking_package,
  invoking_procedure, invoking_user,
  decode(status, 4, 'EXECUTED',
                 6, 'PURGED'),
  total_blocks, done_block_num, script_comment
from sys.reco_script$
where status in (4,6)

View Text - HTML Formatted

SELECT OID
, CTIME
, INVOKING_PACKAGE_OWNER
, INVOKING_PACKAGE
, INVOKING_PROCEDURE
, INVOKING_USER
, DECODE(STATUS
, 4
, 'EXECUTED'
, 6
, 'PURGED')
, TOTAL_BLOCKS
, DONE_BLOCK_NUM
, SCRIPT_COMMENT FROM SYS.RECO_SCRIPT$ WHERE STATUS IN (4
, 6)