Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/11.2.0.0/policy/upgrade_delete_metrics.sql /st_emdbsa_11.2/5 2009/06/15 12:13:34 yozhang Exp $
Rem
Rem upgrade_delete_metrics.sql
Rem
Rem Copyright (c) 2008, 2009, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem      upgrade_delete_metrics.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    yozhang     06/10/09 - Fix bug 8477284: AUTO_PGA
Rem    nzhao       02/23/09 - Bug backports between
Rem                           EMDBGC_10.2.0.5.0_GENERIC_081008 and
Rem                           EMDBGC_10.2.0.5.0_GENERIC_090128 to
Rem                           EMDBSA_11.2.0.0.0_LINUX_090127
Rem    mnihalan    09/25/08 - Fix bug 7395749
Rem    yozhang     09/25/08 - Fix bug 6442503
Rem    yozhang     09/24/08 - Fix bug 6510791 in 11.2DBC
Rem    mnihalan    05/14/08 - Policy upgrade script
Rem    mnihalan    05/14/08 - Created
Rem

SET DEFINE OFF

BEGIN

 BEGIN  
   MGMT_METRIC.DELETE_METRIC(
       p_target_type => 'oracle_database',
       p_metric_name => 'DB_REDO_LOG_COUNT');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;
 END;

 BEGIN

   MGMT_METRIC.DELETE_METRIC(
      p_target_type => 'rac_database',
      p_metric_name => 'DB_REDO_LOG_COUNT');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;

 BEGIN
   MGMT_METRIC.DELETE_METRIC(
      p_target_type => 'rac_database',
      p_metric_name => 'DB_CONTROL_FILE_COUNT');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;

 BEGIN
   MGMT_METRIC.DELETE_METRIC(
      p_target_type => 'oracle_database',
      p_metric_name => 'DB_CONTROL_FILE_COUNT');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;

 
 BEGIN
   MGMT_METRIC.DELETE_METRIC(
      p_target_type => 'oracle_database',
      p_metric_name => 'DB_SGA_TARGET_INIT_PARAM');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;
  
 BEGIN
   MGMT_METRIC.DELETE_METRIC(
      p_target_type => 'oracle_database',
      p_metric_name => 'DB_TABLESPACES');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;


 BEGIN
   MGMT_METRIC.DELETE_METRIC(
      p_target_type => 'rac_database',
      p_metric_name => 'DB_TABLESPACES');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;
 
 BEGIN
   MGMT_METRIC.DELETE_METRIC(
      p_target_type => 'oracle_database',
      p_metric_name => 'DB_OPTIMIZER_VERSION');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;
  
 BEGIN
   MGMT_METRIC.DELETE_METRIC(
      p_target_type => 'oracle_database',
      p_metric_name => 'DB_HIDDEN_INIT_PARAMS');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;

 BEGIN
   MGMT_METRIC.DELETE_METRIC_METADATA(
       p_target_type => 'oracle_database',
       p_metric_name => 'HA_RECOVERY_AREA');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;
 END;

 BEGIN
   MGMT_METRIC.DELETE_METRIC_METADATA(
       p_target_type => 'rac_database',
       p_metric_name => 'HA_RECOVERY_AREA');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;
 END;

 BEGIN
   MGMT_METRIC.DELETE_METRIC_METADATA(
       p_target_type => 'oracle_database',
       p_metric_name => 'HA_INFO');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;
 END;

 BEGIN
   MGMT_METRIC.DELETE_METRIC_METADATA(
       p_target_type => 'rac_database',
       p_metric_name => 'HA_INFO');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;
 END;

 BEGIN
   MGMT_METRIC.DELETE_METRIC(
       p_target_type => 'oracle_database',
       p_metric_name => 'DB_TBSP_SEGSPACE_MGMT');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;
 END;
   
 BEGIN
   MGMT_METRIC.DELETE_METRIC(
       p_target_type => 'rac_database',
       p_metric_name => 'DB_TBSP_SEGSPACE_MGMT');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;
 END;
  
 BEGIN
   MGMT_METRIC.DELETE_METRIC(
      p_target_type => 'oracle_database',
      p_metric_name => 'DB_INIT_PARAMS_PGA');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;

 COMMIT;

END;
/

SET DEFINE ON