Rem drv: <migrate type="schema_upgrade" version="11.2.0.0"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/11.2.0.0/eml/eml_schema_upgrade.sql /st_emdbsa_11.2/5 2009/03/19 09:51:15 manaraya Exp $
Rem
Rem eml_schema_upgrade.sql
Rem
Rem Copyright (c) 2008, 2009, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      eml_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    manaraya    03/05/09 - Bug 7931482
Rem    ysun        01/12/09 - update cell count
Rem    yemeng      01/11/09 - add key sql profile
Rem    ysun        11/12/08 - add cell support
Rem    rsamaved    04/08/08 - 
Rem    kramarat    02/04/08 - SIHA Integration
Rem    kramarat    02/04/08 - Created
Rem

create or replace type SMP_EMD_DBSITEMAP_OBJ as OBJECT (
    TYPE_DISPLAY_NAME     VARCHAR2(256),
    LAST_UPDATED_TIME     DATE,
    CURRENT_STATUS        INTEGER,
    AVAIL_PCT             NUMBER,
    START_TIMESTAMP       DATE,
    timeZone              VARCHAR2(64),
    INSTANCE_NAME         VARCHAR2(4000),
    INSTANCE_STARTTIME    DATE,
    INSTANCE_VERSION      VARCHAR2(4000),
    ORACLE_HOME           VARCHAR2(4000),
    CPU_COUNT             NUMBER,
    OPEN_MODE             VARCHAR2(64),
    SQL_COUNT             NUMBER,
    SQL_SEVERITY          NUMBER,
    TBSP_COUNT            NUMBER,
    TBSP_SEVERITY         NUMBER,
    ARCHAREA_MODE         NUMBER,
    ARCHAREA_PCTUSED      NUMBER,
    ARCHAREA_SEVERITY     NUMBER,
    DUMPAREA_PCTUSED      NUMBER,
    DUMPAREA_SEVERITY     NUMBER,
    ALERTLOG_TIMESTAMP    DATE,
    ALERTLOG_SEVERITY     NUMBER,
    HOST_NAME             VARCHAR2(64),
    TARGET_GUID           VARCHAR2(32),
    DUP_SQL_COUNT         NUMBER,
    RESPONSE_SEVERITY     NUMBER,
    TOP_SQL_COUNT         NUMBER,
    STG_PERF_COUNT        NUMBER,
    STG_PERF_SEVERITY     NUMBER,
    ARCH_COUNT            NUMBER,
    BADARCH_COUNT         NUMBER,
    LISTENER_NAME         VARCHAR2(4000),
    MTTR                  NUMBER,
    ASM_TARGET_NAME       VARCHAR2(64),
    DB_REGISTERED_WITH_HAS VARCHAR2(32),
    KEYPROFILE_COUNT      NUMBER,
    KEYPROFILE_ENABLE     VARCHAR2(32),
    AUTO_IMPL_ENABLE     VARCHAR2(32)
);
/
create or replace type SMP_EMD_DBSITEMAP_COMMON_OBJ as OBJECT (
    TARGET_GUID           VARCHAR2(32),
    DB_SIZE               NUMBER,
    DG_ROLE               VARCHAR2(64),
    PRMY_EM_NAME          VARCHAR2(64),
    PRMY_TYPE             VARCHAR2(64),
    BACKUP_STATUS         VARCHAR2(64),
    BACKUP_TIMESTAMP      DATE,
    FLASHBACK_TIMESTAMP   DATE,
    RECOVERY_PERCENT      NUMBER,
    FLASH_RECOVERY_AREA   VARCHAR2(512),
    LOG_MODE              VARCHAR2(32),
    FLASHBACK_ON          VARCHAR2(32),
    CELL_COUNT            VARCHAR2(512)
);
/