Rem
Rem $Header: bsln_views.sql 13-jul-2005.23:29:11 gsbhatia Exp $
Rem
Rem bsln_views.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      bsln_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    gsbhatia    06/26/05 - New repmgr header impl 
Rem    gsbhatia    02/13/05 - updating repmgr header 
Rem    gsbhatia    02/09/05 - updating repmgr header 
Rem    gsbhatia    02/07/05 - updating repmgr header 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    jberesni    10/06/04 - jberesni_metadata01
Rem    jberesni    10/06/04 - Created
Rem

Rem *********************************************************************
Rem  EM_adaptive_thresholds
Rem
Rem  10gR2 meta-data about metrics that are baselined will insert
Rem  through this view to update the has_active_baseline flag column.
Rem  This view is not for common usage.
Rem
Rem *********************************************************************

create or replace view EM_adaptive_thresholds
   (target_guid
   ,target_type
   ,metric_name
   ,metric_column
   ,key_value
   ,has_active_baseline
   )
as
SELECT DISTINCT
       pa.object_guid
      ,m.target_type
      ,m.metric_name
      ,m.metric_column
      ,pac.key_value
      ,pac.has_active_baseline
  FROM 
       mgmt_metrics                 m
      ,mgmt_policies                p
      ,mgmt_policy_assoc            pa
      ,mgmt_policy_assoc_cfg        pac
 WHERE 
       m.metric_guid = p.policy_guid
   AND p.policy_guid = pa.policy_guid
   AND pa.policy_guid = pac.policy_guid
   AND pa.object_guid = pac.object_guid
   AND pa.coll_name = pac.coll_name
   AND p.policy_type = 1
   AND pa.object_type = 2
   AND p.condition_type = 1
/