Rem drv: <create type="views" pos="config/config_views.sql+"/>
Rem ----------------------------------------------------------------------------
Rem
Rem $Header: feature_usage_views.sql 28-jun-2005.11:36:51 chyu Exp $
Rem
Rem feature_usage_views.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      feature_usage_views.sql - Database Feature Usage repository view
Rem
Rem    DESCRIPTION
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    chyu        06/28/05 - New repmgr header impl 
Rem    xshen       05/19/03 - dbconfig cut over to snapshot
Rem    jstone      04/29/03 - beta 2 revisions
Rem    jstone      03/24/03 - jstone_030324_feature_usage_search
Rem    jstone      03/21/03 - Created
Rem
Rem ----------------------------------------------------------------------------

Rem ----------------------------------------------------------------------------
Rem          D a t a b a s e   F e a t u r e   U s a g e   V i e w
Rem ----------------------------------------------------------------------------

CREATE OR REPLACE VIEW MGMT$DB_FEATUREUSAGE AS
select
  h.host_name as host,
  h.target_name as database_name,
  i.instance_name as instance_name,
  h.target_type   as target_type,
  f.DBID,
  f.NAME,
  f.CURRENTLY_USED,
  f.DETECTED_USAGES,
  f.FIRST_USAGE_DATE,
  f.LAST_USAGE_DATE,
  f.VERSION,
  f.LAST_SAMPLE_DATE,
  f.LAST_SAMPLE_PERIOD,
  f.TOTAL_SAMPLES,
  f.AUX_COUNT,
  f.DESCRIPTION
from
  mgmt_db_featureusage f,
  mgmt_targets h,
  mgmt_db_dbninstanceinfo_ecm i,
  mgmt_ecm_gen_snapshot s
where
  s.is_current = 'Y' and
  s.snapshot_guid = i.ecm_snapshot_id and
  s.target_guid = h.target_guid and
  s.target_guid = f.target_guid;

Rem ----------------------------  End of File  ---------------------------------