Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


DBA_HIST_REPORTS_DETAILS displays details about each report captured in Automatic Workload Repository (AWR). Metadata for each report appears in the DBA_HIST_REPORTS view while the actual report is available in the DBA_HIST_REPORTS_DETAILS view.

Column Datatype NULL Description
SNAP_ID NUMBER   ID of the first AWR snapshot that will be taken after this report is generated
DBID NUMBER   Database ID of the current database for the report
INSTANCE_NUMBER NUMBER   Instance number (for an Oracle RAC system)
REPORT_ID NUMBER   ID of the captured report
SESSION_ID NUMBER   ID of the session corresponding to the captured report (currently used only for SQL Monitor reports)
SESSION_SERIAL# NUMBER   Session serial number relevant to this report (currently used only for SQL Monitor reports)
GENERATION_TIME DATE   Time when this report was generated
REPORT_COMPRESSED BLOB   Actual XML report in compressed form
REPORT CLOB   Full uncompressed report