Rem
Rem $Header: db_schema_downgrade_11000.sql 08-apr-2008.14:09:21 rsamaved Exp $
Rem
Rem db_schema_downgrade_11000.sql
Rem
Rem Copyright (c) 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      db_schema_downgrade_11000.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    rsamaved    04/08/08 - 
Rem    kramarat    02/06/08 - Downgrade to 11.0
Rem    kramarat    02/06/08 - Created
Rem

Rem
Rem SMP_EMD_DBSITEMAP_OBJ
Rem

drop type SMP_EMD_DBSITEMAP_OBJ;

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)
);
/