DBA_HIST_REPORTS

5.33 DBA_HIST_REPORTS_CONTROL

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.