Rem drv: <migrate type="schema_upgrade" version="10.2.0.5"/>
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/11.2.0.0/hdm/hdm_schema_upgrade.sql /st_emdbsa_11.2/1 2008/12/12 12:05:23 mvajapey Exp $
Rem
Rem hdm_schema_upgrade.sql
Rem
Rem Copyright (c) 2006, 2008, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      hdm_schema_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    mvajapey    12/09/08 - bug 7697340: upgrade ADDM data
Rem    mvajapey    06/09/08 - 
Rem    kdas        09/08/06 - Created
Rem
ALTER TABLE MGMT_DB_LATEST_HDM_FINDINGS 
  ADD (FINDING_COUNT NUMBER,
       FINDING_NAME VARCHAR2(4000),
       ACTIVE_SESSIONS NUMBER,
       INSTANCE_COUNT NUMBER);

ALTER TABLE MGMT_DB_HDM_METRIC_HELPER
  ADD (TASK_COUNT NUMBER,
       REQUESTED_ANALYSIS VARCHAR2(8));