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 |
---|---|---|---|
|
|
ID of the first Automatic Workload Repository (AWR) snapshot that will be taken after this report is generated |
|
|
|
Database ID of the current database for the report |
|
|
|
Instance number (for an Oracle RAC system) |
|
|
|
ID of the captured report |
|
|
|
ID of the component (for example, SQL Monitor) whose report is captured |
|
|
|
ID of the session corresponding to the captured report (currently used only for SQL Monitor reports) |
|
|
|
Session serial number corresponding to the captured report (currently used only for SQL Monitor reports) |
|
|
|
Time when the activity period started |
|
|
|
Time when the activity period ended |
|
|
|
Time when this report was generated |
|
|
|
Name of the component whose report this is |
|
|
|
Name of this report |
|
|
|
Parameters associated with this report |
|
|
|
Key1 associated with the captured report |
|
|
|
Key2 associated with the captured report |
|
|
|
Key3 associated with the captured report |
|
|
|
Key4 associated with the captured report |
|
|
|
Time taken to generate this report (in seconds) |
|
|
|
Summary of this report |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also:
This column is available starting with Oracle Database 12c Release 1 (12.1.0.2).