Oracle 视图 DBA_HIST_REPORTS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图DBA_HIST_REPORTS提供了在Install Base(IB)中创建的所有历史报告的信息。
DBA_HIST_REPORTS视图可以帮助DBA了解当前和已安装的基础设施状况,包括储存使用情况、I/O等。通过分析DBA_HIST_REPORTS视图中的数据,DBA可以更好地优化和了解Oracle数据库的性能,从而提高系统的效率和可靠性。
如何使用DBA_HIST_REPORTS视图:
(1)要查看DBA_HIST_REPORTS视图中的数据,您可以使用SQL语句执行SELECT操作:
SELECT report_id, report_name, report_date FROM dba_hist_reports;
(2)要查看报告的每一行,您可以运行SELECT语句:
SELECT parent_report_id, report_row_id, column_name, column_value
FROM dba_hist_reports_rows
WHERE report_id = YOUR_REPORT_ID;
(3)要查看报告中某列的值,您可以使用以下语句:
SELECT column_value
FROM dba_hist_reports_rows
WHERE report_id = YOUR_REPORT_ID
AND column_name = YOUR_COLUMN_NAME;
官方英文解释
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:
“DBA_HIST_REPORTS_DETAILS”