Database Tuning (MOSC)

MOSC Banner

About getting AWR report

edited Oct 20, 2021 4:32AM in Database Tuning (MOSC) 2 commentsAnswered

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


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center