Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\default

Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\default_collection\instance.xmlp

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

<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" />

<Condition COLUMN_NAME="userLogon"
               WARNING="1000" OPERATOR="GT"
               OCCURRENCES="6"
               MESSAGE="User logon time is %value% msecs."
               MESSAGE_NLSID="Response_userLogon_alertmessage"  />

<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>

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

<MetricColl NAME="sql_response_collect"/>

<MetricColl NAME="sql_response">
      
      <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>

<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">

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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>

<CollectionItem NAME="instance_throughput_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="instance_throughput">

<Condition PUSH="TRUE" COLUMN_NAME="transactions_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GE"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="physreads_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="physreads_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="physwrites_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="physwrites_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="physreadsdir_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="physreadsdir_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="physwritesdir_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="physwritesdir_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="physreadslob_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="physreadslob_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="physwriteslob_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="physwriteslob_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="redosize_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="redosize_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="logons_ps"
                 WARNING="100" OPERATOR="GE"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="logons_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE"  COLUMN_NAME="opncurs_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE"  COLUMN_NAME="opncurs_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="commits_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="commits_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="rollbacks_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="rollbacks_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="usercalls_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="usercalls_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="recurscalls_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="recurscalls_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="logreads_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="logreads_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="dbwrcheckpoints_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="bgcheckpoints_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
   
      <Condition PUSH="TRUE" COLUMN_NAME="redowrites_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="redowrites_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="tabscanslong_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="tabscanslong_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="tabscanstotal_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="tabscanstotal_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="indxscansfull_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="indxscansfull_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="indxscanstotal_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="indxscanstotal_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
     
      <Condition PUSH="TRUE" COLUMN_NAME="parses_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="parses_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="hardparses_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="hardparses_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="failedparses_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="failedparses_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="executions_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="sortsdisk_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="sortsdisk_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="rows_psort"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="executeswoparse_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="softparse_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="usercall_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2" />
                 
      
      <Condition PUSH="TRUE" COLUMN_NAME="networkbytes_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="enqtimeouts_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="enqtimeouts_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="enqwaits_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="enqwaits_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="enqdeadlocks_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="enqdeadlocks_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="enqreqs_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="enqreqs_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="dbblkgets_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="dbblkgets_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="consistentreadgets_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="consistentreadgets_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="dbblkchanges_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
     
      <Condition PUSH="TRUE" COLUMN_NAME="dbblkchanges_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="consistentreadchanges_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="consistentreadchanges_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="crblks_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="crblks_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="crundorecs_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="crundorecs_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="userrollbackundorec_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="userrollbackundorec_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2"/>
      
      <Condition PUSH="TRUE" COLUMN_NAME="leafnodesplits_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
        
      <Condition PUSH="TRUE" COLUMN_NAME="leafnodesplits_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
        
      <Condition PUSH="TRUE" COLUMN_NAME="branchnodesplits_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />
        
      <Condition PUSH="TRUE" COLUMN_NAME="branchnodesplits_pt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="dbtime_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="avg_active_sessions"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="avg_sync_singleblk_read_latency"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="iombs_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="iorequests_ps"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="2" />

</MetricColl>
  </CollectionItem>

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

<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" />

<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" />

<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" />

<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>

<CollectionItem NAME="instance_efficiency_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="instance_efficiency">

<Condition PUSH="TRUE" COLUMN_NAME="bufcachehit_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="libcache_hit_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="dictionaryhit_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="dictionarymiss_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2"/>
    
    <Condition PUSH="TRUE" COLUMN_NAME="inmem_sort_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="cursorcachehit_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2" />

<Condition PUSH="TRUE" COLUMN_NAME="cpuusage_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
    
    <Condition PUSH="TRUE" COLUMN_NAME="cpuusage_pt"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
    
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrd25_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2"/>
    
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrd50_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
   
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrd75_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2"/>
   
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrd_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
   
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrdserial_ps"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
   
    <Condition PUSH="TRUE" COLUMN_NAME="pxdwngrdserial_pt"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2"/>

<Condition PUSH="TRUE" COLUMN_NAME="cpu_time_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2" />
   
    <Condition PUSH="TRUE" COLUMN_NAME="response_time_pt"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
   
    <Condition PUSH="TRUE" COLUMN_NAME="pgacachehit_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               OCCURRENCES="2" />
    
    <Condition PUSH="TRUE" COLUMN_NAME="libcache_miss_pct"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
               OCCURRENCES="2" />
    </MetricColl>
  </CollectionItem>

<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">

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

<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" />

</MetricColl>

</CollectionItem>

<CollectionItem NAME="wait_bottlenecks_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>

<Condition PUSH="TRUE" COLUMN_NAME="user_wait_time_pct"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="userio_wait_cnt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3" />
      
      <Condition PUSH="TRUE" COLUMN_NAME="other_wait_cnt"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3" />
    </MetricColl>
  </CollectionItem>

<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>

<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" />

<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" />

<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>

<CollectionItem NAME="sga_pool_wastage_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>

<Condition PUSH="TRUE" COLUMN_NAME="shared_free_pct"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
                 OCCURRENCES="2" />

</MetricColl>

</CollectionItem>

<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"/>

<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"/>

<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"/>

<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>

<CollectionItem NAME="Database_Resource_Usage_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>

<Condition PUSH="TRUE" COLUMN_NAME="logons"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"/>

<Condition PUSH="TRUE" COLUMN_NAME="session_usage"
                 WARNING="90" CRITICAL="97" OPERATOR="GT"
                 OCCURRENCES="3"/>

<Condition PUSH="TRUE" COLUMN_NAME="user_limit"
                 WARNING="NotDefined" OPERATOR="GT"
                 OCCURRENCES="3"/>

<Condition PUSH="TRUE" COLUMN_NAME="opencursors"
                 WARNING="1200" OPERATOR="GT"
                 OCCURRENCES="3"/>
    </MetricColl>
  </CollectionItem>

<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>

<MetricColl NAME="alertLog">

<ItemProperty NAME="limitSwitch">870</ItemProperty>

<ItemProperty NAME="ignorePattern">.*ORA-0*(54|1142|1146)\D.*</ItemProperty>

<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" />

<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" />

<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" />

<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" />
                 
      
      <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>

<MetricColl NAME="alertLogStatus">

<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" />

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

<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" />

<Condition COLUMN_NAME="sessTerminateErrors"
                 WARNING="0" OPERATOR="GT"
                 MESSAGE="Session terminations have been found in the alert log."
                 MESSAGE_NLSID="alertLogStatus_sessTerminateErrors_alertmessage" />
                 
      
      <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>

<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="adrAlertLogIncidentError">

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

<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"/>

<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"/>

<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"/>
                 
      
      <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"/>

<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"/>

<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"/>

<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"/>

<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"/>

<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"/>

<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"/>

<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"/>

<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>

<MetricColl NAME="adrAlertLogOperationalError">

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

<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"/>

<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"/>

<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"/>

<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>

<MetricColl NAME="adrAlertLogDataFailure">

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

<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>

<MetricColl NAME="adrAlertLogIncidentErrorStatus">

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

<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"/>

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

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

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

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

<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"/>

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

<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"/>

<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"/>

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

<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"/>

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

</MetricColl>

<MetricColl NAME="adrAlertLogOperationalErrorStatus">

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

<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"/>

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

<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" />

<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>

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

<MetricColl NAME="dumpFull">

<Condition COLUMN_NAME="dumpUsedPercent"
                 WARNING="95" OPERATOR="GT"
                 MESSAGE="%value%%% of %dumpType% dump area is used."
                 MESSAGE_NLSID="dumpFull_dumpUsedPercent_alertmessage" />

<Condition COLUMN_NAME="dumpAvail"
                 WARNING="2000" OPERATOR="LT"
                 MESSAGE="%value% free KB remains in %dumpType% dump area."
                 MESSAGE_NLSID="dumpFull_dumpAvail_alertmessage" />
    </MetricColl>

<MetricColl NAME="archFull">

<Condition COLUMN_NAME="archUsedPercent"
                 WARNING="80" OPERATOR="GT"
                 MESSAGE="%value%%% of archive area %archDir% is used."
                 MESSAGE_NLSID="archFull_archUsedPercent_alertmessage" />

<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>

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

<MetricColl NAME="mgmt_sql_metric_helper"/>

<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>

<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>

</CollectionItem>

<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>

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

</CollectionItem>

<CollectionItem NAME="UserBlock_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="UserBlock">

<Condition PUSH="TRUE" COLUMN_NAME="count"
                 WARNING="0" OPERATOR="GT"
                 OCCURRENCES="15" />

</MetricColl>

</CollectionItem>

<CollectionItem NAME="UserBlockChain_10i" UPLOAD="NO">
    <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">

<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>

<CollectionItem NAME="UserAudit" UPLOAD="NO">
    <Schedule>
      <IntervalSchedule INTERVAL="15" TIME_UNIT="Min"/>
    </Schedule>

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

<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>

<MetricColl NAME="wait_sess">

<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>

<MetricColl NAME="sessions_in_wait">

<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>

<CollectionItem NAME="wait_sess_cls_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="wait_sess_cls">

<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>
  
  <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">
    
    <Condition PUSH="TRUE" COLUMN_NAME="time_cs"
               WARNING="NotDefined" OPERATOR="GT" />
    </MetricColl>
  </CollectionItem>

<CollectionItem NAME="file_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="file">

<Condition PUSH="TRUE" COLUMN_NAME="read_cs"
               WARNING="NotDefined" OPERATOR="GT" />
    
    <Condition PUSH="TRUE" COLUMN_NAME="write_cs"
               WARNING="NotDefined" OPERATOR="GT" />
    </MetricColl>
  </CollectionItem>
  
  <CollectionItem NAME="service_10i">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <MetricColl NAME="service">
    
    <Condition PUSH="TRUE" COLUMN_NAME="elapsed_cs"
               WARNING="NotDefined" OPERATOR="GT" />
    
    <Condition PUSH="TRUE" COLUMN_NAME="cpu_cs"
               WARNING="NotDefined" OPERATOR="GT" />
    </MetricColl>
  </CollectionItem>

<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>

<CollectionItem NAME="ha_rac_intrconn" UPLOAD_ON_FETCH="TRUE" CONFIG="TRUE">
    <Schedule>
      <IntervalSchedule INTERVAL = "12" TIME_UNIT = "Hr"/>
    </Schedule>
  </CollectionItem>

</CollectionItem>

<CollectionItem NAME="oracle_dbconfig" UPLOAD_ON_FETCH="TRUE" CONFIG="TRUE">
     <Schedule>
      <IntervalSchedule INTERVAL = "24" TIME_UNIT = "Hr"/>
     </Schedule>

</CollectionItem>

<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"> 
     
     
    </MetricColl>
  </CollectionItem>

<MetricColl NAME="db_bsln_adaptive_thresholds"/>
  </CollectionItem>

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

<MetricColl NAME="incident_meter"/>
  </CollectionItem>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de