Rem
Rem $Header: eml_schema_downgrade_10.1.sql 29-nov-2006.13:58:33 ychan Exp $
Rem
Rem eml_schema_downgrade_10.1.sql
Rem
Rem Copyright (c) 2006, Oracle.  All rights reserved.  
Rem
Rem    NAME
Rem      eml_schema_downgrade_10.1.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      This script is used for downgrading from 11/10.2 to 10.1
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    ychan    12/12/06 - Created
Rem

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

DROP type SMP_EMD_DBSITEMAP_OBJ;
DROP type SMP_EMD_DBSITEMAP_COMMON_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),
    OPEN_MODE             VARCHAR2(64),
    LOAD                  NUMBER,
    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,
    OTHER_COUNT           NUMBER,
    OTHER_SEVERITY        NUMBER,
    HOST_NAME             VARCHAR2(64),
    CPU_USAGE_PCT         NUMBER,
    CPU_USAGE_SEVERITY    NUMBER,
    MEMORY_USAGE_PCT      NUMBER,
    MEMORY_USAGE_SEVERITY NUMBER,
    DISK_IO_COUNT         NUMBER,
    DISK_IO_SEVERITY      NUMBER,
    HOST_STATUS           NUMBER,
    TARGET_GUID           VARCHAR2(32),
    DUP_SQL_COUNT         NUMBER,
    RESPONSE_TIME         NUMBER,
    RESPONSE_SEVERITY     NUMBER,
    TOP_SQL_COUNT         NUMBER,
    STG_PERF_COUNT        NUMBER,
    STG_PERF_SEVERITY     NUMBER,
    ACTIVE_SESS_COUNT     NUMBER,
    USER_CPU_TIME_PCT     NUMBER,
    USERIO_WAIT_PCT       NUMBER,
    OTHER_WAIT_PCT        NUMBER,
    AVG_INST_CPU          NUMBER,
    RUN_QUEUE             NUMBER,
    PAGING_RATE           NUMBER,
    ARCH_COUNT            NUMBER,
    BADARCH_COUNT         NUMBER
);
/