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

RAC/HAS checking

################################
#
# Check for RAC or HAS env - run as root user
#
#
################################


for z in SED
do
GH=`cat /etc/oratab | grep "^+" | cut -f2 -d":"`
export GRID_HOME=${GH}
export PATH=${GRID_HOME}/bin:${PATH}
echo -e "\nChecking type of installation:"
A=`ps -ef | grep -i "orarootagent" | grep -v "grep" | awk '{print $1}' | uniq`
if [ -z ${A} ]
then
  echo -e "\nThis is NOT a RAC host:"
  crsctl check has
else
  CLUN=`cemutlo -n | tr [:lower:] [:upper:]`
  echo -e "\nThis is a RAC host for cluster: ${CLUN}"
  crsctl check crs
  echo "Hostnames:"
  olsnodes
  MMH=`crsctl status resource ora.mgmtdb | grep STATE | awk '{print $NF}'`
  echo -e "Management database host: ${MMH}"
fi
echo -e "\n"
done