Oracle Management Pack usages

#######################################################
#
# Oracle Management Pack usages
# =============================
#
# http://www.dbaexpert.com/blog/determining-usage-of-oracle-management-packs/
# https://petesdbablog.wordpress.com/2013/04/06/disable-oracle-diagnostic-pack-tuning-pack/
#
#######################################################


# If you leverage any of the SQL scripts from the $ORACLE_HOME/rdbms/admin directory, you will be liable for the diagnostic pack:
• aawrload.sql
• addmrpti.sql
• addmrtp.sql
• ashrpt.sql
• ashrpti.sql
• awrddrpi.sql
• awrddrpt.sql
• awrextr.sql
• awrextr.sql
• awrinfo.sql
• awrload.sql
• awrrpt.sql
• awrrpti.sql
• awrsqrpi.sql
• awrsqrpt.


col name format A30
col detected format 9999
col samples format 9999
col used format A5
col interval format 9999999
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 detected_usages > 0
order by 1;


col name format A30
col detected format 9999
col samples format 9999
col used format A5
col interval format 9999999
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';
show parameter control_management_pack_access
ALTER SYSTEM SET control_management_pack_access=NONE;




cd ${ORACLE_HOME}/rdbms/admin
mv awrgrpt.sql _donotuse_awrgrpt.sql
mv awrrpt.sql _donotuse_awrrpt.sql