<!-- $Header: emdb/sysman/admin/default_collection/instance.xmlp /st_emdbsa_11.2/9 2010/06/21 11:37:30 nachen Exp $
   MODIFIED    (MM/DD/YY)
      nachen    06/16/10 - bug 9728024
      pbhogara  01/30/09 - Configurable property to set database owner group
      yma       08/29/08 - 
      yma       08/20/08 - bug 7141021 
      amahalin  07/28/08 - 
      yma       07/21/08 - bug 6134322 
      sshastry  06/05/08 - Forward merge of streams/aq from 11.1.GC
      yma       05/13/08 - change health check instance down message 
      rsamaved  05/08/08 - add 11gR2 version
      balnaff   05/24/07 - renabling the incident meter
      balnaff   05/10/07 - removing incident meter
      keiwong   04/02/07 - change data failure alert message
      sresrini  03/22/07 - bug 5695985
      yma       03/20/07 - Remove schedule for server generated metrics 
      sudvarma  03/02/07 - to include collection for pwdexpiry metric
      keiwong   02/19/07 - add adrAlertLogDataFailure metric
      balnaff   01/26/07 - adding incident_meter metric
      dsukhwal  01/06/07 - XbranchMerge manosing_ntpol from main
      manosing  11/30/06 - adding 11g nt polcies 
      keiwong   10/31/06 - update adr_alert_roll_up
      jsoule    10/23/06 - add new server-generated alerts
      manosing  10/10/06 - 
      swexler   09/08/06 - modify out-of-band fixitjob
      jsoule    08/31/06 - support 11gR1 version
      swexler   08/03/06 - add oob notification
      keiwong   07/14/06 - Add alertLogIncidentError and 
                           alertLogOperationError 
      yma       03/23/06 - fix bug 5113106 
      jsoule    03/13/06 - start SGA only in 10.2.0.3 and later 
      ysun      09/08/05 - 
      ychan     08/17/05 - Change file interval 
      ysun      08/10/05 - 
      yma       05/19/05 - fix bug 4306961 
      dsukhwal  05/17/05 - move sqlnetParams to listener 
      ysun      05/16/05 - remove 9i activity_pending
      ychan     05/05/05 - Fix bug 4350509 
      zsyed     04/06/05 - Adding check for sgastart collection 
      ysun      03/28/05 - update global cache threshold
      pbantis   03/15/05 - Remove upload param for log_full. 
      sresrini  03/14/05 - fix bug 4210766 
      swexler   03/09/05 - response clear message 
      swexler   02/25/05 - reenable health check 
      rreilly   02/21/05 - remove controlfiles_size 
      ysun      02/16/05 - update after the split
      kdas      01/13/05 - revert ADDM metric 
      yma       01/06/05 - bug 4095025
      rreilly   11/04/04 - bug 3978294 
      jsoule    09/30/04 - add dbtime_ps alert 
      xuliu     09/30/04 - intr metric re-org 
      xuliu     09/28/04 - rac intrconn alert 
      swexler   09/22/04 - health check auto collect 
      xuliu     09/21/04 - rac interconn traffic 
      hxlin     09/13/04 - Combine SQL Resp Time & SQL Resp Time Collect into 
                           one collection item 
      swexler   09/05/04 - Health check
      rreilly   08/24/04 - Collect db_datafiles
      zsyed     08/20/04 - Adding collector startup as default collection 
      rreilly   08/20/04 - bug 3824092 fix collection of oracle_dbconfig for 
                           rac
      hxlin     08/05/04 - Add collect sql response time metric 
      kdas      07/22/04 - define collection for new ADDM metric 
      ychan     07/13/04 - Fix bug 3738242 
      ychan     07/12/04 - Remove 10gBeta 
      xuliu     07/01/04 - rac interconnect 
      ychan     06/29/04 - Fix bug 3434469
      jochen    06/29/04 - Add media failure alert log category 
      blivshit  06/28/04 - stop collecting server generated alert metrics 
      jochen    05/26/04 - Add 10gR2 
      ysun      04/29/04 - ysun_metadata_split
      ysun      04/26/04 - creation
-->


  <!--
  ======================================================================
  == Category: Response
  == Fetchlet: Perl
  == (NB: This category must remain first!)
  ======================================================================
    -->
  <CollectionItem NAME="Response">
    <Schedule>
      <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>

    <!--
    ====================================================================
    == Alert: Status
    ====================================================================
      -->
    <Condition COLUMN_NAME="Status"
               CRITICAL="0" OPERATOR="EQ"
               CLEAR_MESSAGE="The database is UP."
               CLEAR_MESSAGE_NLSID="Response_Status_clearalertmessage"
               MESSAGE="Failed to connect to database instance: %oraerr%."
               MESSAGE_NLSID="Response_Status_alertmessage" />

    <!--
    ====================================================================
    == Alert: User Logon Time (msec)
    ====================================================================
      -->
    <Condition COLUMN_NAME="userLogon"
               WARNING="1000" OPERATOR="GT"
               OCCURRENCES="6"
               MESSAGE="User logon time is %value% msecs."
               MESSAGE_NLSID="Response_userLogon_alertmessage"  />

    <!--
    ====================================================================
    == Alert: State
    ====================================================================
      -->
    <Condition COLUMN_NAME="State"
               WARNING="MOUNTED" OPERATOR="CONTAINS"
               MESSAGE="The database status is %value%."
               MESSAGE_NLSID="Response_state_alertmessage"  />
  </CollectionItem>


  <CollectionItem NAME="health_check" UPLOAD="NO" COLLECT_WHEN_DOWN="TRUE">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="15" TIME_UNIT="Sec"/>
    </Schedule> 
      <Condition COLUMN_NAME="Status"
                 CRITICAL="0" OPERATOR="EQ"
                 MESSAGE="The instance is down, and health check reported: %text%."
                 MESSAGE_NLSID="health_check_Status_alertmessage"
                  >
        <FixitJob TYPE="OSCommand">
          <Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
          <Property NAME="emd_email_address" SCOPE="SYSTEMGLOBAL">emd_email_address</Property>
          <Property NAME="emd_from_email_address" SCOPE="SYSTEMGLOBAL">emd_from_email_address</Property>
          <Property NAME="emd_email_gateway" SCOPE="SYSTEMGLOBAL">emd_email_gateway</Property>
          <Property NAME="REPOSITORY_URL" SCOPE="SYSTEMGLOBAL">REPOSITORY_URL</Property>
          <Property NAME="agentVersion" SCOPE="SYSTEMGLOBAL">agentVersion</Property>
          <Property NAME="COMMAND" SCOPE="GLOBAL">%perlBin%/perl %scriptsDir%/dbdown.pl</Property>
        </FixitJob>
      </Condition>

      <Condition COLUMN_NAME="Unmounted"
                 WARNING="0" OPERATOR="EQ"
                 MESSAGE="The instance has been started in no-mount state."
                 MESSAGE_NLSID="health_check_Unmounted_alertmessage"
                  />
      <Condition COLUMN_NAME="Mounted"
                 WARNING="0" OPERATOR="EQ"
                 MESSAGE="The database has been started and is in mounted state."
                 MESSAGE_NLSID="health_check_Mounted_alertmessage"
                  />
      <Condition COLUMN_NAME="Unavailable"
                 WARNING="0" OPERATOR="EQ"
                 MESSAGE="The database is not available due to the following conditions: %text%."
                 MESSAGE_NLSID="health_check_Unavailable_alertmessage"
                  />
      <Condition COLUMN_NAME="Maintenance"
                 WARNING="0" OPERATOR="EQ"
                 MESSAGE="The database is in the following maintenance states: %text%."
                 MESSAGE_NLSID="health_check_Maintenance_alertmessage"
                  />
  </CollectionItem>

 
  <!--
  ======================================================================
  == Group: SQL Response Time 
  ======================================================================
  -->
  <CollectionItem NAME="sql_response">
    <Schedule>
      <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>

    <!--
    ======================================================================
    == Category: Collect SQL Response Time
    == Fetchlet: SQL
    ======================================================================
    -->
    <MetricColl NAME="sql_response_collect"/>

    <!--
    ======================================================================
    == Category: SQL Response Time
    == Fetchlet: SQL
    ======================================================================
    -->
    <MetricColl NAME="sql_response">
      <!--
      ====================================================================
      == Alert: SQL Response Time
      ====================================================================
      -->
      <Condition COLUMN_NAME="time"
               WARNING="500" OPERATOR="GT"
               OCCURRENCES="4"
               MESSAGE="SQL response time is %value%%% of baseline."
               MESSAGE_NLSID="sql_response_time_alertmessage"  />
    </MetricColl>
  </CollectionItem>

    <!--
    ====================================================================
    == Category: Throughput - 9i
    == Fetchlet: SQL
    ====================================================================
      -->
  <CollectionItem NAME="instance_throughput_9i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
    </ValidIf>
    <Schedule>
        <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>
    <MetricColl NAME="instance_throughput">

      <!--
      ==================================================================
      == Alert: Number of Transactions (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="transactions_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Transaction rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_transactions_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Physical Reads (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="physreads_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Physical reads are %value%/sec."
                 MESSAGE_NLSID="inst_thruput_physreads_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Physical Reads (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="physreads_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Physical reads are %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_physreads_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: Physical Writes (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="physwrites_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Physical writes are %value%/sec."
                 MESSAGE_NLSID="inst_thruput_physwrites_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Physical Writes (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="physwrites_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Physical writes are %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_physwrites_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: Redo Generated (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="redosize_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Redo generated is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_redosize_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Redo Generated (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="redosize_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Redo generated is %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_redosize_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: Cumulative Logons (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="logons_ps"
                 WARNING="100" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Cumulative logon rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_logons_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Cumulative Logons (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="logons_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Cumulative logon rate is %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_logons_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: User Commits (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="commits_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="User commit rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_commits_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: User Commits (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="commits_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="User commit rate is %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_commits_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: User Rollbacks (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="rollbacks_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="User rollback rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_rollbacks_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: User Rollbacks (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="rollbacks_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="User rollback rate is %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_rollbacks_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: User Calls (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="usercalls_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="User call rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_usercalls_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: User Calls (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="usercalls_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="User call rate is %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_usercalls_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: Recursive Calls (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="recurscalls_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Recursive call rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_recurscalls_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Recursive Calls (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="recurscalls_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Recursive call rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_recurscalls_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: Session Logical Reads (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="logreads_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Session logical reads are %value%/sec."
                 MESSAGE_NLSID="inst_thruput_logreads_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Session Logical Reads (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="logreads_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Session logical reads are %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_logreads_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: DBWR Checkpoints (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="dbwrcheckpoints_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="DBWR checkpoint rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_dbwrcheckpoints_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Redo Writes (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="redowrites_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Redo write rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_redowrites_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Redo Writes (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="redowrites_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Redo write rate is %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_redowrites_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: Scans on Long Tables (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="tabscanslong_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Rate of scans on long tables is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_tabscanslong_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Scans on Long Tables (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="tabscanslong_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Rate of scans on long tables is %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_tabscanslong_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: Total Parses (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="parses_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Total parse rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_parses_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Total Parses (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="parses_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Total parse rate is %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_parses_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: Hard Parses (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="hardparses_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Hard parse rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_hardparses_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Hard Parses (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="hardparses_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Hard parse rate is %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_hardparses_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: Sorts to Disk (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="sortsdisk_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="The rate of sorts to disk is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_sortsdisk_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Sorts to Disk (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="sortsdisk_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="The rate of sorts to disk is %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_sortsdisk_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: Rows Processed (per sort)
      ==================================================================
        -->
      <Condition COLUMN_NAME="rows_psort"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Average sort size is %value% rows."
                 MESSAGE_NLSID="inst_thruput_rows_psort_alertmessage" />

      <!--
      ==================================================================
      == Alert: Executes Performed without Parses (%)
      ==================================================================
        -->
      <Condition COLUMN_NAME="executeswoparse_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="Only %value%%% of executes are performed without parses."
                 MESSAGE_NLSID="inst_thruput_executeswoparse_pct_alertmessage" />

      <!--
      ==================================================================
      == Alert: Soft Parse (%)
      ==================================================================
        -->
      <Condition COLUMN_NAME="softparse_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="Only %value%%% of parses are soft parses."
                 MESSAGE_NLSID="inst_thruput_softparse_pct_alertmessage" />

      <!--
      ==================================================================
      == Alert: User Calls (%)
      ==================================================================
        -->
      <Condition COLUMN_NAME="usercall_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="%value%%% of calls are user calls."
                 MESSAGE_NLSID="inst_thruput_usercall_pct_alertmessage" />


      <!--
      ==================================================================
      == Alert: Total Table Scans (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="tabscanstotal_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Total table scan rate is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_tabscanall_ps_alertmessage" />

      <!--
      ==================================================================
      == Alert: Total Table Scans (per transaction)
      ==================================================================
        -->
      <Condition COLUMN_NAME="tabscanstotal_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Total table scan rate is %value%/transaction."
                 MESSAGE_NLSID="inst_thruput_tabscanall_pt_alertmessage" />

      <!--
      ==================================================================
      == Alert: Network Bytes (per second)
      ==================================================================
        -->
      <Condition COLUMN_NAME="networkbytes_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"
                 MESSAGE="Bytes transmitted via SQL*Net is %value%/sec."
                 MESSAGE_NLSID="inst_thruput_networkbytes_ps_alertmessage" />
    </MetricColl>
</CollectionItem>

    <!--
    ====================================================================
    == Category: Throughput - 10g
    == Fetchlet: SQL
    ====================================================================
      -->
  <CollectionItem NAME="instance_throughput_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="instance_throughput">

      <!--
      ==================================================================
      == Alert: Number of Transactions (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="transactions_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GE"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: Physical Reads (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physreads_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Physical Reads (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physreads_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Physical Writes (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physwrites_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Physical Writes (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physwrites_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!-- NEW
      ==================================================================
      == Alert: Physical Reads Direct (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physreadsdir_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Physical Reads Direct (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physreadsdir_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Physical Writes Direct (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physwritesdir_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Physical Writes Direct (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physwritesdir_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Physical Reads Direct Lob (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physreadslob_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!-- NEW
      ==================================================================
      == Alert: Physical Reads Direct Lob (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physreadslob_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Physical Writes Direct Lob (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physwriteslob_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Physical Writes Direct Lob (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="physwriteslob_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!--
      ==================================================================
      == Alert: Redo Generated (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="redosize_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: Redo Generated (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="redosize_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: Cumulative Logons (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="logons_ps"
                 WARNING="100" OPERATOR="GE"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Cumulative Logons (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="logons_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!-- MEW
      ==================================================================
      == Alert: Open Cursors (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE"  COLUMN_NAME="opncurs_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- MEW
      ==================================================================
      == Alert: Open Cursors (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE"  COLUMN_NAME="opncurs_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!--
      ==================================================================
      == Alert: User Commits (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="commits_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: User Commits (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="commits_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: User Rollbacks (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="rollbacks_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: User Rollbacks (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="rollbacks_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: User Calls (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="usercalls_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: User Calls (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="usercalls_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Recursive Calls (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="recurscalls_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Recursive Calls (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="recurscalls_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: Session Logical Reads (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="logreads_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Session Logical Reads (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="logreads_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: DBWR Checkpoints (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="dbwrcheckpoints_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!-- NEW
      ==================================================================
      == Alert: BG Checkpoints (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="bgcheckpoints_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
   <!--
      ==================================================================
      == Alert: Redo Writes (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="redowrites_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: Redo Writes (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="redowrites_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Scans on Long Tables (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="tabscanslong_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Scans on Long Tables (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="tabscanslong_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!-- NEW
      ==================================================================
      == Alert: Total Table Scans  (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="tabscanstotal_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Total Table Scans  (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="tabscanstotal_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Full Index Scans (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="indxscansfull_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Full Index Scans (per transaction)
      ==================================================================
      -->
      <Condition PUSH="TRUE" COLUMN_NAME="indxscansfull_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Total Index Scans (per second)
      ==================================================================
      -->
      <Condition PUSH="TRUE" COLUMN_NAME="indxscanstotal_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Full Index Scans (per transaction)
      ==================================================================
      -->
      <Condition PUSH="TRUE" COLUMN_NAME="indxscanstotal_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
     <!--
      ==================================================================
      == Alert: Total Parses (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="parses_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Total Parses (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="parses_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Hard Parses (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="hardparses_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Hard Parses (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="hardparses_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Parse Failure Count (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="failedparses_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Parse Failure Count (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="failedparses_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Executes (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="executions_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!-- NEW
      ==================================================================
      == Alert: Sorts to Disk (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="sortsdisk_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: Sorts to Disk (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="sortsdisk_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: Rows Processed (per sort)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="rows_psort"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: Executes Performed without Parses (%)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="executeswoparse_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: Soft Parse (%)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="softparse_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"/>

      <!--
      ==================================================================
      == Alert: User Calls (%)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="usercall_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2" />
                 
      <!--
      ==================================================================
      == Alert: Network Bytes (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="networkbytes_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!--  NEW
      ==================================================================
      == Alert: Enqueue Timeout (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="enqtimeouts_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Enqueue Timeout (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="enqtimeouts_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!--  NEW
      ==================================================================
      == Alert: Enqueue Waits (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="enqwaits_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Enqueue Waits (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="enqwaits_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Enqueue Deadlocks (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="enqdeadlocks_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Enqueue Deadlocks (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="enqdeadlocks_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Enqueue Requests  (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="enqreqs_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Enqueue Requests  (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="enqreqs_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Database Block Gets (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="dbblkgets_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Database Block Gets (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="dbblkgets_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Consistent Read Gets (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="consistentreadgets_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Consistent Read Gets (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="consistentreadgets_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Database Block Changes (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="dbblkchanges_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
     <!-- NEW
      ==================================================================
      == Alert: Database Block Changes (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="dbblkchanges_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Consistent Read Changes (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="consistentreadchanges_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Consistent Read Changes (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="consistentreadchanges_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Cursor Blocks Created  (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="crblks_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Cursor Blocks Created  (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="crblks_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Cursor Undo Records Applied (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="crundorecs_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: Cursor Undo Records Applied (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="crundorecs_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: User Rollback Undo Records Applied (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="userrollbackundorec_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      <!-- NEW
      ==================================================================
      == Alert: User Rollback Undo Records Applied (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="userrollbackundorec_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      <!-- NEW
      ==================================================================
      == Alert: Leaf Node Splits (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="leafnodesplits_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
        <!-- NEW
      ==================================================================
      == Alert: Leaf Node Splits (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="leafnodesplits_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
        <!-- NEW
      ==================================================================
      == Alert: Branch Node Splits (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="branchnodesplits_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
        <!-- NEW
      ==================================================================
      == Alert: Branch Node Splits (per transaction)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="branchnodesplits_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: Database Time (centiseconds per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: Average Active Sessions
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="avg_active_sessions"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: Average Synchronous Single-Block Read Latency (ms)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="avg_sync_singleblk_read_latency"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: I/O Megabytes (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="iombs_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

      <!--
      ==================================================================
      == Alert: I/O Requests (per second)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="iorequests_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Category: Efficiency - 9i
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="instance_efficiency_9i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
    </ValidIf>
    <Schedule>
        <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>

    <MetricColl NAME="instance_efficiency">
      <!--
      ====================================================================
      == Alert: Buffer Cache Hit (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="bufcachehit_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="Buffer cache hit ratio is %value%%%."
                 MESSAGE_NLSID="instance_efficiency_bufcachehit_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: Library Cache Hit (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="libcache_hit_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="Library cache hit ratio is %value%%%."
                 MESSAGE_NLSID="instance_efficiency_libcache_hit_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: Data Dictionary Hit (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="dictionaryhit_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="Data dictionary hit ratio is %value%%%."
                 MESSAGE_NLSID="instance_efficiency_dictionaryhit_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: Sorts in Memory (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="inmem_sort_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="%value%%% of sorts are performed in memory."
                 MESSAGE_NLSID="instance_efficiency_inmem_sort_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: Redo Log Allocation Hit (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="redologalloc_hit_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="Redo log allocation hit ratio is %value%%%."
                 MESSAGE_NLSID="instance_eff_redologalloc_hit_pct_alertmessage" />
    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Category: Efficiency - 10i
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="instance_efficiency_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="instance_efficiency">

    <!--
    ====================================================================
    == Alert: Buffer Cache Hit (%)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="bufcachehit_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2"/>

    <!--
    ====================================================================
    == Alert: Library Cache Hit (%)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="libcache_hit_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2"/>

    <!--
    ====================================================================
    == Alert: Data Dictionary Hit (%)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="dictionaryhit_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2" />

    <!--
    ====================================================================
    == Alert: Data Dictionary Miss (%)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="dictionarymiss_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2"/>
    <!--
    ====================================================================
    == Alert: Sorts in Memory (%)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="inmem_sort_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2" />

    <!--
    ====================================================================
    == Alert: Redo Log Allocation Hit (%)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="redologalloc_hit_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2" />

    <!-- NEW
    ====================================================================
    == Alert: Cursor Cache Hit (%) (%)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="cursorcachehit_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2" />

    <!-- NEW
    ====================================================================
    == Alert: CPU Usage (per second)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="cpuusage_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
    <!-- NEW
    ====================================================================
    == Alert: CPU Usage (per transaction)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="cpuusage_pt"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
    <!-- NEW
    ====================================================================
    == Alert: Parallel Execution Downgraded 25% or more (per second)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrd25_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2"/>
    <!-- NEW
    ====================================================================
    == Alert: Parallel Execution Downgraded 50% or more (per second)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrd50_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
   <!-- NEW
    ====================================================================
    == Alert: Parallel Execution Downgraded 75% or more (per second)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrd75_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2"/>
   <!-- NEW
    ====================================================================
    == Alert: Parallel Execution Downgraded (per second)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrd_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
   <!-- NEW
    ====================================================================
    == Alert: Parallel Execution Downgraded to Serial (per second)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrdserial_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
   <!-- NEW
    ====================================================================
    == Alert: Parallel Execution Downgraded to Serial (per transaction)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrdserial_pt"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2"/>

   <!-- NEW
    ====================================================================
    == Alert: Database CPU Time (%)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="cpu_time_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2" />
   <!-- NEW
    ====================================================================
    == Alert: Database CPU Time (%)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="response_time_pt"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
   <!-- NEW
    ====================================================================
    == Alert: PGA Cache Hit (%)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="pgacachehit_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2" />
    <!--
    ====================================================================
    == Alert: Library Cache Miss (%)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="libcache_miss_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Category: Wait Bottlenecks - 9i
  == Fetchlet: SQL
  ======================================================================
      -->
  <CollectionItem NAME="wait_bottlenecks_9i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="1" TIME_UNIT="Min"/>
    </Schedule>
    <MetricColl NAME="wait_bottlenecks">

      <!--
      ====================================================================
      == Alert: local write wait (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="local_write_wait_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'local write wait' event."
                 MESSAGE_NLSID="wait_pcts_local_write_wait_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: SQL*Net break/reset to client (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="net_reset_to_client_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'SQL*Net break/reset to client' event."
                 MESSAGE_NLSID="wait_pcts_net_reset_to_client_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: SQL*Net break/reset to dblink (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="net_reset_to_dblink_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'SQL*Net break/reset to dblink' event."
                 MESSAGE_NLSID="wait_pcts_net_reset_to_dblink_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: enqueue: DML - contention (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="enqueue_dml_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'enqueue: DML - contention' event."
                 MESSAGE_NLSID="wait_pcts_enqueue_dml_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: enqueue: TM, TX, Transaction - row lock contention (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="enqueue_row_lock_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'enqueue: TM,TX, Transaction - row lock contention' event."
                 MESSAGE_NLSID="wait_pcts_enqueue_row_lock_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: enqueue: UL: User-defined - contention (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="enqueue_userdef_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'enqueue: UL: User-defined - contention' event."
                 MESSAGE_NLSID="wait_pcts_enqueue_userdef_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: log file sync (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="log_file_sync_pct"
                 WARNING="30" OPERATOR="GT"
                 OCCURRENCES="5"
                 MESSAGE="%value%%% of service time is spent waiting on the 'log file sync' event."
                 MESSAGE_NLSID="wait_pcts_log_file_sync_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: buffer busy waits (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="buffer_busy_waits_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'buffer busy waits' event."
                 MESSAGE_NLSID="wait_pcts_buffer_busy_waits_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: latch: cache buffer chains (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="latch_cache_buffer_chains_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'latch: cache buffer chains' event."
                 MESSAGE_NLSID="wait_pcts_latch_cache_buffer_chains_pct_alertmsg" />

      <!--
      ====================================================================
      == Alert: latch: library cache (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="latch_library_cache_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'latch: library cache' event."
                 MESSAGE_NLSID="wait_pcts_latch_library_cache_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: library cache load lock (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="library_cache_load_lock_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'library cache load lock' event."
                 MESSAGE_NLSID="wait_pcts_library_cache_load_lock_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: library cache lock (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="library_cache_lock_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'library cache lock' event."
                 MESSAGE_NLSID="wait_pcts_library_cache_lock_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: library cache pin (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="library_cache_pin_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'library cache pin' event."
                 MESSAGE_NLSID="wait_pcts_library_cache_pin_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: pipe put (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="pipe_put_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'pipe put' event."
                 MESSAGE_NLSID="wait_pcts_pipe_put_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: row cache lock (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="row_cache_lock_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'row cache lock' event."
                 MESSAGE_NLSID="wait_pcts_row_cache_lock_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: enqueue: HW, Segment High Water Mark - contention (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="enqueue_hw_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'enqueue: HW, Segment High Water Mark - contention' event."
                 MESSAGE_NLSID="wait_pcts_enqueue_hw_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: enqueue: ST, Space Transaction - contention (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="enqueue_st_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'enqueue: ST, Space Transaction - contention' event."
                 MESSAGE_NLSID="wait_pcts_enqueue_st_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: enqueue: TX mode 4, Transaction - allocate ITL entry (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="enqueue_alloc_itl_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'enqueue: TX mode 4, Transaction - allocate ITL entry' event."
                 MESSAGE_NLSID="wait_pcts_enqueue_alloc_itl_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: free buffer waits (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="free_buffer_waits_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'free buffer waits' event."
                 MESSAGE_NLSID="wait_pcts_free_buffer_waits_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: latch: redo copy (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="latch_redo_copy_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'latch: redo copy' event."
                 MESSAGE_NLSID="wait_pcts_latch_redo_copy_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: latch: shared pool (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="latch_shared_pool_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'latch: shared pool' event."
                 MESSAGE_NLSID="wait_pcts_latch_shared_pool_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: log buffer space (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="log_buffer_space_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'log buffer space' event."
                 MESSAGE_NLSID="wait_pcts_log_buffer_space_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: log file switch (archiving needed) (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="log_file_switch_arch_pct"
                 CRITICAL="5" WARNING="1" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'log file switch (archiving needed)' event."
                 MESSAGE_NLSID="wait_pcts_log_file_switch_arch_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: log file switch (checkpoint complete) (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="log_file_switch_ckpt_pct"
                 CRITICAL="50" WARNING="5" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'log file switch (checkpoint complete) event."
                 MESSAGE_NLSID="wait_pcts_log_file_switch_ckpt_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: log file switch completion (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="log_file_switch_complete_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'log file switch completion' event."
                 MESSAGE_NLSID="wait_pcts_log_file_switch_complete_pct_alertmsg" />

      <!--
      ====================================================================
      == Alert: log switch/archive (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="log_switch_arch_pct"
                 WARNING="5" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'log switch/archive' event."
                 MESSAGE_NLSID="wait_pcts_log_switch_arch_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: write complete waits (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="write_complete_waits_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'write complete waits' event."
                 MESSAGE_NLSID="wait_pcts_write_complete_waits_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: SQL*Net message to client (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="net_msg_to_client_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'SQL*Net message to client' event."
                 MESSAGE_NLSID="wait_pcts_net_msg_to_client_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: SQL*Net message to dblink (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="net_msg_to_dblink_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'SQL*Net message to dblink' event."
                 MESSAGE_NLSID="wait_pcts_net_msg_to_dblink_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: SQL*Net more data from client (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="net_more_from_client_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'SQL*Net more data from client' event."
                 MESSAGE_NLSID="wait_pcts_net_more_from_client_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: SQL*Net more data from dblink (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="net_more_from_dblink_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'SQL*Net more data from dblink' event."
                 MESSAGE_NLSID="wait_pcts_net_more_from_dblink_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: SQL*Net more data to client (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="net_more_to_client_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'SQL*Net more data to client' event."
                 MESSAGE_NLSID="wait_pcts_net_more_to_client_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: SQL*Net more data to dblink (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="net_more_to_dblink_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'SQL*Net more data to dblink' event."
                 MESSAGE_NLSID="wait_pcts_net_more_to_dblink_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: db file scattered read (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="db_file_scattered_read_pct"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'db file scattered read' event."
                 MESSAGE_NLSID="wait_pcts_db_file_scattered_read_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: db file sequential read (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="db_file_sequential_read_pct"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'db file sequential read' event."
                 MESSAGE_NLSID="wait_pcts_db_file_sequential_read_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: db file single write (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="db_file_single_write_pct"
                 WARNING="50" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'db file single write' event."
                 MESSAGE_NLSID="wait_pcts_db_file_single_write_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: direct path read (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="direct_path_read_pct"
                 WARNING="50" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'direct path read' event."
                 MESSAGE_NLSID="wait_pcts_direct_path_read_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: direct path read (lob) (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="direct_path_read_lob_pct"
                 WARNING="50" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'direct path read (lob)' event."
                 MESSAGE_NLSID="wait_pcts_direct_path_read_lob_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: direct path write (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="direct_path_write_pct"
                 WARNING="50" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'direct path write' event."
                 MESSAGE_NLSID="wait_pcts_direct_path_write_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: direct path write (lob) (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="direct_path_write_lob_pct"
                 WARNING="50" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'direct path write (lob)' event."
                 MESSAGE_NLSID="wait_pcts_direct_path_write_lob_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: latch free - other (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="latch_free_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'latch free' event."
                 MESSAGE_NLSID="wait_pcts_latch_free_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: enqueue - other (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="enqueue_pct"
                 WARNING="20" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of service time is spent waiting on the 'enqueue' event."
                 MESSAGE_NLSID="wait_pcts_enqueue_pct_alertmessage" />

      <!--
      ==================================================================
      == Alert: Wait Time (%)
      ==================================================================
        -->
      <Condition COLUMN_NAME="user_wait_time_pct"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value%%% of database service time is spent waiting."
                 MESSAGE_NLSID="wait_pcts_user_wait_time_pct_alertmessage" />

    </MetricColl>

  </CollectionItem>

  <!--
  ======================================================================
  == Category: Wait Bottlenecks - 10i
  == Fetchlet: SQL
  ======================================================================
      -->
  <CollectionItem NAME="wait_bottlenecks_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>

    <MetricColl NAME="wait_bottlenecks">

      <!--
      ==================================================================
      == Alert: Wait Time (%)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="user_wait_time_pct"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3" />
      <!--
      ==================================================================
      == Alert: Active Sessions Waiting: I/O
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="userio_wait_cnt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3" />
      <!--
      ==================================================================
      == Alert: Active Sessions Waiting: Other
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="other_wait_cnt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3" />
    </MetricColl>
  </CollectionItem>

    <!--
    ====================================================================
    == Category: SGA Pool Wastage - 9i
    == Fetchlet: SQL
    ====================================================================
      -->
  <CollectionItem NAME="sga_pool_wastage_9i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="15" TIME_UNIT="Min"/>
    </Schedule>

    <MetricColl NAME="sga_pool_wastage">

      <!--
      ====================================================================
      == Alert: Shared Pool Free (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="shared_free_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="%value%%% of the shared pool is free."
                 MESSAGE_NLSID="sga_pool_wastage_shared_free_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: Large Pool Free (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="large_free_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="%value%%% of the large pool is free."
                 MESSAGE_NLSID="sga_pool_wastage_large_free_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: Java Pool Free (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="java_free_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="%value%%% of the Java pool is free."
                 MESSAGE_NLSID="sga_pool_wastage_java_free_pct_alertmessage" />

    </MetricColl>

  </CollectionItem>

    <!--
    ====================================================================
    == Category: SGA Pool Wastage - 10i
    == Fetchlet: SQL
    ====================================================================
      -->
  <CollectionItem NAME="sga_pool_wastage_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>

    <MetricColl NAME="sga_pool_wastage">

      <!--
      ====================================================================
      == Alert: Shared Pool Free (%)
      ====================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="shared_free_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2" />

      <!--
      ====================================================================
      == Alert: Large Pool Free (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="large_free_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="%value%%% of the large pool is free."
                 MESSAGE_NLSID="sga_pool_wastage_large_free_pct_alertmessage" />

      <!--
      ====================================================================
      == Alert: Java Pool Free (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="java_free_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"
                 MESSAGE="%value%%% of the Java pool is free."
                 MESSAGE_NLSID="sga_pool_wastage_java_free_pct_alertmessage" />

    </MetricColl>

  </CollectionItem>

    <!--
    ====================================================================
    == Category: Database Limits - 9i
    == Fetchlet: SQL
    ====================================================================
      -->

    <CollectionItem NAME="Database_Resource_Usage_9i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="15" TIME_UNIT="Min"/>
    </Schedule>

    <MetricColl NAME="Database_Resource_Usage">

      <!--
      ====================================================================
      == Alert: Lock Limit Usage (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="lock_usage"
                 WARNING="80" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%target% has reached %value%%% of the lock limit."
                 MESSAGE_NLSID="Database_Resource_Usage_lock_usage_alertmessage"/>

      <!--
      ====================================================================
      == Alert: Process Limit Usage (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="process_usage"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%target% has reached %value%%% of the process limit."
                 MESSAGE_NLSID="Database_Resource_Usage_process_usage_alertmessage"/>

      <!--
      ====================================================================
      == Alert: Session Limit Usage (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="session_usage"
                 WARNING="90" CRITICAL="97" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%target% has reached %value%%% of the session limit."
                 MESSAGE_NLSID="Database_Resource_Usage_session_usage_alertmessage"/>

      <!--
      ====================================================================
      == Alert: User Limit Usage (%)
      ====================================================================
        -->
      <Condition COLUMN_NAME="user_limit"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%target% has reached %value%%% of the user limit."
                 MESSAGE_NLSID="Database_Resource_Usage_user_limit_alertmessage"/>

    </MetricColl>
  </CollectionItem>

    <!--
    ====================================================================
    == Category: Database Limits - 10i
    == Fetchlet: SQL
    ====================================================================
      -->
    <CollectionItem NAME="Database_Resource_Usage_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>


    <MetricColl NAME="Database_Resource_Usage">

      <!--
      ====================================================================
      == Alert: Logons
      ====================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="logons"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"/>

      <!--
      ====================================================================
      == Alert: Process Limit Usage (%)
      ====================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="process_usage"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"/>

      <!--
      ====================================================================
      == Alert: Session Limit Usage (%)
      ====================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="session_usage"
                 WARNING="90" CRITICAL="97" OPERATOR="GT"
                 OCCURRENCES="3"/>

      <!--
      ====================================================================
      == Alert: User Limit Usage (%)
      ====================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="user_limit"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"/>

      <!--
      ====================================================================
      == Alert: Current Open Cursors Count
      ====================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="opencursors"
                 WARNING="1200" OPERATOR="GT"
                 OCCURRENCES="3"/>
    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Group: alert_log_rollup
  ======================================================================
    -->
  <CollectionItem NAME="alert_log_rollup" COLLECT_WHEN_ALTSKIP="TRUE">
		<ValidIf>
			<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2;10gR1;10gR2;10gR203"/>
		</ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="15" TIME_UNIT="Min"/>
    </Schedule>

    <!--
    ====================================================================
    == Category: Alert Log
    == Fetchlet: Perl
    == (NB: An alert log error stack never contributes to more than one
    ==      event.)
    == User Properties: ignorePattern - Perl regular expression used to
    ==                                  suppress specific ORA-errors
    ====================================================================
      -->
    <MetricColl NAME="alertLog">

      <!--
      ==================================================================
      == User Property: switch imposing scanning limit
      == Supported Values:
      ==  <positive integer>: time limit, in seconds
      ==  EOF:                scan entire log, discard all entries
      ==  tail:               process the entire tail/no time limit
      ==================================================================
        -->
      <ItemProperty NAME="limitSwitch">870</ItemProperty>

      <!--
      ==================================================================
      == User Property: pattern to ignore
      ==================================================================
        -->
      <ItemProperty NAME="ignorePattern">.*ORA-0*(54|1142|1146)\D.*</ItemProperty>

      <!--
      ==================================================================
      == Alert: Alert Log Error Stack
      ==================================================================
        -->
      <Condition COLUMN_NAME="genericErrStack"
                 WARNING="ORA-0*(600?|7445|4[0-9][0-9][0-9])[^0-9]" OPERATOR="MATCH"
                 MESSAGE="ORA-error stack (%errCodes%) logged in %alertLogName%."
                 MESSAGE_NLSID="alertLog_genericErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE" />

      <!--
      ==================================================================
      == Alert: Archiver Hung Error Stack
      ==================================================================
        -->
      <Condition COLUMN_NAME="archiveHungErrStack"
                 CRITICAL="ORA-" OPERATOR="CONTAINS"
                 MESSAGE="The archiver hung at time/line number: %timeLine%."
                 MESSAGE_NLSID="alertLog_archiveHungErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE" />

      <!--
      ==================================================================
      == Alert: Data Block Corruption Error Stack
      ==================================================================
        -->
      <Condition COLUMN_NAME="blockCorruptErrStack"
                 CRITICAL="ORA-" OPERATOR="CONTAINS"
                 MESSAGE="A data block was corrupted at time/line number: %timeLine%."
                 MESSAGE_NLSID="alertLog_blockCorruptErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE" />

      <!--
      ==================================================================
      == Alert: Session Terminated Error Stack
      ==================================================================
        -->
      <Condition COLUMN_NAME="sessTerminateErrStack"
                 WARNING="ORA-" OPERATOR="CONTAINS"
                 MESSAGE="A session was terminated at time/line number: %timeLine%."
                 MESSAGE_NLSID="alertLog_sessTerminateErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE" />
                 
      <!--
      ==================================================================
      == Alert: Media Failure Error Stack
      ==================================================================
        -->
      <Condition COLUMN_NAME="mediaFailureErrStack"
                 CRITICAL="ORA-" OPERATOR="CONTAINS"
                 MESSAGE="Media failure was detected at time/line number: %timeLine%."
                 MESSAGE_NLSID="alertLog_mediaFailureErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE" />
                 
    </MetricColl>

    <!--
    ====================================================================
    == Category: Alert Log Error Status
    == Fetchlet: Aggregation
    ====================================================================
      -->
    <MetricColl NAME="alertLogStatus">

      <!--
      ==================================================================
      == User Property: switch imposing scanning limit
      == Supported Values:
      ==  <positive integer>: time limit, in seconds
      ==  EOF:                scan entire log, discard all entries
      ==  tail:               process the entire tail/no time limit
      ==================================================================
        -->
      <ItemProperty NAME="limitSwitch">870</ItemProperty>

      <!--
      ==================================================================
      == User Property: pattern to ignore
      ==================================================================
        -->
      <ItemProperty NAME="ignorePattern">.*ORA-0*(54|1142|1146)\D.*</ItemProperty>

      <!--
      ==================================================================
      == Alert: Generic Alert Log Errors
      ==================================================================
        -->
      <Condition COLUMN_NAME="genericErrors"
                 WARNING="0" OPERATOR="GT"
                 MESSAGE="%value% distinct types of ORA- errors have been found in the alert log."
                 MESSAGE_NLSID="alertLogStatus_genericErrors_alertmessage" />

      <!--
      ==================================================================
      == Alert: Archiver Hung Errors
      ==================================================================
        -->
      <Condition COLUMN_NAME="archiveHungErrors"
                 WARNING="0" OPERATOR="GT"
                 MESSAGE="Archiver hung errors have been found in the alert log."
                 MESSAGE_NLSID="alertLogStatus_archiveHungErrors_alertmessage" />

      <!--
      ==================================================================
      == Alert: Data Block Corruption Errors
      ==================================================================
        -->
      <Condition COLUMN_NAME="blockCorruptErrors"
                 WARNING="0" OPERATOR="GT"
                 MESSAGE="Data block corruption errors have been found in the alert log."
                 MESSAGE_NLSID="alertLogStatus_blockCorruptErrors_alertmessage" />

      <!--
      ====================================================================
      == Alert: Session Terminated Error Stack
      ====================================================================
        -->
      <Condition COLUMN_NAME="sessTerminateErrors"
                 WARNING="0" OPERATOR="GT"
                 MESSAGE="Session terminations have been found in the alert log."
                 MESSAGE_NLSID="alertLogStatus_sessTerminateErrors_alertmessage" />
                 
      <!--
      ==================================================================
      == Alert: Media Failure Errors
      ==================================================================
        -->
      <Condition COLUMN_NAME="mediaFailureErrors"
                 WARNING="0" OPERATOR="GT"
                 MESSAGE="Media failure errors have been found in the alert log."
                 MESSAGE_NLSID="alertLogStatus_mediaFailureErrors_alertmessage" />
                 
    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Group: adr_alert_log_rollup
  ======================================================================
  -->
  <CollectionItem NAME="adr_alert_log_rollup" COLLECT_WHEN_ALTSKIP="TRUE"
      COLLECT_WHEN_DOWN="TRUE">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR1;11gR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>

    <MetricColl NAME="adrAlertLogError">
      <ItemProperty NAME="limitSwitch">270</ItemProperty>
    </MetricColl>

    <!--
    ====================================================================
    == Category: ADR Alert Log Incident Error
    == Fetchlet: Perl
    == (NB: An alert log error stack never contributes to more than one
    ==      event.)
    ====================================================================
    -->
    <MetricColl NAME="adrAlertLogIncidentError">

      <!--
      ==================================================================
      == User Property: switch imposing scanning limit
      == Supported Values:
      ==  <positive integer>: time limit, in seconds
      ==  EOF:                scan entire log, discard all entries
      ==  tail:               process the entire tail/no time limit
      ==================================================================
      -->
      <ItemProperty NAME="limitSwitch">270</ItemProperty>

      <!--
      ==================================================================
      == Alert: Generic Incident Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="genericIncidentErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="Incident (%errCodes%) detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_genericIncidentErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Generic Internal Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="genericInternalErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="Internal error (%errCodes%) detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_genericInternalErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Session Terminated Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="sessTerminateErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="A session termination detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_sessTerminateErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>
                 
      <!--
      ==================================================================
      == Alert: Internal SQL Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="internalSqlErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="An internal SQL error detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_internalSqlErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Access Violation Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="accessViolationErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="An access violation detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_accessViolationErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Redo Log Corruption Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="redoLogCorruptErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="A redo log corruption detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_redoLogCorruptErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: File Access Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="fileAccessErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="A file access error detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_fileAccessErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Inconsistent DB State Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="inconsistentDbStateErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="An inconsistent DB state detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_inconsistentDbStateErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Block Corruption Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="oraBlockCorruptErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="An Oracle data block corruption detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_oraBlockCorruptErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Deadlock Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="deadlockErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="A deadlock detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_deadlockErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Out of Memory Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="outOfMemoryErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="Out of memory detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_outOfMemoryErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Cluster Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="clusterErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="A cluster error detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_clusterErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

    </MetricColl>

    <!--
    ====================================================================
    == Category: ADR Alert Log Operational Error
    == Fetchlet: Perl
    == (NB: An alert log error stack never contributes to more than one
    ==      event.)
    ====================================================================
    -->
    <MetricColl NAME="adrAlertLogOperationalError">

      <!--
      ==================================================================
      == User Property: switch imposing scanning limit
      == Supported Values:
      ==  <positive integer>: time limit, in seconds
      ==  EOF:                scan entire log, discard all entries
      ==  tail:               process the entire tail/no time limit
      ==================================================================
      -->
      <ItemProperty NAME="limitSwitch">270</ItemProperty>

      <!--
      ==================================================================
      == Alert: Generic Operational Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="genericOperationalErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="Operational error (%errCodes%) detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_genericOperationalErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Archiver Hung Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="archiveHungErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="Archiver hang detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_archiveHungErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Media Failure Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="mediaFailureErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="Media failure detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_mediaFailureErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

      <!--
      ==================================================================
      == Alert: Data Block Corruption Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="blockCorruptErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="A data block corruption detected in %alertLogName% at time/line number: %timeLine%."
                 MESSAGE_NLSID="adrAlertLog_blockCorruptErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

    </MetricColl>

    <!--
    ====================================================================
    == Category: ADR Alert Log Data Failure
    == Fetchlet: Perl
    == (NB: An alert log error stack never contributes to more than one
    ==      event.)
    ====================================================================
    -->
    <MetricColl NAME="adrAlertLogDataFailure">

      <!--
      ==================================================================
      == User Property: switch imposing scanning limit
      == Supported Values:
      ==  <positive integer>: time limit, in seconds
      ==  EOF:                scan entire log, discard all entries
      ==  tail:               process the entire tail/no time limit
      ==================================================================
      -->
      <ItemProperty NAME="limitSwitch">270</ItemProperty>

      <!--
      ==================================================================
      == Alert: Data Failure Error Stack
      ==================================================================
      -->
      <Condition COLUMN_NAME="dataFailureErrStack"
                 CRITICAL=".*" OPERATOR="MATCH"
                 MESSAGE="Checker run found %numberOfFailures% new persistent data failures."
                 MESSAGE_NLSID="adrAlertLog_dataFailuresErrStack_alertmessage"
                 NO_CLEAR_ON_NULL="TRUE"/>

    </MetricColl>

    <!--
    ====================================================================
    == Category: ADR Alert Log Incident Error Status
    == Fetchlet: Aggregation
    ====================================================================
    -->
    <MetricColl NAME="adrAlertLogIncidentErrorStatus">

      <!--
      ==================================================================
      == User Property: switch imposing scanning limit
      == Supported Values:
      ==  <positive integer>: time limit, in seconds
      ==  EOF:                scan entire log, discard all entries
      ==  tail:               process the entire tail/no time limit
      ==================================================================
      -->
      <ItemProperty NAME="limitSwitch">270</ItemProperty>

      <!--
      ==================================================================
      == Alert: Generic Incident Errors
      ==================================================================
      -->
      <Condition COLUMN_NAME="genericIncidentErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="%value% distinct types of incidents have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_genericIncidentErrors_alertmessage"/>

      <!--
      ==================================================================
      == Alert: Generic Internal Errors
      ==================================================================
      -->
      <Condition COLUMN_NAME="genericInternalErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Generic internal errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_genericInternalErrors_alertmessage"/>

      <!--
      ====================================================================
      == Alert: Session Terminated Errors
      ====================================================================
      -->
      <Condition COLUMN_NAME="sessTerminateErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Session terminations have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_sessTerminateErrors_alertmessage"/>

      <!--
      ====================================================================
      == Alert: Internal SQL Errors
      ====================================================================
      -->
      <Condition COLUMN_NAME="internalSqlErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Internal SQL errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_internalErrors_alertmessage"/>

      <!--
      ====================================================================
      == Alert: Access Violation Errors
      ====================================================================
      -->
      <Condition COLUMN_NAME="accessViolationErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Access violation errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_accessViolationErrors_alertmessage"/>

      <!--
      ====================================================================
      == Alert: Redo Log Corruption Errors
      ====================================================================
      -->
      <Condition COLUMN_NAME="redoLogCorruptErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Redo log corruption errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_redoLogCorruptErrors_alertmessage"/>

      <!--
      ====================================================================
      == Alert: File Access Errors
      ====================================================================
      -->
      <Condition COLUMN_NAME="fileAccessErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="File access errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_fileAccessErrors_alertmessage"/>

      <!--
      ====================================================================
      == Alert: Inconsistent DB State Errors
      ====================================================================
      -->
      <Condition COLUMN_NAME="inconsistentDbStateErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Inconsistent DB state errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_inconsistentDbStateErrors_alertmessage"/>

      <!--
      ==================================================================
      == Alert: Oracle Data Block Corruption Errors
      ==================================================================
      -->
      <Condition COLUMN_NAME="oraBlockCorruptErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Oracle data block corruption errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_oraBlockCorruptErrors_alertmessage"/>

      <!--
      ====================================================================
      == Alert: Deadlock Errors
      ====================================================================
      -->
      <Condition COLUMN_NAME="deadlockErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Deadlocks have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_deadlockErrors_alertmessage"/>

      <!--
      ====================================================================
      == Alert: Ouf of Memory Errors
      ====================================================================
      -->
      <Condition COLUMN_NAME="outOfMemoryErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Out of memory errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_outOfMemoryErrors_alertmessage"/>

      <!--
      ====================================================================
      == Alert: Cluster Errors
      ====================================================================
      -->
      <Condition COLUMN_NAME="clusterErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Cluster errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_clusterErrors_alertmessage"/>

    </MetricColl>

    <!--
    ====================================================================
    == Category: ADR Alert Log Operational Error Status
    == Fetchlet: Aggregation
    ====================================================================
    -->
    <MetricColl NAME="adrAlertLogOperationalErrorStatus">

      <!--
      ==================================================================
      == User Property: switch imposing scanning limit
      == Supported Values:
      ==  <positive integer>: time limit, in seconds
      ==  EOF:                scan entire log, discard all entries
      ==  tail:               process the entire tail/no time limit
      ==================================================================
      -->
      <ItemProperty NAME="limitSwitch">270</ItemProperty>

      <!--
      ==================================================================
      == Alert: Generic Operational Errors
      ==================================================================
      -->
      <Condition COLUMN_NAME="genericOperationalErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="%value% distinct types of operational errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_genericOperationalErrors_alertmessage"/>

      <!--
      ==================================================================
      == Alert: Archiver Hung Errors
      ==================================================================
      -->
      <Condition COLUMN_NAME="archiveHungErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Archiver hung errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_archiveHungErrors_alertmessage" />

      <!--
      ==================================================================
      == Alert: Data Block Corruption Errors
      ==================================================================
      -->
      <Condition COLUMN_NAME="blockCorruptErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Data block corruption errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_blockCorruptErrors_alertmessage" />

      <!--
      ==================================================================
      == Alert: Media Failure Errors
      ==================================================================
      -->
      <Condition COLUMN_NAME="mediaFailureErrors"
                 CRITICAL="0" OPERATOR="GT"
                 MESSAGE="Media failure errors have been found in the alert log."
                 MESSAGE_NLSID="adrAlertLogStatus_mediaFailureErrors_alertmessage" />
                 
    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Group: log_full
  ======================================================================
    -->
  <CollectionItem NAME="log_full" COLLECT_WHEN_ALTSKIP="TRUE">
    <Schedule>
      <IntervalSchedule INTERVAL="15" TIME_UNIT="Min" />
    </Schedule>

    <!--
    ====================================================================
    == Category: Dump Area
    == Fetchlet: Perl
    ====================================================================
      -->
    <MetricColl NAME="dumpFull">

      <!--
      ==================================================================
      == Alert: Dump Area Used (%)
      ==================================================================
        -->
      <Condition COLUMN_NAME="dumpUsedPercent"
                 WARNING="95" OPERATOR="GT"
                 MESSAGE="%value%%% of %dumpType% dump area is used."
                 MESSAGE_NLSID="dumpFull_dumpUsedPercent_alertmessage" />

      <!--
      ==================================================================
      == Alert: Free Dump Area (KB)
      ==================================================================
        -->
      <Condition COLUMN_NAME="dumpAvail"
                 WARNING="2000" OPERATOR="LT"
                 MESSAGE="%value% free KB remains in %dumpType% dump area."
                 MESSAGE_NLSID="dumpFull_dumpAvail_alertmessage" />
    </MetricColl>

    <!--
    ====================================================================
    == Category: Archive Area
    == Fetchlet: Perl
    ====================================================================
      -->
    <MetricColl NAME="archFull">

      <!--
      ==================================================================
      == Alert: Archive Area Used (%)
      ==================================================================
        -->
      <Condition COLUMN_NAME="archUsedPercent"
                 WARNING="80" OPERATOR="GT"
                 MESSAGE="%value%%% of archive area %archDir% is used."
                 MESSAGE_NLSID="archFull_archUsedPercent_alertmessage" />

      <!--
      ==================================================================
      == Alert: Free Archive Area (KB)
      ==================================================================
        -->
      <Condition COLUMN_NAME="archAvail"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 MESSAGE="Archive area %archDir% has %value% free KB remaining."
                 MESSAGE_NLSID="archFull_archAvail_alertmessage" />
    </MetricColl>
  </CollectionItem>

  <!--
  ======================================================================
  == Group: mgmt_sql
  ======================================================================
    -->
  <CollectionItem NAME="mgmt_sql" UPLOAD_ON_FETCH="TRUE">
    <Schedule>
      <IntervalSchedule INTERVAL="24" TIME_UNIT="Hr"/>
    </Schedule>


    <!--
    ====================================================================
    == Category: mgmt_sql_helper
    ====================================================================
      -->
     <MetricColl NAME="mgmt_sql_metric_helper"/>

    <!--
    ====================================================================
    == Category: mgmt_sql_summary
    ====================================================================
      -->
    <MetricColl NAME="mgmt_sql_summary">
     <ItemProperty NAME="PHY_READ_PCT">0.005</ItemProperty>
     <ItemProperty NAME="LOG_READ_PCT">0.005</ItemProperty>
     <ItemProperty NAME="CPU_TIME_PCT">0.005</ItemProperty>
     <ItemProperty NAME="PAR_CALL_PCT">0.005</ItemProperty>
     <ItemProperty NAME="EXEC_PCT">0.1</ItemProperty>
    </MetricColl>

    <!--
    ====================================================================
    == Category: mgmt_sql_plan
    == Fetchlet: SQL
    ====================================================================
      -->
    <MetricColl NAME="mgmt_sql_plan">
     <ItemProperty NAME="PHY_READ_PCT">0.005</ItemProperty>
     <ItemProperty NAME="LOG_READ_PCT">0.005</ItemProperty>
     <ItemProperty NAME="CPU_TIME_PCT">0.005</ItemProperty>
     <ItemProperty NAME="PAR_CALL_PCT">0.005</ItemProperty>
     <ItemProperty NAME="EXEC_PCT">0.1</ItemProperty>
    </MetricColl>

    <!--
    ====================================================================
    == Category: mgmt_sql_reuse
    == Fetchlet: SQL
    ====================================================================
    <MetricColl NAME="mgmt_sql_reuse" />
      -->
  </CollectionItem>

  <!--
  ======================================================================
  == Category: User Block - 9i
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="UserBlock_9i" UPLOAD="NO">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>

    <MetricColl NAME="UserBlock">

      <!--
      ==================================================================
      == Alert: Blocking Session Count
      ==================================================================
        -->
      <Condition COLUMN_NAME="count"
                 WARNING="0" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="Session %sid% blocking %value% other sessions."
                 MESSAGE_NLSID="UserBlock_count_alertmessage" />
    </MetricColl>

  </CollectionItem>

  <!--
  ======================================================================
  == Category: User Block - 10i
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="UserBlock_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="UserBlock">

      <!--
      ==================================================================
      == Alert: Blocking Session Count
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="count"
                 WARNING="0" OPERATOR="GT"
                 OCCURRENCES="15" />

    </MetricColl>

  </CollectionItem>

  <!--
  ======================================================================
  == Category: User Block Chain - 10i
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="UserBlockChain_10i" UPLOAD="NO" DISABLED="TRUE">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="15" TIME_UNIT="Min"/>
    </Schedule>
    <MetricColl NAME="UserBlockChain" UPLOAD_IF_SEVERITY="WARNING">

      <!--
      ==================================================================
      == Alert: DB time in lock chain
      ==================================================================
        -->
      <Condition COLUMN_NAME="db_time"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="1" 
                 MESSAGE="Total db time %value% seconds is consumed by %count% sessions blocked by session (%blocker_session_info%)."
                 MESSAGE_NLSID="UserBlockChain_dbtime_alertmessage" />
    </MetricColl>

  </CollectionItem>


  <!--
  ======================================================================
  == Category: User Audit
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="UserAudit" UPLOAD="NO">
    <Schedule>
      <IntervalSchedule INTERVAL="15" TIME_UNIT="Min"/>
    </Schedule>

    <!--
    ====================================================================
    == Alert: Audited User
    ====================================================================
      -->
    <Condition COLUMN_NAME="username"
               WARNING="SYS" OPERATOR="EQ"
               MESSAGE="User %value% logged on from %machine%."
               MESSAGE_NLSID="UserAudit_username_alertmessage" />
  </CollectionItem>

  <!--
  ======================================================================
  == Group: sessions_in_wait
  ======================================================================
    -->
  <CollectionItem NAME="sessions_in_wait_9i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="1" TIME_UNIT="Min"/>
    </Schedule>

    <!--
    ====================================================================
    == Category: Wait by Session Count
    == Fetchlet: SQL
    ====================================================================
      -->
    <MetricColl NAME="wait_sess">

      <!--
      ==================================================================
      == Alert: Session Waiting for Event Count
      ==================================================================
        -->
      <Condition COLUMN_NAME="count"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value% sessions are waiting for event %event%."
                 MESSAGE_NLSID="wait_sess_count_alertmessage" />
    </MetricColl>

    <!--
    ====================================================================
    == Category: System Sessions Waiting
    == Fetchlet: Aggregate
    ====================================================================
      -->
    <MetricColl NAME="sessions_in_wait">

      <!--
      ==================================================================
      == Alert: Session Waiting Count
      ==================================================================
        -->
      <Condition COLUMN_NAME="total_count"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="%value% sessions are waiting."
                 MESSAGE_NLSID="sessions_in_wait_total_count_alertmessage" />
    </MetricColl>
  </CollectionItem>


  <CollectionItem NAME = "rac_global_cache_9i" UPLOAD="3">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
    </ValidIf>
     <Schedule>
        <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
     </Schedule>

    <MetricColl NAME="rac_global_cache">

     <Condition COLUMN_NAME="lost"
                CRITICAL="3" WARNING="1" OPERATOR="GT"
                OCCURRENCES="1"
                MESSAGE="Total global cache block lost is %value%."
                 MESSAGE_NLSID="rac_global_cache_lost_alertmessage" />
     <Condition COLUMN_NAME="corrupt"
                CRITICAL="0" WARNING="0" OPERATOR="GT"
                OCCURRENCES="1"
                MESSAGE="Total global cache blocks corrupt is %value%."
                 MESSAGE_NLSID="rac_global_cache_corrupt_alertmessage" />
     <Condition COLUMN_NAME="converts_cs"
                CRITICAL="0.6" WARNING="0.3" OPERATOR="GT"
                OCCURRENCES="2"
                MESSAGE="Global cache converts time is %value% cs."
                 MESSAGE_NLSID="rac_global_cache_converts_cs_alertmessage" />
     <Condition COLUMN_NAME="cr_request_cs"
                CRITICAL="1" WARNING="0.5" OPERATOR="GT"
                OCCURRENCES="1"
                MESSAGE="Global cache CR Block request time is %value% cs."
                 MESSAGE_NLSID="rac_global_cache_cr_request_cs_alertmessage" />
     <Condition COLUMN_NAME="currentgets_cs"
                CRITICAL="1" WARNING="0.5" OPERATOR="GT"
                OCCURRENCES="1"
                MESSAGE="Global cache Current Block request time is %value% cs."
                 MESSAGE_NLSID="rac_global_cache_currentgets_cs_alertmessage" />
     <Condition COLUMN_NAME="gets_cs"
                CRITICAL="0.6" WARNING="0.3" OPERATOR="GT"
                OCCURRENCES="2"
                MESSAGE="Global cache gets time is %value% cs."
                 MESSAGE_NLSID="rac_global_cache_gets_cs_alertmessage" />
    </MetricColl>

  </CollectionItem>


  <CollectionItem NAME = "rac_global_cache_10i" UPLOAD="3">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="rac_global_cache">

     <Condition PUSH="TRUE" COLUMN_NAME="lost"
                CRITICAL="3" WARNING="1" OPERATOR="GT"
                OCCURRENCES="1" />
     <Condition PUSH="TRUE" COLUMN_NAME="corrupt"
                CRITICAL="0" WARNING="0" OPERATOR="GT"
                OCCURRENCES="1" />
     <Condition PUSH="TRUE" COLUMN_NAME="cr_request_cs"
                CRITICAL="2" WARNING="1" OPERATOR="GT"
                OCCURRENCES="1" />
     <Condition PUSH="TRUE" COLUMN_NAME="currentgets_cs"
                CRITICAL="2" WARNING="1" OPERATOR="GT"
                OCCURRENCES="1" />
    </MetricColl>
  </CollectionItem>


  <CollectionItem NAME="latest_hdm_findings_coll_item"  UPLOAD_ON_FETCH="TRUE">
    <Schedule>
      <IntervalSchedule INTERVAL="15" TIME_UNIT="Min"/>
    </Schedule>
     <MetricColl NAME="latest_hdm_metric_helper"/>
     <MetricColl NAME="latest_hdm_findings"/>
  </CollectionItem>

  <!-- NEW
  ======================================================================
  == Category: Wait by Session Class - 10i
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="wait_sess_cls_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="wait_sess_cls">

      <!--
      ==================================================================
      == Alert: Total Wait Counts (centi-seconds)
      ==================================================================
        -->
      <Condition PUSH="TRUE" COLUMN_NAME="avg_users_waiting_on_class"
                 WARNING="10" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Administrative</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_waitclass_pct"
                 WARNING="30" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Administrative</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="avg_users_waiting_on_class"
                 WARNING="10" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Application</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_waitclass_pct"
                 WARNING="30" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Application</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="avg_users_waiting_on_class"
                 WARNING="30" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Cluster</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_waitclass_pct"
                 WARNING="50" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Cluster</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="avg_users_waiting_on_class"
                 WARNING="30" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Commit</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_waitclass_pct"
                 WARNING="50" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Commit</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="avg_users_waiting_on_class"
                 WARNING="10" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Concurrency</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_waitclass_pct"
                 WARNING="30" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Concurrency</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="avg_users_waiting_on_class"
                 WARNING="10" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Configuration</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_waitclass_pct"
                 WARNING="30" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Configuration</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="avg_users_waiting_on_class"
                 WARNING="10" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Network</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_waitclass_pct"
                 WARNING="30" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Network</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="avg_users_waiting_on_class"
                 WARNING="10" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Other</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_waitclass_pct"
                 WARNING="30" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Other</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="avg_users_waiting_on_class"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Scheduler</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_waitclass_pct"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">Scheduler</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="avg_users_waiting_on_class"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">System I/O</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_waitclass_pct"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">System I/O</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="avg_users_waiting_on_class"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">User I/O</KeyColumn>
      </Condition>
      <Condition PUSH="TRUE" COLUMN_NAME="dbtime_waitclass_pct"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3">
        <KeyColumn COLUMN_NAME="class">User I/O</KeyColumn>
      </Condition>
    </MetricColl>
  </CollectionItem>
  <!-- NEW
  ======================================================================
  == Category: System Response Time Per Call - 10i
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="system_response_time_per_call_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="system_response_time_per_call">
    <!--
    ====================================================================
    == Alert: System Response Time (centi-seconds)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="time_cs"
               WARNING="NotDefined" OPERATOR="GT" />
    </MetricColl>
  </CollectionItem>

  <!-- NEW
  ======================================================================
  == Category: File - 10i
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="file_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="file">

    <!--
    ====================================================================
    == Alert: Average File Read Time (centi-seconds)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="read_cs"
               WARNING="NotDefined" OPERATOR="GT" />
    <!--
    ====================================================================
    == Alert: Average File Write Time (centi-seconds)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="write_cs"
               WARNING="NotDefined" OPERATOR="GT" />
    </MetricColl>
  </CollectionItem>
  <!-- NEW
  ======================================================================
  == Category: Service - 10i
  == Fetchlet: SQL
  ======================================================================
    -->
  <CollectionItem NAME="service_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="service">
    <!--
    ====================================================================
    == Alert: Elapsed Time Per User Call (centi-seconds)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="elapsed_cs"
               WARNING="NotDefined" OPERATOR="GT" />
    <!--
    ====================================================================
    == Alert: CPU Time Per User Call (centi-seconds)
    ====================================================================
      -->
    <Condition PUSH="TRUE" COLUMN_NAME="cpu_cs"
               WARNING="NotDefined" OPERATOR="GT" />
    </MetricColl>
  </CollectionItem>


<!-- ESM metric -->
  <CollectionItem NAME = "oracle_security_inst" 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="secureOSAuditLevel" />
     <MetricColl NAME="umaskSetting" />
     <MetricColl NAME="osauthPrefixDomain" />
     <MetricColl NAME="logArchiveDest" />
     <MetricColl NAME="ohBinFilesOwner" />
     <MetricColl NAME="ohFilesPermission" />
     <MetricColl NAME="ohExeBinFilesPerm" />
     <MetricColl NAME="dbParamCollection" />
     <MetricColl NAME="dbInitParamFilesPerm" />
     <MetricColl NAME="dbAuditPerm" />
     <MetricColl NAME="utlFileDirSetting" />
     <MetricColl NAME="iFileRefPerm" />
     <MetricColl NAME="files_perm_owner" />
     <MetricColl NAME="otrace" />   
     <MetricColl NAME="windowsPlatform" />   
     <MetricColl NAME="drivePerm" />   
     <MetricColl NAME="domainUsersGrp" />   
     <MetricColl NAME="wintools" />   
<!-- ESA 10gR2 collection ends -->

     <MetricColl NAME="remoteRolesAndAuthentication" />
     <MetricColl NAME="remoteLoginPasswordFile" />
  </CollectionItem>

  <CollectionItem NAME="haconfig2_collection">
    <Schedule>
      <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
    </Schedule>
    <MetricColl NAME="ha_mttr"/>
  </CollectionItem>

<!-- RAC Instance Interconnect -->
  <CollectionItem NAME="ha_rac_intrconn" UPLOAD_ON_FETCH="TRUE" CONFIG="TRUE">
    <Schedule>
      <IntervalSchedule INTERVAL = "12" TIME_UNIT = "Hr"/>
    </Schedule>
  </CollectionItem>

  <CollectionItem NAME="ha_rac_intrconn_traffic">
    <Schedule>
      <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
    </Schedule>

    <Condition COLUMN_NAME="interconnect_rate"
                CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                OCCURRENCES="1" />
  </CollectionItem>

  <CollectionItem NAME="ha_rac_intrconn_type">
    <Schedule>
      <IntervalSchedule INTERVAL = "12" TIME_UNIT = "Hr"/>
    </Schedule>

    <Condition COLUMN_NAME="if_type"
               WARNING="Unknown" 
               CRITICAL="Public" OPERATOR="EQ"
               MESSAGE="The instance is using interface '%if_name%' of type '%value%'."
               MESSAGE_NLSID="rac_interface_non_public"  />

  </CollectionItem>
  

<!-- Policy Collection: oracle_dbconfig                              -->
<!-- Description: Collects data for all the raw metrics that have    -->
<!--              been defined for the configuration policies.       -->
<!-- NOTE: This is for oracle_database type only, rac instances will -->
<!--       use the oracle_racconfig definition located in            -->
<!--       rac_database.xml.  The rac version of this collection     -->
<!--       does not include db_init_params and db_sga.               --> 
<!-- NOTE: db_datafiles is no longer used by the Policies, but       -->
<!--       the data is still used in EM, so it must be collected.    -->
  <CollectionItem NAME="oracle_dbconfig" UPLOAD_ON_FETCH="TRUE" CONFIG="TRUE">
     <Schedule>
      <IntervalSchedule INTERVAL = "24" TIME_UNIT = "Hr"/>
     </Schedule>

     <MetricColl NAME="db_init_params"/>
     <MetricColl NAME="db_sga"/>
     <MetricColl NAME="db_tablespaces"/>
     <MetricColl NAME="db_datafiles"/>
     <MetricColl NAME="db_controlfiles"/>
     <MetricColl NAME="db_redoLogs"/>
     <MetricColl NAME="db_rollback_segs"/>
     <MetricColl NAME="db_license"/>
     <MetricColl NAME="db_options"/>
     <MetricColl NAME="db_dbNInstanceInfo"/>

     <MetricColl NAME="ha_info"/>
     <MetricColl NAME="ha_rman_config"/>

  </CollectionItem>
  <!-- End of db configuration collection -->

 <!--
  ======================================================================
  == Category: Start SGA Collector
  == Fetchlet: OSLineTok
  ======================================================================
    -->
  <CollectionItem NAME="sga_start">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR203;11gR1;11gR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>
    <MetricColl NAME="sga_start"> 
     <!--
     ==================================================================
     == User Property:    rdbmsGroupOwner
     == When to use:      if your database group owner is not the 'dba' group,
     ==                   specify the database group owner in the ItemProperty
     ==                   entity below and uncomment it
     == Supported Values: the group owner of the database installation
     ==================================================================
       -->
     <!--
     <ItemProperty NAME="rdbmsGroupOwner">replace this with the group owner of your database installation, if not dba</ItemProperty>
       -->
    </MetricColl>
  </CollectionItem>

 <!-- ******** Begin Baseline Metric Metadata Collection ******** -->

  <CollectionItem NAME="baseline_metadata">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="1" TIME_UNIT="Hr"/>
    </Schedule>

    <!--
    ==========================================================================
    == Metric:   Metrics with Adaptive Thresholds
    == Fetchlet: SQL
    ==========================================================================
      -->
    <MetricColl NAME="db_bsln_adaptive_thresholds"/>
  </CollectionItem>

  <!-- ******** End Baseline Metric Metadata Collection ******** -->

  <CollectionItem NAME="pwd_expiry">
   <Schedule>
     <IntervalSchedule INTERVAL="24" TIME_UNIT="Hr"/>
   </Schedule>
   <MetricColl NAME="pwd_expiry"/>
 </CollectionItem> 

  <!--
  ======================================================================
  == Group: Incident Meter
  ======================================================================
  -->
  <CollectionItem NAME="incident_meter">
    <Schedule>
      <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>

    <!--
    ======================================================================
    == Category: Collect Incident Meter
    == Fetchlet: SQL
    ======================================================================
    -->
    <MetricColl NAME="incident_meter"/>
  </CollectionItem>
