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\database.xmlp

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

<Condition COLUMN_NAME="bytesFree"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LE"
                 MESSAGE="Tablespace [%name%] has [%value% mbytes] free"
                 MESSAGE_NLSID="problemTbsp_bytesFree_alertmessage" />

</MetricColl>
  </CollectionItem>

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

<CollectionItem NAME="problemTbsp_10i_Dct">
    <ValidIf>
       <CategoryProp NAME="VersionCategory" CHOICES="10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="30" TIME_UNIT="Min"/>
    </Schedule>

</MetricColl>
  </CollectionItem>

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

<Condition COLUMN_NAME="segsChunkSmlCnt"
               WARNING="0" OPERATOR="GT"
               MESSAGE="%value% segments in %name% tablespace unable to extend."
               MESSAGE_NLSID="problemSegTbsp_segsChunkSmlCnt_alertmessage" />

<Condition COLUMN_NAME="segsMaxExtsCnt"
               WARNING="0" OPERATOR="GT"
               MESSAGE="%value% segments in %name% tablespace approaching max extents."
               MESSAGE_NLSID="problemSegTbsp_segsMaxExtsCnt_alertmessage" />
  </CollectionItem>

<CollectionItem NAME="oracle_storage" UPLOAD_ON_FETCH="TRUE" CONFIG="TRUE">

</CollectionItem>

<CollectionItem NAME="activity_pending" UPLOAD="NO">
    <Schedule>
      <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>

<MetricColl NAME="suspended_session">

<Condition COLUMN_NAME="count"
                 WARNING="0" OPERATOR="GT"
                 MESSAGE="%value% session(s) are suspended."
                 MESSAGE_NLSID="suspended_session_count_alertmessage" />

</MetricColl>

<MetricColl NAME="DeferredTrans">

<Condition COLUMN_NAME="errortrans_count"
                 WARNING="0" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="Number of deferred transactions with errors is %value%."
                 MESSAGE_NLSID="DeferredTrans_errortrans_count_alertmessage"/>

<Condition COLUMN_NAME="deftrans_count"
                 WARNING="100" OPERATOR="GT"
                 OCCURRENCES="3"
                 MESSAGE="Number of deferred transactions is %value%."
                 MESSAGE_NLSID="DeferredTrans_deftrans_count_alertmessage"/>

</MetricColl>
  </CollectionItem>

<CollectionItem NAME="Recovery_Area">

</CollectionItem>

<CollectionItem NAME="invalid_objects_rollup" UPLOAD="NO">
    <Schedule>
      <IntervalSchedule INTERVAL="24" TIME_UNIT="Hr"/>
    </Schedule>

<MetricColl NAME="invalid_objects">

<Condition COLUMN_NAME="count"
                 WARNING="2" OPERATOR="GT"
                 MESSAGE="%value% object(s) are invalid in the %owner% schema."
                 MESSAGE_NLSID="invalid_objects_count_alertmessage" />
    </MetricColl>

<MetricColl NAME="all_invalid_objects">

<Condition COLUMN_NAME="total_count"
                 CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="GT"
                 MESSAGE="%value% object(s) are invalid in the database."
                 MESSAGE_NLSID="all_invalid_objects_total_count_alertmessage" />
    </MetricColl>
  </CollectionItem>

<CollectionItem NAME="dbjob_status" UPLOAD="NO">
    <Schedule>
      <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
    </Schedule>

<Condition COLUMN_NAME="broken"
               WARNING="0" OPERATOR="GT"
               MESSAGE="%value% job(s) are broken."
               MESSAGE_NLSID="dbjob_status_broken_alertmessage" />

<Condition COLUMN_NAME="failed"
               WARNING="0" OPERATOR="GT"
               MESSAGE="%value% job(s) have failed."
               MESSAGE_NLSID="dbjob_status_failed_alertmessage" />
  </CollectionItem>

<CollectionItem NAME="tbspAllocation">
    <ValidIf>
     	<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2;10gR1;10gR2;10gR203;11gR1;11gR2"/>
    </ValidIf>

<CollectionItem
    NAME="feature_usage_collection_item">

</CollectionItem>

<CollectionItem NAME="StgPerf" UPLOAD_ON_FETCH="TRUE" >
    <Schedule>
      <IntervalSchedule INTERVAL="3" TIME_UNIT="Day"/>
    </Schedule>

<MetricColl NAME="wastedSpace">
      <ItemProperty NAME="tsNames">;</ItemProperty>
      <ItemProperty NAME="schemas">;</ItemProperty>
      <ItemProperty NAME="wasteMinValue">50</ItemProperty>
      <ItemProperty NAME="rcMinValue">10</ItemProperty>
      <ItemProperty NAME="ckWasteSpc">false</ItemProperty>
      <ItemProperty NAME="ckRowChain">false</ItemProperty>
      <ItemProperty NAME="minSegSize">-1</ItemProperty>
    </MetricColl>
    <MetricColl NAME="recSettingsPurge">
      <ItemProperty NAME="metricName">wastedSpace</ItemProperty>
    </MetricColl>

</CollectionItem>

<CollectionItem NAME = "oracle_security" UPLOAD_ON_FETCH = "TRUE" CONFIG = "TRUE">
     <ValidIf>
	<CategoryProp NAME="VersionCategory" CHOICES="8iR2;9i;9iR2;10gR1;10gR2;10gR203;11gR1;11gR2"/>
     </ValidIf>
     <Schedule OFFSET_TYPE="INCREMENTAL">
        <IntervalSchedule INTERVAL = "24" TIME_UNIT = "Hr"/>
     </Schedule>

<MetricColl NAME="privsWithAdminOption" />
     <MetricColl NAME="privsWithGrantOption" />
     <MetricColl NAME="exemptAccessPolicy" />
     <MetricColl NAME="dbaRole" />
     <MetricColl NAME="createPrivileges" />
     <MetricColl NAME="catalogRole" />
     <MetricColl NAME="becomeUserPriv" />
     <MetricColl NAME="auditSystemPriv" />
     <MetricColl NAME="anyDictionaryPriv" />
     <MetricColl NAME="directPrivileges" />
     <MetricColl NAME="sysPublicPackage" />
     <MetricColl NAME="connectRole" />
     <MetricColl NAME="allPrivileges" />
     <MetricColl NAME="anyPrivileges" />
     <MetricColl NAME="powerPrivileges" />
	 <MetricColl NAME="dbaGroupAssign" />
     <MetricColl NAME="tableSpaceOwners" />
     <MetricColl NAME="publicPermissions" />

</MetricColl>

</CollectionItem>

<CollectionItem NAME="textIndexStats">
    <Schedule>
      <IntervalSchedule INTERVAL="8" TIME_UNIT="Min"/>
    </Schedule>
    <MetricColl NAME="textIndexStats">
     <Filter COLUMN_NAME="INDEX_NAME" OPERATOR="NE">dummy</Filter>
    </MetricColl>
  </CollectionItem>

</MetricColl>

</MetricColl>

</CollectionItem>

</CollectionItem>

<CollectionItem NAME="streams_statistics">
     <Schedule>
      <IntervalSchedule INTERVAL = "5" TIME_UNIT = "Min"/>
     </Schedule>
     <MetricColl NAME="capture_message"/>
     <MetricColl NAME="capture_queue">
	<Condition COLUMN_NAME="capture_queue_perc_spilled_msgs"
		CRITICAL="80"  WARNING="60" 
		OPERATOR="GT" OCCURRENCES="1"
		MESSAGE="Spilled messages for Capture process %CAPTURE_NAME% queue is %value% percent."
		MESSAGE_NLSID="alert_capture_queue_perc_spilled_msgs"  />
     </MetricColl>
     <MetricColl NAME="propagation_sender_stats"/>
     <MetricColl NAME="apply_errors"></MetricColl>
     <MetricColl NAME="apply_queue_buffq">
        <Condition COLUMN_NAME="apply_queue_perc_spilled_msgs"
		CRITICAL="80"  WARNING="60" 
		OPERATOR="GT" OCCURRENCES="1"
		MESSAGE="Spilled messages for Apply process [%APPLY_NAME%] queue is %value% percent."
		MESSAGE_NLSID="alert_apply_queue_perc_spilled_msgs"  />
	</MetricColl>
     <MetricColl NAME="apply_reader">
		<Condition COLUMN_NAME="MESSAGES_SPILL_RATE"
			WARNING="NotDefined" 
			OPERATOR="GT" OCCURRENCES="1"
			MESSAGE="Total number of spilled messages for Apply Process [%APPLY_NAME%] is %value% ."
			MESSAGE_NLSID="alert_apply_reader_total_spilled"  />
     </MetricColl>
     <MetricColl NAME="apply_coord"/>
     <MetricColl NAME="streams_latency_throughput">
         <Condition COLUMN_NAME="streams_latency"
               CRITICAL="900" WARNING="300" OPERATOR="GT"
               MESSAGE="Latency for Streams %streams_process_type% Process %streams_process_name% is %value% seconds."
               MESSAGE_NLSID="streams_latency_alertmessage"
               CLEAR_MESSAGE="CLEARED - Latency for Streams %streams_process_type% Process %streams_process_name% is %value% seconds."
               CLEAR_MESSAGE_NLSID="streams_latency_alertmessage_clear" />
         <Condition COLUMN_NAME="streams_throughput"
               CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="LT"
               MESSAGE="Throughtput for Streams %streams_process_type% Process %streams_process_name% is %value% messages/sec."
               MESSAGE_NLSID="streams_throughput_alertmessage"
               CLEAR_MESSAGE="CLEARED - Throughtput for Streams %streams_process_type% Process %streams_process_name% is %value% messages/sec."
               CLEAR_MESSAGE_NLSID="streams_throughput_alertmessage_clear" />
     </MetricColl>
     <MetricColl NAME="streams_processes_status">
	<Condition COLUMN_NAME="streams_process_status"
                CRITICAL="ABORTED"  WARNING="DISABLED"
                OPERATOR="EQ" OCCURRENCES="1"
                MESSAGE="Status for Streams process %streams_process_name%  is %streams_process_status%."
                MESSAGE_NLSID="alert_streams_process_status"  />
	<Condition COLUMN_NAME="streams_process_errors"
                WARNING="0" OPERATOR="GT"
                OCCURRENCES="1"
                MESSAGE="Streams component %streams_process_name% has %value% errors."
                MESSAGE_NLSID="alert_streams_process_errors"  />
     </MetricColl>
  </CollectionItem>

<CollectionItem NAME="key_profiles_collection" UPLOAD_ON_FETCH = "TRUE">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR2"/>
      <CategoryProp NAME="MetricScope" CHOICES="DB"/>
    </ValidIf>
    <Schedule>
      <IntervalSchedule INTERVAL="60" TIME_UNIT="Min"/>
    </Schedule>
  <MetricColl NAME="key_profiles"/>
  </CollectionItem>

<CollectionItem NAME="db_replay">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR2"/>
    </ValidIf>

<MetricColl NAME="wrc_client"/>
  </CollectionItem>
  
  <CollectionItem NAME="cluster_resource_name" UPLOAD_ON_FETCH="TRUE" >

</CollectionItem>

<CollectionItem NAME="isHasManaged" UPLOAD_ON_FETCH="TRUE" >

</CollectionItem>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de