Hi ,
I just got my hands on a series of 10g databases at a client site but as the "control_management_pack_access" exist only in 11g I tried running a couple of queries found online but I am still not sure what to imply from it . Here is the result on production DB
any insight on how to figure out if the packs are included or not ?
thank you in advance
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for 32-bit Windows: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
1-
SQL> SELECT name,detected_usages,currently_used,
TO_CHAR(last_sample_date,'DD-MON-YYYY:HH24:MI') last_sample
FROM dba_feature_usage_statistics
WHERE name = 'AWR Report' ;
NAME DETECTED_USAGES CURRE LAST_SAMPLE
---------------------------------------------------------------- --------------- ----- -----------------
AWR Report 0 FALSE 06-OCT-2015:19:36
2-
SQL> SELECT name,
detected_usages detected,total_samples samples,currently_used used,
to_char(last_sample_date,'MMDDYYYY:HH24:MI') last_sample,
sample_interval interval
FROM dba_feature_usage_statistics
WHERE name = 'Automatic Workload Repository' OR name like 'SQL%';
NAME DETECTED SAMPLES USED LAST_SAMPLE INTERVAL
------------------------------- -------- ------- ----- -------------- --------
Automatic Workload Repository 0 186 FALSE 10062015:19:36 604800
SQL Tuning Set 0 186 FALSE 10062015:19:36 604800
SQL Tuning Advisor 0 186 FALSE 10062015:19:36 604800
SQL Access Advisor 0 186 FALSE 10062015:19:36 604800