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”
编辑：编程语言
标签：视图,您可以,语句,报告,数据