About getting AWR report
Can I generate an AWR report for an AWR snapshot before setting "CONTROL_MANAGEMENT_PACK_ACCESS" to "DIAGNSOTIC"?
For example, the current setting
- CONTROL_MANAGEMENT_PACK_ACCESS: NONE
- STATISTICS_LEVEL: TYPICAL
- SNAP_INTERVAL: 1 hour
- RETENSION): 8 days
When
Can I get a 10/20 AWR report in the following time series?
10/19
10/20
10/21
10/22
(1) Execute the following SQL
Alter system set CONTROL_MANAGEMENT_PACK_ACCESS = DIAGNOSTIC;
(2) Execute the AWR
report acquisition command (awrrpt.sql) to acquire the AWR
report from 10/20 0:00 to 10/21 0:00.
Version
Oracle Database - Enterprise Edition 12.2.0.1