6.35 DBA_HIST_REPORTS_DETAILS
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 |
---|---|---|---|
|
|
|
ID of the first 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 session corresponding to the captured report (currently used only for SQL Monitor reports) |
|
|
|
Session serial number relevant to this report (currently used only for SQL Monitor reports) |
|
|
|
Time when this report was generated |
|
|
|
Actual XML report in compressed form |
|
|
|
Full uncompressed report |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: