DBA Data[Home] [Help]

VIEW: SYS.INT$DBA_HIST_REPORTS_DETAILS

Source

View Text - Preformatted

select snap_id, dbid, instance_number, report_id, session_id, session_serial#,
       generation_time, report_compressed,
       dbms_auto_report_internal.i_uncompress_report(report_compressed),
       con_dbid, nvl(con_dbid_to_id(con_dbid), 0) CON_ID
from wrp$_reports_details d
View Text - HTML Formatted

SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, REPORT_ID
, SESSION_ID
, SESSION_SERIAL#
, GENERATION_TIME
, REPORT_COMPRESSED
, DBMS_AUTO_REPORT_INTERNAL.I_UNCOMPRESS_REPORT(REPORT_COMPRESSED)
, CON_DBID
, NVL(CON_DBID_TO_ID(CON_DBID)
, 0) CON_ID FROM WRP$_REPORTS_DETAILS D