Rem drv: <create type="types"/>
Rem
Rem $Header: osm_types.sql 11-jul-2007.09:14:14 qsong Exp $
Rem
Rem osm_types.sql
Rem
Rem Copyright (c) 2002, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      osm_types.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    qsong       06/05/07 - add dg usage size for SMP_EMD_NONEOFS_VOL
Rem    qsong       05/18/07 - add usage to SMP_EMD_NONEOFS_VOL
Rem    gmahaney    02/01/07 - XbranchMerge gmahaney_emdb_pt_main from main
Rem    qsong       01/03/07 - add corrupt to SMP_EMD_ASM_SERVED_OFS_ARRAY type
Rem    qsong       04/11/06 - New OFS related object types
Rem    chyu        06/28/05 - New repmgr header impl 
Rem    jochen      07/13/04 - Handle null start date 
Rem    jochen      06/14/04 - Add versioning 
Rem    jochen      05/13/04 - Make alertLogTimestamp, instanceStartTime dates
Rem    spanchum    10/14/02 - spanchum_osm_homepage
Rem    spanchum    10/07/02 - Created
Rem

create or replace type SMP_EMD_OSMSITEMAP_OBJ as OBJECT (
    TYPE_DISPLAY_NAME     VARCHAR2(256),
    LAST_UPDATED_TIME     VARCHAR2(4000),
    CURRENT_STATUS        INTEGER,
    AVAIL_PCT             NUMBER,
    START_TIMESTAMP       Date,
    INSTANCE_NAME         VARCHAR2(1024),
    INSTANCE_STARTTIME    DATE,
    INSTANCE_STARTSTR     VARCHAR2(1024),
    INSTANCE_VERSION      VARCHAR2(1024),
    ALERTLOG_TIMESTAMP    DATE,
    ALERTLOG_SEVERITY     NUMBER,
    HOST_NAME             VARCHAR2(64),    
    TARGET_GUID           VARCHAR2(32),
    META_VER              VARCHAR2(8),
    CAT_PROP_1            VARCHAR2(64),
    CAT_PROP_2            VARCHAR2(64),
    CAT_PROP_3            VARCHAR2(64),
    CAT_PROP_4            VARCHAR2(64),
    CAT_PROP_5            VARCHAR2(64)
);
/

CREATE or replace TYPE SMP_EMD_CLUSTER_OFS_OBJ AS OBJECT(
    OFS_VOLUME_DEVICE     VARCHAR2(256),
    OFS_NAME              VARCHAR2(256),
    OFS_UP_NUM            NUMBER,
    OFS_DOWN_NUM          NUMBER,
    OFS_MOUNTED_NUM       NUMBER,
    OFS_DISMOUNTED_NUM    NUMBER,
    OFS_WARNING_ALERTS    NUMBER,
    OFS_CRITICAL_ALERTS   NUMBER,
    DG_ALLOC_SIZE_GB      NUMBER,
    OFS_SIZE_GB           NUMBER,
    OFS_USED_GB           NUMBER,
    OFS_USED_PCT          NUMBER);
/

CREATE or replace TYPE SMP_EMD_CLUSTER_OFS_OBJ_ARRAY AS TABLE OF SMP_EMD_CLUSTER_OFS_OBJ;
/

CREATE or replace TYPE SMP_EMD_ASM_SERVED_OFS AS OBJECT(
    MOUNT_POINT           VARCHAR2(256),
    AVAILABILITY          VARCHAR2(256),
    CORRUPT               VARCHAR2(256),
    OFS_STATE             VARCHAR2(256),
    OFS_VOLUME_NAME       VARCHAR2(256),
    OFS_VOLUME_DEVICE     VARCHAR2(256),
    OFS_DISKGROUP         VARCHAR2(256),
    DG_ALLOC_SIZE_GB      NUMBER,
    OFS_SIZE_GB           NUMBER,
    OFS_USED_GB           NUMBER,
    OFS_USED_PCT          NUMBER);
/

CREATE or replace TYPE SMP_EMD_ASM_SERVED_OFS_ARRAY AS TABLE OF SMP_EMD_ASM_SERVED_OFS;
/

CREATE or replace TYPE SMP_EMD_NONEOFS_VOL AS OBJECT(
    VOLUME_NAME           VARCHAR2(30),
    VOLUME_DEVICE         VARCHAR2(256),
    VOLUME_USAGE          VARCHAR2(30),
    VOLUME_STATE          VARCHAR2(8),
    VOLUME_DISKGROUP      VARCHAR2(30),
    SIZE_GB               NUMBER,
    DG_ALLOC_SIZE_GB      NUMBER,
    REDUNDANCY            VARCHAR2(8));
/

CREATE or replace TYPE SMP_EMD_NONEOFS_VOL_ARRAY AS TABLE OF SMP_EMD_NONEOFS_VOL;
/

CREATE or replace TYPE SMP_EMD_OFSHOSTS_INFO AS OBJECT(
    HOST_NAME            VARCHAR2(256),
    HOST_STATUS          NUMBER,
    OFS_STATUS           VARCHAR2(256),
    UP_SINCE             VARCHAR2(256),
    OFS_STATE            VARCHAR2(256),
    ASM_INST             VARCHAR2(256),
    ASM_STATUS           NUMBER,
    DISK_GROUP           VARCHAR2(256));
/

CREATE or replace TYPE SMP_EMD_OFSHOSTS_INFO_ARRAY AS TABLE OF SMP_EMD_OFSHOSTS_INFO;
/