Oracle教程 2023-02-24

Oracle 视图 DBA_HIST_REPORTS_CONTROL 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_HIST_REPORTS_CONTROL是数据字典视图，其中包括报告控件表中的行，提供在向用户发送历史报告时使用的控制令牌。它由基于监控架构的报告模块维护，可用于测量性能指标，如wait time和CPU utilization等。

使用DBA_HIST_REPORTS_CONTROL视图，用户可以查询定制的历史报告，以配合监控和诊断评估的形式显示。可以通过运行select语句，使用报告助手知道哪些报告被监控和跟踪，以及报告控件将报告发送到邮件中，从而控制其他报告功能，如任务调度等。

官方英文解释

DBA_HIST_REPORTS_CONTROL contains control information about the report capture mechanism that automatically captures XML reports to Automatic Workload Repository (AWR).

Reports are captured automatically for components like SQL Monitor and Real-Time Automatic Database Diagnostic Monitor (Real-Time ADDM).

Column Datatype NULL Description

Column	Datatype	NULL	Description
`DBID`	`NUMBER`		Database ID of the current database for the report
`EXECUTION_MODE`	`VARCHAR2(12)`		Mode of execution of automatic report capture. Possible values: `REGULAR`: Regular per-minute report capture subject to DBTIME budget `FULL_CAPTURE`: Report capture will be run per minute without the DBTIME budget constraints and is provided to capture a more comprehensive set of reports NOTE: The `FULL_CAPTURE` mode can be started and ended respectively by executing the `START_REPORT_CAPTURE` and `FINISH_REPORT_CAPTURE` APIs in the `DBMS_AUTO_REPORT` package. At all other times, the execution mode should be `REGULAR`.

DBID

NUMBER

Database ID of the current database for the report

EXECUTION_MODE

VARCHAR2(12)

Mode of execution of automatic report capture. Possible values:

REGULAR: Regular per-minute report capture subject to DBTIME budget
FULL_CAPTURE: Report capture will be run per minute without the DBTIME budget constraints and is provided to capture a more comprehensive set of reports

NOTE: The FULL_CAPTURE mode can be started and ended respectively by executing the START_REPORT_CAPTURE and FINISH_REPORT_CAPTURE APIs in the DBMS_AUTO_REPORT package. At all other times, the execution mode should be REGULAR.

本站中文解释

官方英文解释

相关推荐