Rem drv: <create type="views" pos="storage/storage_database_views.sql+"/>
Rem
Rem $Header: rac_views.sql 08-feb-2007.11:11:25 ajdsouza Exp $
Rem
Rem rac_views.sql
Rem
Rem Copyright (c) 2004, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      rac_views.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    ajdsouza    11/20/06 - bug fix #5647975
Rem    ajdsouza    08/22/06 - bug fix #5087180
Rem    xuliu       08/25/05 - add status column 
Rem    chyu        06/28/05 - New repmgr header impl 
Rem    xuliu       05/10/05 - review chg 
Rem    xuliu       04/07/05 - intrcon view 
Rem    xuliu       01/05/05 - xuliu_bug-4092412_main
Rem    xuliu       12/28/04 - Created
Rem

-- Create network view that contains the stats of interfaces
CREATE OR REPLACE VIEW MGMT$INTERFACE_STATS AS
SELECT tguid,
       hostname,
       targetname,
       ifname,
       totrate,
       toterr,
       inrate,
       collection_timestamp
FROM TABLE ( EMD_RAC.INTERFACE_STATS() )
/


-- View to expose rac database interconnect stats
CREATE OR REPLACE VIEW mgmt$racdb_interconnects
AS
SELECT
 CLUSTER_NAME,    
 DB_TARGET    ,   
 INSTANCE_TARGET, 
 INSTANCE_STATUS,
 DB_NAME,         
 SID     ,        
 IF_NAME  ,   
 HOST_NAME ,      
 IF_IP      , 
 IF_PUBLIC   ,
 IF_SOURCE   ,
 XFERRATE_5MIN,   
 CURR_WARNING  ,  
 CURR_CRITICAL  , 
 LATEST_COLLECTION_TIMESTAMP 
FROM TABLE ( EMD_RAC.RACDB_INTERCONNECTS() )
/

-- View to expose cluster interconnects
CREATE OR REPLACE VIEW MGMT$CLUSTER_INTERCONNECTS
AS
SELECT
 CLUSTER_NAME ,
 HOST_NAME    ,
 HOST_STATUS  ,
 IF_NAME      ,
 IF_SUBNET    ,
 IF_PUBLIC    ,
 TOTRATE_5MIN ,
 TOTERR_5MIN  ,
 INRATE_5MIN  ,
 CURR_WARNING ,
 CURR_CRITICAL,
 LATEST_COLLECTION_TIMESTAMP
FROM TABLE ( EMD_RAC.CLS_INTERCONNECTS() )
/