How to Configure AWR on Oracle 11.2.0.4
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