Rem drv: <migrate type="data_upgrade" version="10.2.0.4" />
Rem $Header: metric_data_upgrade.sql 01-sep-2007.19:00:54 rrawat Exp $
Rem
Rem metric_data_upgrade.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      metric_data_upgrade.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    rrawat      08/27/07 - RFI bug-6367212
Rem    denath      08/18/07 - RFI 6349497.Removed the NULL check for update.
Rem    joyoon      07/26/07 - Created, Bug5647087
Rem
-- Set is_transposed to 1 for target_type oracle_database and metric_name SQLUDMSTR, SQLUDMNUM
BEGIN 

  UPDATE mgmt_metrics 
     SET is_transposed = 1
   WHERE target_type = MGMT_GLOBAL.G_DATABASE_TARGET_TYPE AND metric_name IN ('SQLUDM', 'SQLUDMSTR', 'SQLUDMNUM');
  
  COMMIT; 

END;
/

  -- Set is_transposed to 1 for target_type host and metric_name UDM
BEGIN

  UPDATE mgmt_metrics
     SET is_transposed = 1
   WHERE target_type = MGMT_GLOBAL.G_HOST_TARGET_TYPE AND metric_name  = 'UDM';

  COMMIT;

END;
/

  -- Set is_long_running to 1 for metric 'TARGET_COMPLIANCE' 
BEGIN 

  UPDATE mgmt_metrics 
     SET IS_LONG_RUNNING = 1
   WHERE target_type = MGMT_GLOBAL.G_REPOSITORY_TARGET_TYPE
         AND metric_name  = 'TARGET_COMPLIANCE';

  COMMIT; 

END;
/ 

  -- Set is_long_running to 1 for metric 'Targets_not_uploading' 
BEGIN

  UPDATE mgmt_metrics
     SET IS_LONG_RUNNING = 1
   WHERE target_type = MGMT_GLOBAL.G_AGENT_TARGET_TYPE
         AND metric_name  = 'Targets_not_uploading';

  COMMIT;

END;
/

show errors;