<!-- $Header: emdb/sysman/admin/default_collection/database.xmlp /st_emdbsa_11.2/17 2009/07/14 22:50:18 prjaiswa Exp $
   MODIFIED    (MM/DD/YY)
      prjaiswa  07/13/09 - textIndexstats increase collection time interval
      rsamaved  07/08/09 - increase collection frequency for upload_on_fetch
                           metric
      sshastry  04/24/09 - Bug fix: 7208274. Added metric aq_msgs_bufferedqueue
      sudvarma  03/24/09 - To fix bug-8234380 - Introducing collection for
                           esm_dirObjUsersWithExeAndOtherPrivs and
                           esm_publicHavingExePrivOnDirObj
      keiwong   02/05/09 - support db replay alerts
      ngade     02/02/09 - Code slap 10.2.0.5.0 -> 11.2 round 2
      hpalitan  01/27/09 - Add Database Vault Metrics
      sshastry  01/22/09 - Forward merge from 10.2.0.5.0GC to 11.2 SA
      yemeng    12/22/08 - add key sql profile
      allison  12/04/08 - Allow hadg1_collection to run on standby
      ajdsouza  02/17/09 - added resource_name and ishasmanaged metric collections
      mmootha   09/22/08 - 
      ngade     08/12/08 - Code slap 10.2.0.5GC -> 112SA
      sshastry  06/04/08 - Changes for streams/aq metrics
      rsamaved  05/08/08 - add 11gR2 version
      yma       03/20/07 - Remove schedule for server generated metrics 
      pbantis   03/09/07 - ha_flashrecovery 15 min col interval.
      ganessub  02/08/07 - TextStatistics threshhold
      manosing  01/12/07 - XbranchMerge manosing_lastpols from main
      manosing  11/07/06 - 
      dsukhwal  10/25/06 - add proxy account metric
      dsukhwal  10/30/06 - add audit insert failure metric
      ngade     09/11/06 - add observer 11g metric
      jsoule    08/31/06 - support 11gR1 version
      sjconnol  08/18/06 - ha_dg_target_summary metric
      ngade     04/05/06 - fix dg bug 5097532 
      jsoule    03/28/06 - support versions > 10gR2 
      sresrini  01/12/06 - bug 4926840 
      hying     09/07/05 - Datafiles with Error 
      hying     08/22/05 - ha_recovery CRITICAL, not WARNING 
      sjconnol  08/03/05 - Change observer metric
      kramarat  07/29/05 - Add collection pattern for DGPrimaryDBName 
      kramarat  07/15/05 - Add new metric for Observer 
      rreilly   07/12/05 - bug 4145603 tbspAllocation needs to account 
                           correctly for undo 
      gallison  06/16/05 - Fix FSFO collection 
      rreilly   06/15/05 - problemTbsp_10i_Loc needs validif 
      rreilly   05/09/05 - bug 4129031 combine 10g problemTbsp collection 
      rreilly   04/14/05 - add audit_failed_logins_historical collection 
      gallison  04/06/05 - Remove dg thresholds 
      mnihalan  03/16/05 - Change frequency of segment_advisor_count 
      mnihalan  03/14/05 - Change frequency of segment_advisor_count 
      sshastry  03/02/05 - Changes to add Streams topology metrics 
      gallison  02/25/05 - Rename dg metrics 
      ysun      02/16/05 - update with the split
      rreilly   11/11/04 - add tbspAllocation metric 
      rreilly   11/04/04 - bug 3978294 
      gallison  10/29/04 - DG Support 
      pbantis   10/01/04 - Add haconfig3_collection. 
      rreilly   09/28/04 - default threshold comparator for problemTbsp metric 
                           to GE 
      rreilly   08/20/04 - bug 3824092 fix collection of oracle_dbconfig for 
                           rac 
      rreilly   08/12/04 - bug 3264676 remove Invalid Objects metric 
      rreilly   08/02/04 - enh 3062024 problemTbsp bytesFree support 
      rreilly   07/26/04 - only collect policy info once per week 
      ychan     07/12/04 - Remove 10gBeta 
      rreilly   06/26/04 - add free space metric 
      mnihalan  06/25/04 - Add segment Advisor Count 
      jochen    05/26/04 - Add 10gR2 
      jochen    05/26/04 - Add param to StgPerf 
      sbadrina  05/06/04 - add cf size 
      ysun      04/29/04 - ysun_metadata_split
      ysun      04/26/04 - creation
-->


  <!--
  ======================================================================
  == Category: Tablespaces Full - 9i and earlier
  == Fetchlet: Perl
  ======================================================================
    -->
  <CollectionItem NAME="problemTbsp_9i">
    <ValidIf>
       <CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="30" TIME_UNIT="Min"/>
    </Schedule>

    <MetricColl NAME="problemTbsp">
      <!--
      ====================================================================
      == Alert: Tablespace Space Used (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="pctUsed"
                 CRITICAL="97" WARNING="85" OPERATOR="GE"
                 MESSAGE="Tablespace [%name%] is [%value% percent] full"
                 MESSAGE_NLSID="problemTbsp_pctUsed_alertmessage" />

      <!--
      ====================================================================
      == Alert: Tablespace Free Space (MB)
      ====================================================================
        -->
      <Condition COLUMN_NAME="bytesFree"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LE"
                 MESSAGE="Tablespace [%name%] has [%value% mbytes] free"
                 MESSAGE_NLSID="problemTbsp_bytesFree_alertmessage" />

    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Category: Tablespaces Full - 10i - locally managed
  ======================================================================
    -->
  <CollectionItem NAME="problemTbsp_10i_Loc">
    <ValidIf>
       <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>

    <MetricColl NAME="problemTbsp">
      <!--
      ====================================================================
      == Alert: Tablespace Space Used (%)
      ====================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="pctUsed"
                 CRITICAL="97" WARNING="85" OPERATOR="GE" />
      <!--
      ====================================================================
      == Alert: Tablespace Free Space (MB)
      ====================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="bytesFree"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LE" />
    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Category: Tablespaces Full - 10i - dictionary managed
  == Fetchlet: Perl
  ======================================================================
    -->
  <CollectionItem NAME="problemTbsp_10i_Dct">
    <ValidIf>
       <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="30" TIME_UNIT="Min"/>
    </Schedule>

    <MetricColl NAME="problemTbsp10iDct">
      <!--
      ====================================================================
      == Alert: Tablespace Space Used (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="pctUsed"
                 CRITICAL="97" WARNING="85" OPERATOR="GE"
                 MESSAGE="Tablespace [%name%] is [%value% percent] full"
                 MESSAGE_NLSID="problemTbsp10iDct_pctUsed_alertmessage" />

      <!--
      ====================================================================
      == Alert: Tablespace Free Space (MB)
      ====================================================================
        -->
      <Condition COLUMN_NAME="bytesFree"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LE"
                 MESSAGE="Tablespace [%name%] has [%value% mbytes] free"
                 MESSAGE_NLSID="problemTbsp10iDct_bytesFree_alertmessage" />

    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Category: Tablespaces With Problem Segments
  == Fetchlet: Perl
  ======================================================================
    -->
  <CollectionItem NAME="problemSegTbsp">
    <Schedule>
      <IntervalSchedule INTERVAL="24" TIME_UNIT="Hr"/>
    </Schedule>

    <!--
    ====================================================================
    == Alert: Segments Unable to Extend Count
    ====================================================================
      -->
    <Condition COLUMN_NAME="segsChunkSmlCnt"
               WARNING="0" OPERATOR="GT"
               MESSAGE="%value% segments in %name% tablespace unable to extend."
               MESSAGE_NLSID="problemSegTbsp_segsChunkSmlCnt_alertmessage" />

    <!--
    ====================================================================
    == Alert: Segments Approaching MaxExtents Count
    ====================================================================
      -->
    <Condition COLUMN_NAME="segsMaxExtsCnt"
               WARNING="0" OPERATOR="GT"
               MESSAGE="%value% segments in %name% tablespace approaching max extents."
               MESSAGE_NLSID="problemSegTbsp_segsMaxExtsCnt_alertmessage" />
  </CollectionItem>

  <!-- *************************************** -->
  <!-- Start of db rec storage snap item collection -->
  <CollectionItem NAME="oracle_storage" UPLOAD_ON_FETCH="TRUE" CONFIG="TRUE">

     <Schedule>
      <IntervalSchedule INTERVAL = "24" TIME_UNIT = "Hr"/>
     </Schedule>

     <MetricColl NAME="db_recUserSettings"/>
     <MetricColl NAME="db_recTablespaceSettings"/>
     <MetricColl NAME="db_recSegmentSettings"/>
     <MetricColl NAME="db_recSegmentSettings_sysseg"/>

  </CollectionItem>


  <!-- *************************************** -->
  <!-- Start of db rec object snap item collection -->

  <!-- collection: oracle_object                        -->
  <!-- metric:     db_invalidObjects                    -->
  <!-- rreilly Removed on Aug 12, 2004 for bug 3264676 -->

  <CollectionItem NAME = "observer" UPLOAD="NO">
    <ValidIf>
       <CategoryProp NAME="VersionCategory" CHOICES="10gR2;10gR203"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
    </Schedule>
    <MetricColl NAME="observer">
    <Condition COLUMN_NAME="ob_status"
               CRITICAL="Error" OPERATOR="CONTAINS"
               MESSAGE="The Data Guard fast-start failover observer status is %value%."
               MESSAGE_NLSID="ob_status_alertmessage" />
    </MetricColl>
  </CollectionItem>

  <CollectionItem NAME = "observer_11g" UPLOAD="NO">
    <ValidIf>
       <CategoryProp NAME="VersionCategory" CHOICES="11gR1;11gR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL = "1" TIME_UNIT = "Min"/>
    </Schedule>
    <MetricColl NAME="observer_11g">
    <Condition COLUMN_NAME="ob_status"
               CRITICAL="Error" OPERATOR="CONTAINS"
               MESSAGE="The Data Guard fast-start failover observer status is %value%."
               MESSAGE_NLSID="ob_status_alertmessage" />
    </MetricColl>
  </CollectionItem>

  <CollectionItem NAME = "dataguard_10g">
    <ValidIf>
       <CategoryProp NAME="VersionCategory" CHOICES="10gR1"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
    </Schedule>
    <MetricColl NAME="dataguard10">
    <Condition COLUMN_NAME="dg_dnr1"
               WARNING="1" CRITICAL="3" OPERATOR="GT"
               MESSAGE="Standby database %dg_name% has not received the last %value% logs from the primary database."
               MESSAGE_NLSID="dg_dnr1_alertmessage" />
    <Condition COLUMN_NAME="dg_dnr2"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               MESSAGE="Standby database %dg_name% has not received the last %value% megabytes of data from the primary database."
               MESSAGE_NLSID="dg_dnr2_alertmessage" />
    <Condition COLUMN_NAME="dg_dna1"
               WARNING="1" CRITICAL="3" OPERATOR="GT"
      	       MESSAGE="Standby database %dg_name% has not applied the last %value% received logs."
               MESSAGE_NLSID="dg_dna1_alertmessage" />
    <Condition COLUMN_NAME="dg_dna2"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               MESSAGE="Standby database %dg_name% has not applied the last %value% megabytes of data received."
               MESSAGE_NLSID="dg_dna2_alertmessage" />
    <Condition COLUMN_NAME="dg_status"
               WARNING="Warning" CRITICAL="Error" OPERATOR="CONTAINS"
               MESSAGE="The Data Guard status of %dg_name% is %value%."
               MESSAGE_NLSID="dg_status_alertmessage" />
    </MetricColl>
  </CollectionItem>

  <CollectionItem NAME="dgprimarydb_collection" COLLECT_WHEN_ALTSKIP="TRUE">
    <Schedule>
      <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
    </Schedule>
    <MetricColl NAME="DGPrimaryDBName"/>
  </CollectionItem>


  <CollectionItem NAME = "dataguard_9i">
    <ValidIf>
       <CategoryProp NAME="VersionCategory" CHOICES="9iR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
    </Schedule>
    <MetricColl NAME="dataguard9">
    <Condition COLUMN_NAME="dg_dnr1"
               WARNING="1" CRITICAL="3" OPERATOR="GT"
               MESSAGE="Standby database %dg_name% has not received the last %value% logs from the primary database."
               MESSAGE_NLSID="dg_dnr1_alertmessage" />
    <Condition COLUMN_NAME="dg_dna1"
               WARNING="1" CRITICAL="3" OPERATOR="GT"
      	       MESSAGE="Standby database %dg_name% has not applied the last %value% received logs."
               MESSAGE_NLSID="dg_dna1_alertmessage" />
    <Condition COLUMN_NAME="dg_status"
               WARNING="Warning" CRITICAL="Error" OPERATOR="CONTAINS"
               MESSAGE="The Data Guard status of %dg_name% is %value%."
               MESSAGE_NLSID="dg_status_alertmessage" />
    </MetricColl>
  </CollectionItem>
  <CollectionItem NAME = "dataguard_10gR2" COLLECT_WHEN_ALTSKIP="TRUE">
    <ValidIf>
       <CategoryProp NAME="VersionCategory" CHOICES="10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
    </Schedule>
    <MetricColl NAME="dataguard">
    <Condition COLUMN_NAME="dg_status"
               WARNING="Warning" CRITICAL="Error" OPERATOR="CONTAINS"
               MESSAGE="The Data Guard status of %dg_name% is %value%."
               MESSAGE_NLSID="dg_status_alertmessage" />
    </MetricColl>
    <MetricColl NAME="dataguard_sperf">
    <Condition COLUMN_NAME="dg_fot"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               MESSAGE="The estimated time to failover is approximately %value% seconds."
               MESSAGE_NLSID="dg_fot_alertmessage" />
    <Condition COLUMN_NAME="dg_lag"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               MESSAGE="The standby database is approximately %value% seconds behind the primary database."
               MESSAGE_NLSID="dg_lag_alertmessage" />
    <Condition COLUMN_NAME="dg_pdl"
               WARNING="NotDefined" CRITICAL="NotDefined" OPERATOR="GT"
               MESSAGE="There are approximately %value% seconds of redo not yet available on this standby database."
               MESSAGE_NLSID="dg_pdl_alertmessage" />
    <Condition COLUMN_NAME="dg_redo_arate_KB"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               MESSAGE="The redo apply rate is %value% KB/sec"
               MESSAGE_NLSID="dg_rar_alertmessage" />
    </MetricColl>
    <MetricColl NAME="dataguard_pperf">
    <Condition COLUMN_NAME="dg_redo_rate_KB"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               MESSAGE="The redo generation rate is %value% KB/sec"
               MESSAGE_NLSID="dg_rr_alertmessage" />
    </MetricColl>
  </CollectionItem>

  <CollectionItem NAME = "dataguard_10gR2_fsfo" COLLECT_WHEN_ALTSKIP="TRUE" UPLOAD="NO" >
    <ValidIf>
       <CategoryProp NAME="VersionCategory" CHOICES="10gR2;10gR203"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
    </Schedule>
    <MetricColl NAME="dataguard_fsfo">
    <Condition COLUMN_NAME="dg_fs"
               WARNING="" CRITICAL="1" OPERATOR="EQ"
               MESSAGE="A fast-start failover occurred at %dg_fs_time%."
               CLEAR_MESSAGE="CLEARED - Fast-start failover."
               CLEAR_MESSAGE_NLSID="dg_fsfo_alertmessage_clear"
               MESSAGE_NLSID="dg_fsfo_alertmessage" />              
    </MetricColl>
  </CollectionItem>

  <CollectionItem NAME="hadg1_collection" COLLECT_WHEN_ALTSKIP="TRUE">
    <Schedule>
      <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
    </Schedule>
    <MetricColl NAME="ha_dg_target_summary"/>
  </CollectionItem>

  <!--
  ======================================================================
  == Group: activity_pending
  ======================================================================
    -->
  <CollectionItem NAME="activity_pending" UPLOAD="NO">
    <Schedule>
      <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>

    <!--
    ====================================================================
    == Category: Suspended Session
    == Fetchlet: SQL
    ====================================================================
      -->
    <MetricColl NAME="suspended_session">

      <!--
      ==================================================================
      == Alert: Suspended Session Count
      ==================================================================
      -->
      <Condition COLUMN_NAME="count"
                 WARNING="0" OPERATOR="GT"
                 MESSAGE="%value% session(s) are suspended."
                 MESSAGE_NLSID="suspended_session_count_alertmessage" />

    </MetricColl>

    <!--
    ====================================================================
    == Category: Deferred Transactions
    == Fetchlet: SQL
    ====================================================================
    -->
    <MetricColl NAME="DeferredTrans">

      <!--
      ==================================================================
      == Alert: Deferred Transaction Error Count
      ==================================================================
        -->
      <Condition COLUMN_NAME="errortrans_count"
                 WARNING="0" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="Number of deferred transactions with errors is %value%."
                 MESSAGE_NLSID="DeferredTrans_errortrans_count_alertmessage"/>

      <!--
      ==================================================================
      == Alert: Deferred Transaction Count
      ==================================================================
        -->
      <Condition COLUMN_NAME="deftrans_count"
                 WARNING="100" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="Number of deferred transactions is %value%."
                 MESSAGE_NLSID="DeferredTrans_deftrans_count_alertmessage"/>

    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Category: Recovery_Area
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="Recovery_Area">

    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>

    <Schedule>
      <IntervalSchedule INTERVAL="15" TIME_UNIT="Min"/>
    </Schedule>

  </CollectionItem>

  <!--
  ======================================================================
  == Group: invalid_objects_rollup
  ======================================================================
    -->
  <CollectionItem NAME="invalid_objects_rollup" UPLOAD="NO">
    <Schedule>
      <IntervalSchedule INTERVAL="24" TIME_UNIT="Hr"/>
    </Schedule>

    <!--
    ====================================================================
    == Category: Invalid Objects per Schema
    == Fetchlet: SQL
    ====================================================================
    -->
    <MetricColl NAME="invalid_objects">

      <!--
      ==================================================================
      == Alert: Owner's Invalid Object Count
      ==================================================================
        -->
      <Condition COLUMN_NAME="count"
                 WARNING="2" OPERATOR="GT"
                 MESSAGE="%value% object(s) are invalid in the %owner% schema."
                 MESSAGE_NLSID="invalid_objects_count_alertmessage" />
    </MetricColl>

    <!--
    ====================================================================
    == Category: Invalid Objects
    == Fetchlet: Aggregate
    ====================================================================
      -->
    <MetricColl NAME="all_invalid_objects">

      <!--
      ==================================================================
      == Alert: Total Invalid Object Count
      ==================================================================
        -->
      <Condition COLUMN_NAME="total_count"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 MESSAGE="%value% object(s) are invalid in the database."
                 MESSAGE_NLSID="all_invalid_objects_total_count_alertmessage" />
    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Category: Database Job Status
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="dbjob_status" UPLOAD="NO">
    <Schedule>
      <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>

    <!--
    ====================================================================
    == Alert: Broken Job Count
    ====================================================================
      -->
    <Condition COLUMN_NAME="broken"
               WARNING="0" OPERATOR="GT"
               MESSAGE="%value% job(s) are broken."
               MESSAGE_NLSID="dbjob_status_broken_alertmessage" />

    <!--
    ====================================================================
    == Alert: Failed Job Count
    ====================================================================
      -->
    <Condition COLUMN_NAME="failed"
               WARNING="0" OPERATOR="GT"
               MESSAGE="%value% job(s) have failed."
               MESSAGE_NLSID="dbjob_status_failed_alertmessage" />
  </CollectionItem>



  <!--
  ======================================================================
  == Category: Tablespace Allocation
  == DB Versions: pre-8 to 10gR1
  == Fetchlet: SQL
  ======================================================================
  -->
  <CollectionItem NAME="tbspAllocation">
    <ValidIf>
     	<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2;10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>

    <Schedule>
      <IntervalSchedule INTERVAL="7" TIME_UNIT="Day"/>
    </Schedule>

    <MetricColl NAME="tbspAllocation" />
  </CollectionItem>



  <!-- ==========================================
       Start of feature usage collection
       ==========================================
    -->
  <CollectionItem
    NAME="feature_usage_collection_item">

    <Schedule>
      <IntervalSchedule
        INTERVAL = "24"
        TIME_UNIT = "Hr"/>
    </Schedule>

    <MetricColl
      NAME="db_FeatureUsage"/>

  </CollectionItem>
  <!-- ==========================================
       End of feature usage collection
       ==========================================
    -->

  <!--
  ======================================================================
  == Category: Storage Problems Affecting Performance
  == Fetchlet: Perl
  ======================================================================
  -->
  <CollectionItem NAME="StgPerf" UPLOAD_ON_FETCH="TRUE" >
    <Schedule>
      <IntervalSchedule INTERVAL="3" TIME_UNIT="Day"/>
    </Schedule>

    <MetricColl NAME="wastedSpace">
      <ItemProperty NAME="tsNames">;</ItemProperty>
      <ItemProperty NAME="schemas">;</ItemProperty>
      <ItemProperty NAME="wasteMinValue">50</ItemProperty>
      <ItemProperty NAME="rcMinValue">10</ItemProperty>
      <ItemProperty NAME="ckWasteSpc">false</ItemProperty>
      <ItemProperty NAME="ckRowChain">false</ItemProperty>
      <ItemProperty NAME="minSegSize">-1</ItemProperty>
    </MetricColl>
    <MetricColl NAME="recSettingsPurge">
      <ItemProperty NAME="metricName">wastedSpace</ItemProperty>
    </MetricColl>

  </CollectionItem>

  <!-- *************************************** -->
  <!-- Start of db config snap item collection -->
  <!-- rreilly Removed collection of db_datafiles             -->
  <!--         no longer used per VP request April 28, 2004   -->
  <!-- rreilly 040820 move oracle_dbconfig into instance.xmlp -->

  <CollectionItem NAME="haconfig1_collection">
    <Schedule>
      <IntervalSchedule INTERVAL = "1" TIME_UNIT = "Hr"/>
    </Schedule>
    <MetricColl NAME="ha_backup"/>
  </CollectionItem>

  <CollectionItem NAME="haconfig3_collection" COLLECT_WHEN_ALTSKIP="TRUE">
    <Schedule>
      <IntervalSchedule INTERVAL = "15" TIME_UNIT = "Min"/>
    </Schedule>
    <MetricColl NAME="ha_flashrecovery"/>
  </CollectionItem>

 <CollectionItem NAME="haconfig4_collection">
   <Schedule>
     <IntervalSchedule INTERVAL = "15" TIME_UNIT = "Min"/>
   </Schedule>
   <MetricColl NAME="ha_recovery">
    <Condition COLUMN_NAME="missing_media_files"
               CRITICAL="0" OPERATOR="GT"
               MESSAGE="Number of missing media files is %value%."
               MESSAGE_NLSID="ha_missing_media_files_alertmessage" />
    <Condition COLUMN_NAME="corrupt_data_blocks"
               CRITICAL="0" OPERATOR="GT"
               MESSAGE="Number of corrupt data blocks is %value%."
               MESSAGE_NLSID="ha_corrupt_data_blocks_alertmessage" />
    <Condition COLUMN_NAME="datafiles_need_recovery"
               CRITICAL="0" OPERATOR="GT"
               MESSAGE="Number of datafiles needing media recovery is %value%."
               MESSAGE_NLSID="ha_datafiles_need_recovery_alertmessage" />
   </MetricColl>
 </CollectionItem>

<!-- ESM database metric -->
  <CollectionItem NAME = "oracle_security" UPLOAD_ON_FETCH = "TRUE" CONFIG = "TRUE">
     <ValidIf>
	<CategoryProp NAME="VersionCategory" CHOICES="8iR2;9i;9iR2;10gR1;10gR2;10gR203;11gR1;11gR2"/>
     </ValidIf>
     <Schedule OFFSET_TYPE="INCREMENTAL">
        <IntervalSchedule INTERVAL = "24" TIME_UNIT = "Hr"/>
     </Schedule>

<!-- ESA 10gR2 collection starts -->
     <MetricColl NAME="privsWithAdminOption" />
     <MetricColl NAME="privsWithGrantOption" />
     <MetricColl NAME="exemptAccessPolicy" />
     <MetricColl NAME="dbaRole" />
     <MetricColl NAME="createPrivileges" />
     <MetricColl NAME="catalogRole" />
     <MetricColl NAME="becomeUserPriv" />
     <MetricColl NAME="auditSystemPriv" />
     <MetricColl NAME="anyDictionaryPriv" />
     <MetricColl NAME="directPrivileges" />
     <MetricColl NAME="sysPublicPackage" />
     <MetricColl NAME="connectRole" />
     <MetricColl NAME="allPrivileges" />
     <MetricColl NAME="anyPrivileges" />
     <MetricColl NAME="powerPrivileges" />
	 <MetricColl NAME="dbaGroupAssign" />
     <MetricColl NAME="tableSpaceOwners" />
     <MetricColl NAME="publicPermissions" />

     <MetricColl NAME="dbLinkUsage" />
     <MetricColl NAME="tableSpaces" />
     <MetricColl NAME="dbPasswordSetting" />
     <MetricColl NAME="dbDataFilesPerm" />
     <MetricColl NAME="dbControlFilesPerm" />
     <MetricColl NAME="tableAccess" />
<!-- ESA 10gR2 collection ends -->

     <MetricColl NAME="unlimitedFailedLoginAttempts" />
     <MetricColl NAME="esm_dirObjUsersWithExeAndOtherPrivs" />
     <MetricColl NAME="esm_publicHavingExePrivOnDirObj" />
     <MetricColl NAME="installAndDemoAcccounts" />
     <MetricColl NAME="defaultAccountPasswords" />
     <MetricColl NAME="systemPrivileges" />
     <MetricColl NAME="executePrivileges" />
     <MetricColl NAME="insertFailure" />
     <MetricColl NAME="privileges" /> 
     <MetricColl NAME="proxyAccount" />
<!--     <MetricColl NAME="testPrivileges" /> -->
  </CollectionItem>
  
  <!-- 
    ======================================================================
    == Category: Storage - Count of segment advisor recommendations
    == Fetchlet: SQL
    ======================================================================
  
    --> 
   <CollectionItem NAME="segment_advisor_count">
     <ValidIf>
        <CategoryProp NAME="VersionCategory" CHOICES="10gR2;10gR203;11gR1;11gR2" /> 
      </ValidIf>
     <Schedule>
        <IntervalSchedule INTERVAL="60" TIME_UNIT="Min" /> 
      </Schedule>
      <MetricColl NAME="segment_advisor_count" /> 
    </CollectionItem>

    

 <!-- ******** START Security Audit Metrics  ******** -->


  <!--
    ====================================================================
    == Metric: Audit Failed Logins (Alert)
    ====================================================================
    -->

  <CollectionItem NAME="audit_failed_logins">
    <Schedule>
      <IntervalSchedule INTERVAL="30" TIME_UNIT="Min"/>
    </Schedule>

    <MetricColl NAME="audit_failed_logins">

      <ItemProperty NAME="currentIntervalMin">30</ItemProperty>

      <Condition COLUMN_NAME="failed_login_count"
                 CRITICAL="300" WARNING="150" OPERATOR="GE"
                 MESSAGE="There have been %value% failed login attempts in the last %failed_login_interval_min% minutes."
                 MESSAGE_NLSID="failed_login_count_alertmessage" 
                 NO_CLEAR_ON_NULL="TRUE" />

    </MetricColl>

  </CollectionItem>


  <!--
    ====================================================================
    == Metric: Audit Failed Logins (Historical)
    ====================================================================
    -->

  <CollectionItem NAME="audit_failed_logins_historical">
    <Schedule>
      <IntervalSchedule INTERVAL="12" TIME_UNIT="Hr"/>
    </Schedule>
    <MetricColl NAME="audit_failed_logins_historical">
      <ItemProperty NAME="updateStateFile">TRUE</ItemProperty>
    </MetricColl>
  </CollectionItem>

  <!-- ******** END Security Audit Metrics ******** -->
  <CollectionItem NAME="textIndexStats">
    <Schedule>
      <IntervalSchedule INTERVAL="8" TIME_UNIT="Min"/>
    </Schedule>
    <MetricColl NAME="textIndexStats">
     <Filter COLUMN_NAME="INDEX_NAME" OPERATOR="NE">dummy</Filter>
    </MetricColl>
  </CollectionItem>


	<!-- STREAMS AND AQ METRICS  BEGIN  -->

    <!-- 
    ======================================================================
    == Category: AQ MONITORING ALERTS
    == Fetchlet: SQL
    ======================================================================
    --> 

    <CollectionItem NAME="aq_monitoring_alerts">
         <Schedule>
          <IntervalSchedule INTERVAL = "30" TIME_UNIT = "Min"/>
         </Schedule>

	 <MetricColl NAME="aq_msgs_per_queue">
	      <Condition COLUMN_NAME="average_msg_age"
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="GE" OCCURRENCES="1"
		MESSAGE="Average age of messages in %schema%.%queue_name% queue is %value% seconds."
		MESSAGE_NLSID="average_msg_age_per_queue" />

	      <Condition COLUMN_NAME="proc_perc"
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="LE" OCCURRENCES="1"
		MESSAGE="Messages processed for queue %schema%.%queue_name% is %value% percent."
		MESSAGE_NLSID="proc_perc_per_queue" />

	      <Condition COLUMN_NAME="totalProcessed_interval"
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="LE" OCCURRENCES="1"
		MESSAGE="Total messages processed per minute in the last interval for queue %schema%.%queue_name% is %value% " 
		MESSAGE_NLSID="totalProcessed_interval_per_queue" />

	      <Condition COLUMN_NAME="totalReceived_interval"
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="LE" OCCURRENCES="1"
		MESSAGE="Total messages received per minute in the last interval for queue %schema%.%queue_name% is %value% " 
		MESSAGE_NLSID="totalReceived_interval_per_queue" />

	      <Condition COLUMN_NAME="proc_perc_interval"
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="LE" OCCURRENCES="1"
		MESSAGE="Messages processed per minute in the last interval for queue %schema%.%queue_name% is %value% "
		MESSAGE_NLSID="proc_perc_interval_per_queue" />

	 </MetricColl>


	 <MetricColl NAME="aq_msgs_per_queue_per_subscriber">
	      <Condition COLUMN_NAME="average_msg_age_subs"
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="GE" OCCURRENCES="1" 
		MESSAGE="Average age of messages for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% seconds."
		MESSAGE_NLSID="average_msg_age_subs" />

	      <Condition COLUMN_NAME="proc_perc"
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="LE" OCCURRENCES="1" 
		MESSAGE="Messages processed for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% percent."
		MESSAGE_NLSID="proc_perc_per_queue_per_subs" />

	      <Condition COLUMN_NAME="totalProcessed_subs_interval"
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="LE" OCCURRENCES="1" 
		MESSAGE="Total messages processed per minute in the last interval for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% " 
		MESSAGE_NLSID="totalProcessed_subs_interval" />

	      <Condition COLUMN_NAME="totalReceived_subs_interval"
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="LE" OCCURRENCES="1" 
		MESSAGE="Total messages received per minute in the last interval for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% " 
		MESSAGE_NLSID="totalReceived_subs_interval" />

	      <Condition COLUMN_NAME="proc_perc_subs_interval"
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="LE" OCCURRENCES="1" 
		MESSAGE="Messages processed per minute in the last interval for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% "
		MESSAGE_NLSID="proc_perc_subs_interval" />

	 </MetricColl>


	 <MetricColl NAME="aq_msgs_persistentqueue">
	      <Condition COLUMN_NAME="first_message_age" 
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="GE" OCCURRENCES="1" 
		MESSAGE="Age of first message in %schema%.%queue_name% queue is %value% seconds."
		MESSAGE_NLSID="first_message_age_per_queue" />
	 </MetricColl>

	 <MetricColl NAME="aq_msgs_persistentq_per_subscriber">
	      <Condition COLUMN_NAME="first_message_age"
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="GE" OCCURRENCES="1" 
		MESSAGE="Age of first message for subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% seconds."
		MESSAGE_NLSID="first_message_age_per_queue_per_subs" />
	 </MetricColl>

	 <MetricColl NAME="aq_msgs_bufferedqueue">
	      <Condition COLUMN_NAME="buffq_first_message_age" 
		CRITICAL="NotDefined" WARNING="NotDefined" 
		OPERATOR="GE" OCCURRENCES="1" 
		MESSAGE="Age of first message in %schema%.%queue_name% buffered queue is %value% seconds."
		MESSAGE_NLSID="buffq_first_message_age_per_queue" />
	 </MetricColl>

    </CollectionItem>

    <!-- 
    ======================================================================
    == Category: Streams Topology - Count of various Streams processes
    == Fetchlet: SQL
    ======================================================================
    --> 

    <CollectionItem NAME="streams_processes_count_item">
         <Schedule>
          <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
         </Schedule>


	 <MetricColl NAME="streams_processes_count"/>

	   <MetricColl NAME="propagation_msgstate_stats">
		<Condition COLUMN_NAME="propagation_msgstate_stats_perc_waiting"
			CRITICAL="90"  WARNING="75" 
			OPERATOR="GT" OCCURRENCES="1"
			MESSAGE="Messages waiting for %PROPAGATION_NAME% queue is %value% percent."
			MESSAGE_NLSID="alert_propagation_msgstate_stats_perc_waiting"  />
	     </MetricColl>
	     <MetricColl NAME="apply_queue_persq">
	     <Condition COLUMN_NAME="apply_persq_perc_waiting"
			CRITICAL="90"  WARNING="75" 
			OPERATOR="GT" OCCURRENCES="1"
			MESSAGE="Messages waiting for Apply Process [%APPLY_NAME%] queue is %value% percent."
			MESSAGE_NLSID="alert_apply_persq_perc_waiting"  />
	     </MetricColl>

    </CollectionItem>

<!--   Collects data for Streams capture, propagation and apply processes     -->
  <CollectionItem NAME="streams_statistics">
     <Schedule>
      <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
     </Schedule>
     <MetricColl NAME="capture_message"/>
     <MetricColl NAME="capture_queue">
	<Condition COLUMN_NAME="capture_queue_perc_spilled_msgs"
		CRITICAL="80"  WARNING="60" 
		OPERATOR="GT" OCCURRENCES="1"
		MESSAGE="Spilled messages for Capture process %CAPTURE_NAME% queue is %value% percent."
		MESSAGE_NLSID="alert_capture_queue_perc_spilled_msgs"  />
     </MetricColl>
     <MetricColl NAME="propagation_sender_stats"/>
     <MetricColl NAME="apply_errors"></MetricColl>
     <MetricColl NAME="apply_queue_buffq">
        <Condition COLUMN_NAME="apply_queue_perc_spilled_msgs"
		CRITICAL="80"  WARNING="60" 
		OPERATOR="GT" OCCURRENCES="1"
		MESSAGE="Spilled messages for Apply process [%APPLY_NAME%] queue is %value% percent."
		MESSAGE_NLSID="alert_apply_queue_perc_spilled_msgs"  />
	</MetricColl>
     <MetricColl NAME="apply_reader">
		<Condition COLUMN_NAME="MESSAGES_SPILL_RATE"
			WARNING="NotDefined" 
			OPERATOR="GT" OCCURRENCES="1"
			MESSAGE="Total number of spilled messages for Apply Process [%APPLY_NAME%] is %value% ."
			MESSAGE_NLSID="alert_apply_reader_total_spilled"  />
     </MetricColl>
     <MetricColl NAME="apply_coord"/>
     <MetricColl NAME="streams_latency_throughput">
         <Condition COLUMN_NAME="streams_latency"
               CRITICAL="900" WARNING="300" OPERATOR="GT"
               MESSAGE="Latency for Streams %streams_process_type% Process %streams_process_name% is %value% seconds."
               MESSAGE_NLSID="streams_latency_alertmessage"
               CLEAR_MESSAGE="CLEARED - Latency for Streams %streams_process_type% Process %streams_process_name% is %value% seconds."
               CLEAR_MESSAGE_NLSID="streams_latency_alertmessage_clear" />
         <Condition COLUMN_NAME="streams_throughput"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               MESSAGE="Throughtput for Streams %streams_process_type% Process %streams_process_name% is %value% messages/sec."
               MESSAGE_NLSID="streams_throughput_alertmessage"
               CLEAR_MESSAGE="CLEARED - Throughtput for Streams %streams_process_type% Process %streams_process_name% is %value% messages/sec."
               CLEAR_MESSAGE_NLSID="streams_throughput_alertmessage_clear" />
     </MetricColl>
     <MetricColl NAME="streams_processes_status">
	<Condition COLUMN_NAME="streams_process_status"
                CRITICAL="ABORTED"  WARNING="DISABLED"
                OPERATOR="EQ" OCCURRENCES="1"
                MESSAGE="Status for Streams process %streams_process_name%  is %streams_process_status%."
                MESSAGE_NLSID="alert_streams_process_status"  />
	<Condition COLUMN_NAME="streams_process_errors"
                WARNING="0" OPERATOR="GT"
                OCCURRENCES="1"
                MESSAGE="Streams component %streams_process_name% has %value% errors."
                MESSAGE_NLSID="alert_streams_process_errors"  />
     </MetricColl>
  </CollectionItem>
 

	<!-- STREAMS AND AQ METRICS  END  -->

  <CollectionItem NAME="DatabaseVaultRealmViolation_collection" UPLOAD="NO" >
    <Schedule>
      <IntervalSchedule INTERVAL="1" TIME_UNIT="Hr"/>
    </Schedule>
    <MetricColl NAME="DatabaseVaultRealmViolation">
    <Condition COLUMN_NAME="ACTION_COMMAND"
               WARNING="NotDefined" CRITICAL="NotDefined" OPERATOR="MATCH"
               MESSAGE="%ACTION_OBJECT_NAME% got violated at %VIOLATIONTIMESTAMP%"
               MESSAGE_NLSID="DatabaseVaultRealmViolation_alertmessage"
               NO_CLEAR_ON_NULL="TRUE" />
    </MetricColl>
  </CollectionItem>

  <CollectionItem NAME="DatabaseVaultCommandRuleViolation_collection" UPLOAD="NO">
    <Schedule>
      <IntervalSchedule INTERVAL="1" TIME_UNIT="Hr"/>
    </Schedule>
    <MetricColl NAME="DatabaseVaultCommandRuleViolation">
    <Condition COLUMN_NAME="ACTION_COMMAND"
               WARNING="NotDefined" CRITICAL="NotDefined" OPERATOR="MATCH"
               MESSAGE="%ACTION_OBJECT_NAME% got violated at %VIOLATIONTIMESTAMP%"
               MESSAGE_NLSID="DatabaseVaultCommandRuleViolation_alertmessage"
               NO_CLEAR_ON_NULL="TRUE" />
    </MetricColl>
  </CollectionItem>

  <CollectionItem NAME="DatabaseVaultRealmConfigurationIssue_collection">
    <Schedule>
      <IntervalSchedule INTERVAL="1" TIME_UNIT="Hr"/>
    </Schedule>
    <MetricColl NAME="DatabaseVaultRealmConfigurationIssue">
      <Condition COLUMN_NAME="ACTION_OBJECT_COUNT"
                 CRITICAL="0" WARNING="NotDefined"  
		 OPERATOR="GT" OCCURRENCES="1" 
                 MESSAGE="%ACTION_OBJECT_NAME% has configuration issues."
                 MESSAGE_NLSID="DatabaseVaultRealmConfigurationIssue_alertmessage" />
    </MetricColl>
  </CollectionItem>

    <CollectionItem NAME="DatabaseVaultCommandRuleConfigurationIssue_collection">
    <Schedule>
      <IntervalSchedule INTERVAL="1" TIME_UNIT="Hr"/>
    </Schedule>
    <MetricColl NAME="DatabaseVaultCommandRuleConfigurationIssue">
      <Condition COLUMN_NAME="ACTION_OBJECT_COUNT"
                 CRITICAL="0" WARNING="NotDefined"  
		 OPERATOR="GT" OCCURRENCES="1" 
                 MESSAGE="%ACTION_OBJECT_NAME% has configuration issues."
                 MESSAGE_NLSID="DatabaseVaultCommandRuleConfigurationIssue_alertmessage" />
    </MetricColl>
  </CollectionItem>

    <CollectionItem NAME="DatabaseVaultPolicyChanges_collection">
    <Schedule>
      <IntervalSchedule INTERVAL="1" TIME_UNIT="Hr"/>
    </Schedule>
    <MetricColl NAME="DatabaseVaultPolicyChanges">
      <Condition COLUMN_NAME="DIFF_IN_POLICY_CHNAGES_COUNT"
                 CRITICAL="0" WARNING="NotDefined"  
		 OPERATOR="GT" OCCURRENCES="1" 
                 MESSAGE="%POLICY_CATEGORY_NAME% has Policy changes."
                 MESSAGE_NLSID="DatabaseVaultPolicyChanges_alertmessage" 
		 NO_CLEAR_ON_NULL="TRUE"/>
    </MetricColl>
  </CollectionItem>


<!--
  ======================================================================
  == Category: Key SQL Profiles - 11g
  == Fetchlet: SQL
  ======================================================================
 -->
  <CollectionItem NAME="key_profiles_collection" UPLOAD_ON_FETCH = "TRUE">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR2"/>
      <CategoryProp NAME="MetricScope" CHOICES="DB"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="60" TIME_UNIT="Min"/>
    </Schedule>
  <MetricColl NAME="key_profiles"/>
  </CollectionItem>

  <!--
  ======================================================================
  == Group: Database Replay
  ======================================================================
  -->
  <CollectionItem NAME="db_replay">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR2"/>
    </ValidIf>

    <!--
    ====================================================================
    == Category: Database Replay Client
    == Fetchlet: SQL
    ====================================================================
    -->
    <MetricColl NAME="wrc_client"/>
  </CollectionItem>
  <!--
  ======================================================================
  == collection cluster_resource_name
  ======================================================================
    -->
  <CollectionItem NAME="cluster_resource_name" UPLOAD_ON_FETCH="TRUE" >

    <Schedule OFFSET_TYPE="INCREMENTAL">
      <IntervalSchedule INTERVAL="6" TIME_UNIT="Hr"/>
    </Schedule>

    <MetricColl NAME="cluster_resource_name"/>

  </CollectionItem>


  <!--
  ======================================================================
  == collection isHasManaged
  ======================================================================
    -->
  <CollectionItem NAME="isHasManaged" UPLOAD_ON_FETCH="TRUE" >

    <Schedule OFFSET_TYPE="INCREMENTAL">
      <IntervalSchedule INTERVAL="24" TIME_UNIT="Hr"/>
    </Schedule>

    <MetricColl NAME="isHasManaged"/>

  </CollectionItem>