Rem drv: <create type="tables"/>
Rem
Rem $Header: hdm_tables.sql 11-sep-2006.12:22:47 kdas Exp $
Rem
Rem hdm_tables.sql
Rem
Rem Copyright (c) 2003, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      hdm_tables.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    kdas        06/01/06 - support for enhanced metrics for ADDM 
Rem    chyu        06/28/05 - New repmgr header impl 
Rem    rpinnama    06/12/04 - Remove SET ECHO 
Rem    rpinnama    07/23/03 - Fix \ in comments
Rem    skini       07/01/03 - Fixes for blocksize reduction
Rem    kdas        05/06/03 - support no findings for task
Rem    kdas        04/23/03 - kdas_hdm_metric042103
Rem    kdas        04/21/03 - Created
Rem


CREATE TABLE MGMT_DB_LATEST_HDM_FINDINGS (
    TARGET_GUID RAW(16) NOT NULL,
    COLLECTION_TIMESTAMP DATE DEFAULT SYSDATE,
    TASK_ID NUMBER NOT NULL, 
    FINDING_ID NUMBER NOT NULL,
    REC_TYPE VARCHAR2(1024),
    REC_COUNT NUMBER,
    IMPACT_PCT NUMBER,
    MESSAGE VARCHAR2(4000),
    START_TIME DATE,
    END_TIME DATE,
    FINDING_COUNT NUMBER,
    FINDING_NAME VARCHAR2(4000),
    ACTIVE_SESSIONS NUMBER,
    INSTANCE_COUNT NUMBER,
    CONSTRAINT MGMT_DB_LATEST_HDM_FINDINGS PRIMARY KEY(TARGET_GUID, 
TASK_ID,FINDING_ID,REC_TYPE))
    MONITORING;


CREATE TABLE MGMT_DB_HDM_METRIC_HELPER (
    TARGET_GUID RAW(16) NOT NULL,
    COLLECTION_TIMESTAMP DATE DEFAULT SYSDATE,
    TASK_AVAILABLE NUMBER NOT NULL,
    TASK_COUNT NUMBER,
    REQUESTED_ANALYSIS VARCHAR2(8) ,
    CONSTRAINT MGMT_DB_HDM_METRIC_HELPER PRIMARY KEY(TARGET_GUID))
    MONITORING;