Rem
Rem $Header: upgrade_delete_metrics.sql 02-feb-2007.07:44:55 mnihalan Exp $
Rem
Rem upgrade_delete_metrics.sql
Rem
Rem Copyright (c) 2006, 2007, Oracle. 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    mnihalan    02/02/07 - Remove JAccelerator
Rem    denath      09/28/06 - Fix 5572415.Added SET DEFINE.
Rem    denath      08/05/06 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

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 => 'rac_database',
      p_metric_name => 'DB_INSTALL_NCOMPS');

   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_INSTALL_NCOMPS');

 EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;

  COMMIT;

END;
/

SET DEFINE ON