Database Tuning (MOSC)

MOSC Banner

How to Configure AWR on Oracle 11.2.0.4

edited Feb 16, 2017 2:58PM in Database Tuning (MOSC) 26 commentsAnswered ✓

Using Oracle 11.2.0.4.

checked, show parameter control_management_pack_access

It displays

Name                                                     Type                       Value

---------------------------------------               ---------------      -----------------------------

control_mangement_pack_access        string              DIAGNOSTIC+TUNING

checked AWR

column name format a30

select name, detected_usages, currently_used, to_char(last_sample_date, 'DD-MON-yyyy:HH24:MI') last sample

from dba_feature_usage_statics

where name = 'AWR Report';

it displays

Name                   Detected_usages    Currently_used    Last_sample

------------------------------------------------  ----------------------   ----------------------

AWR Report             0                         False                   16-JUL-2014:00:12

AWR Report             0                        False                    03-DEC-2016:23:59

How can configure.

We have the licensee, How can update AWR, it says required license.

Thanks,

Raj

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