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
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
|
|
|