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

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

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

DBA_HIST_REPORTS

DBA_HIST_REPORTS displays information about XML reports captured into Automatic Workload Repository (AWR). The reports themselves belong to components such as SQL Monitor, DBOP, and Real-Time ADDM.

Each XML report contains details about some activity of a component. For example, a SQL Monitor report contains a detailed report about a particular execution of a SQL statement, or a Real-Time ADDM report contains system performance data analyzed by Real-Time ADDM.

Column Datatype NULL Description
SNAP_ID NUMBER   ID of the first Automatic Workload Repository (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
COMPONENT_ID NUMBER   ID of the component (for example, SQL Monitor) whose report is captured
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 corresponding to the captured report (currently used only for SQL Monitor reports)
PERIOD_START_TIME DATE   Time when the activity period started
PERIOD_END_TIME DATE   Time when the activity period ended
GENERATION_TIME DATE   Time when this report was generated
COMPONENT_NAME VARCHAR2(128)   Name of the component whose report this is
REPORT_NAME VARCHAR2(128)   Name of this report
REPORT_PARAMETERS VARCHAR2(1024)   Parameters associated with this report
KEY1 VARCHAR2(128)   Key1 associated with the captured report
KEY2 VARCHAR2(128)   Key2 associated with the captured report
KEY3 VARCHAR2(128)   Key3 associated with the captured report
KEY4 VARCHAR2(256)   Key4 associated with the captured report
GENERATION_COST_SECONDS NUMBER   Time taken to generate this report (in seconds)
REPORT_SUMMARY VARCHAR2(4000)   Summary of this report