Oracle KB

This page was last modified 09:10, 17 July 2006.

From Documentation

(Difference between revisions)

Current revision

Overview

The primary aim of the Oracle knowledge base in Sentinel3G is to provide notification of CPU and memory hungry processes using monitoring that is consistent across various UNIX, Linux and Windows platforms. Due to differences between the various operating systems we monitor, complete consistency is not always achievable. This document describes the general content of the Process knowledge base, and the discrepancies between them on different platforms.

 <br>
-==== Informix Mirror Chunks Class ====
+==== Oracle Extents Class ====
 {| border="1" cellpadding="6" cellspacing="0"
 !width="65" | Windows
 |-
-|Mirror_Chunks
+|Extents
-|align="center" | &radic;
-|align="center" | &radic;
 |align="center" | &radic;
 |align="center" | &radic;
 |align="center" | &radic;
+|
 |align="center" | &radic;
+|
 |
 |}
 <br>
-==== Informix Online Log Class ====
+==== Oracle File I/O Class ====
 {| border="1" cellpadding="6" cellspacing="0"
 !width="65" | Windows
 |-
-|Online_Log
+|File_IO
-|align="center" | &radic;
-|align="center" | &radic;
 |align="center" | &radic;
 |align="center" | &radic;
 |align="center" | &radic;
+|
 |align="center" | &radic;
+|
 |
 |}
 <br>
-==== Informix Performance Class ====
+==== Oracle Locks Class ====
 {| border="1" cellpadding="6" cellspacing="0"
 !width="65" | Windows
 |-
-|Buffers
+|Monitor_locks
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
 |align="center" | &radic;
 |align="center" | &radic;
 |align="center" | &radic;
 |
-|-
-|CPU_States
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
 |align="center" | &radic;
 |
-|-
-|Checkpoint_Waits
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
 |
+|}
+<br>
+==== Oracle Processes Class ====
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" | Sentry
+!width="65" | AIX
+!width="65" | HPUX
+!width="65" | Linux
+!width="65" | SCO
+!width="65" | Solaris
+!width="65" | Tru64
+!width="65" | Windows
 |-
-|Deadlocks
+|Processes
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
 |align="center" | &radic;
 |align="center" | &radic;
 |align="center" | &radic;
 |
-|-
-|Latch_Waits
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
 |align="center" | &radic;
 |
-|-
-|Locks
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|
-|-
-|Over_User_Threads
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|
-|-
-|Read_Ahead
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|
-|-
-|Read_Cache
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|
-|-
-|Sequential_Scans
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|
-|-
-|Write_Cache
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
-|align="center" | &radic;
 |
 |}
 <br>
-==== Informix Processes Class ====
+==== Oracle Tablespaces Class ====
 {| border="1" cellpadding="6" cellspacing="0"
 !width="65" | Windows
 |-
-|Virtual_Processor
+|Datafile
 |align="center" | &radic;
 |align="center" | &radic;
 |align="center" | &radic;
+|
+|align="center" | &radic;
+|
+|
+|-
+|Tablespace
 |align="center" | &radic;
 |align="center" | &radic;
 |align="center" | &radic;
+|
+|align="center" | &radic;
+|
 |
 |}
 <br>
 == Sentry Details ==
 !width="65"  bgcolor="#cccccc" | Logging
 |-
-|Active_Transactions ||Informix     ||Status      ||60s  ||align="center" | &radic; ||align="center" | &radic;
+|Cache_Hit_Ratio||Oracle       ||Stats       ||120s ||align="center" | &radic; ||align="center" | &radic;
 |-
-|Onconfig_File       ||Informix     ||FileInfo    ||20s  ||align="center" | &radic; ||
+|Init_File      ||Oracle       ||FileInfo    ||20s  ||align="center" | &radic; ||
 |-
-|Server_Info         ||Informix     ||infoAg      ||30s  ||align="center" | &radic; ||
+|Logons         ||Oracle       ||Stats       ||120s ||align="center" | &radic; ||align="center" | &radic;
 |-
-|Shared_Memory       ||Informix     ||Status      ||60s  ||align="center" | &radic; ||
+|Run_Query      ||Oracle       ||Null        ||n/a  ||  ||
 |-
-|Uptime              ||Informix     ||Status      ||60s  ||align="center" | &radic; ||
+|Security_Info  ||Oracle       ||Security    ||7200s||align="center" | &radic; ||
 |-
-|Users               ||Informix     ||Status      ||60s  ||align="center" | &radic; ||align="center" | &radic;
+|Sessions       ||Oracle       ||Session     ||90s  ||align="center" | &radic; ||align="center" | &radic;
 |-
-|Chunks              ||Chunks       ||CSpace      ||900s ||align="center" | &radic; ||
+|SGA            ||Oracle       ||sga         ||7200s||align="center" | &radic; ||
 |-
-|DB_Spaces           ||DBspaces     ||CSpace      ||900s ||align="center" | &radic; ||
+|SID_info       ||Oracle       ||InfoAg      ||n/a  ||align="center" | &radic; ||
 |-
-|Extents             ||Extents      ||Extnts      ||300s ||align="center" | &radic; ||
+|Spfile         ||Oracle       ||FileInfo    ||20s  ||align="center" | &radic; ||
 |-
-|Mirror_Chunks       ||Mirror_Chunks||CSpace      ||900s ||align="center" | &radic; ||
+|Top_10         ||Oracle       ||Null        ||n/a  ||  ||
 |-
-|Online_Log          ||Online_Log   ||OnLog       ||n/a  ||align="center" | &radic; ||
+|Uptime         ||Oracle       ||Status      ||120s ||align="center" | &radic; ||
 |-
-|Buffers             ||Performance  ||Perf        ||90s  ||align="center" | &radic; ||
+|Alert_Log      ||AlertLog     ||Alert_log   ||n/a  ||align="center" | &radic; ||
 |-
-|CPU_States          ||Performance  ||Perf        ||90s  ||align="center" | &radic; ||align="center" | &radic;
+|Archive_Logs   ||Archive_Logs ||ArLogs      ||300s ||align="center" | &radic; ||align="center" | &radic;
 |-
-|Checkpoint_Waits    ||Performance  ||Perf        ||90s  ||align="center" | &radic; ||
+|Control_Files  ||Control_Files||FileInfo    ||20s  ||align="center" | &radic; ||
 |-
-|Deadlocks           ||Performance  ||Perf        ||90s  ||align="center" | &radic; ||
+|Extents        ||Extents      ||Extnts      ||300s ||align="center" | &radic; ||
 |-
-|Latch_Waits         ||Performance  ||Perf        ||90s  ||align="center" | &radic; ||
+|File_IO        ||File_IO      ||File_io     ||180s ||align="center" | &radic; ||align="center" | &radic;
 |-
-|Locks               ||Performance  ||Perf        ||90s  ||align="center" | &radic; ||
+|Monitor_locks  ||Locks        ||Lock        ||120s ||align="center" | &radic; ||
 |-
-|Over_User_Threads   ||Performance  ||Perf        ||90s  ||align="center" | &radic; ||
+|Processes      ||Processes    ||Ora_Process ||75s  ||align="center" | &radic; ||align="center" | &radic;
 |-
-|Read_Ahead          ||Performance  ||Perf        ||90s  ||align="center" | &radic; ||align="center" | &radic;
+|Datafile       ||Tablespaces  ||TSpace      ||300s ||align="center" | &radic; ||
 |-
-|Read_Chche          ||Performance  ||Perf        ||90s  ||align="center" | &radic; ||align="center" | &radic;
+|Tablespace     ||Tablespaces  ||TSpace      ||300s ||align="center" | &radic; ||align="center" | &radic;
-|-
-|Sequential_Scans    ||Performance  ||Perf        ||90s  ||align="center" | &radic; ||align="center" | &radic;
-|-
-|Write_Cache         ||Performance  ||Perf        ||90s  ||align="center" | &radic; ||align="center" | &radic;
-|-
-|Virtual_Processor   ||Processes    ||virtual_proc||75s  ||align="center" | &radic; ||
 |}
 === Sentry State Details ===
-==== Active_Transactions Sentry ====
+==== Cache_Hit_Ratio Sentry ====
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64
+;Availability: AIX, HPUX, Linux, Solaris
+'''Constants'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="150" bgcolor="#cccccc" | Constant
+!width="500" bgcolor="#cccccc" | Description
+!width="65"  bgcolor="#cccccc" | Value
+|-
+|AVG_CACHING  ||Indicating an OK buffer hit ratio  ||80
+|-
+|GOOD_CACHING ||Indicating a good buffer hit ratio ||90
+|}
 '''States'''
 !width="120" bgcolor="#cccccc" | Escalation
 |-
-|DOWN      ||disabled ||$ix_status != "Up" ||
+|Down         ||disabled ||$sql_error != " "                 ||
 |-
-|OK_TRANS  ||normal   ||                   ||
+|Poor_Caching ||warning  ||$bufferhit_ratio < $AVG_CACHING   ||
+|-
+|Low_Caching  ||info     ||$bufferhit_ratio < $GOOD_CACHING && $bufferhit_ratio >= $AVG_CACHING ||
+|-
+|OK           ||normal   ||$bufferhit_ratio >= $GOOD_CACHING ||
 |}
 <br>
-==== Onconfig_File Sentry ====
+==== Init_File Sentry ====
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64
+;Availability: AIX, HPUX, Linux, Solaris
 '''States'''
 !width="125" bgcolor="#cccccc" | State
 !width="65"  bgcolor="#cccccc" | Severity
-!width="330" bgcolor="#cccccc" | Condition
+!width="320" bgcolor="#cccccc" | Condition
-!width="180" bgcolor="#cccccc" | Escalation
+!width="190" bgcolor="#cccccc" | Escalation
 |-
 |-
-|MODIFIED ||warning  ||$mtime != $prev_mtime ||OK after acknowledgement
+|Not_Exist||alarm   ||!$exists              ||
 |-
-|DOWN     ||disabled ||$ix_status != "Up"    ||
+|Modified ||warning ||$mtime != $prev_mtime ||OK after acknowledgement
 |-
-|DELETED  ||alarm    ||!$exists              ||
+|OK       ||normal  ||                      ||
+|}
+<br>
+==== Logons Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
+'''States'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" bgcolor="#cccccc" | State
+!width="65"  bgcolor="#cccccc" | Severity
+!width="390" bgcolor="#cccccc" | Condition
+!width="120" bgcolor="#cccccc" | Escalation
 |-
-|OK       ||normal n ||                      ||
+|Down     ||disabled ||$sql_error != ""    ||
 |}
 <br>
-==== Server_Info Sentry ====
+==== Security_Info Sentry ====
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64
+;Availability: AIX, HPUX, Linux, Solaris
 '''States'''
 !width="120" bgcolor="#cccccc" | Escalation
 |-
-|DOWN         ||alarm   ||$ix_status != "Up"    ||
+|Down     ||disabled ||$sql_error != ""    ||
-|-
+|}
-|OFFLINE      ||warning ||$mode == "Off-Line"   ||
-|-
-|RASTRECOVERY ||info    ||$mode == "Fast Recovery" &#124;&#124; $mode == "Fast Recovery (CKPT REQ)" ||
+<br>
+==== Sessions Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
+'''States'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" bgcolor="#cccccc" | State
+!width="65"  bgcolor="#cccccc" | Severity
+!width="390" bgcolor="#cccccc" | Condition
+!width="120" bgcolor="#cccccc" | Escalation
 |-
-|QUIESCENT    ||info    ||$mode == "Quiescent"  ||
+|Down   ||disabled||$error_test != ""   ||
 |-
-|UP           ||normal  ||                      ||
+|OK     ||normal  ||                    ||
 |}
 <br>
-==== Shared_Memory Sentry ====
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64
+==== SGA Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
 '''States'''
 !width="120" bgcolor="#cccccc" | Escalation
 |-
-|DOWN       ||disabled||$ix_status != "Up"    ||
+|Down    ||disabled ||!$up          ||
 |-
-|SHARED_MEM ||normal  ||                      ||
+|OK      ||normal   ||              ||
 |}
 <br>
-==== Uptime Sentry ====
+==== SID_info Sentry ====
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64
+;Availability: AIX, HPUX, Linux, Solaris
 '''States'''
 !width="120" bgcolor="#cccccc" | Escalation
 |-
-|DOWN   ||disabled||$ix_status != "Up"    ||
+|Down    ||disabled ||!$up          ||
 |-
-|UPTIME ||normal  ||                      ||
+|OK      ||normal   ||              ||
 |}
 <br>
+==== Spfile Sentry ====
-==== Users Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64
+'''States'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" bgcolor="#cccccc" | State
+!width="65"  bgcolor="#cccccc" | Severity
+!width="320" bgcolor="#cccccc" | Condition
+!width="190" bgcolor="#cccccc" | Escalation
+|-
+|-
+|Not_Exist||alarm   ||!$exists              ||
+|-
+|Modified ||warning ||$mtime != $prev_mtime ||OK after acknowledgement
+|-
+|OK       ||normal  ||                      ||
+|}
+<br>
+==== Uptime Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
 '''Constants'''
 !width="65"  bgcolor="#cccccc" | Value
 |-
-|OK_USERS   ||Indicating OK number of connections      ||790
+|SLOW_RESPONSE ||Indicating a SQL query response problem (ms) ||5000
+|}
+'''States'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" bgcolor="#cccccc" | State
+!width="65"  bgcolor="#cccccc" | Severity
+!width="390" bgcolor="#cccccc" | Condition
+!width="120" bgcolor="#cccccc" | Escalation
 |-
-|MAX_USERS  ||Indicating maximum number of connections ||830
+|Slow         ||alarm    ||$query_time >= $SLOW_RESPONSE            ||
 |-
-|HIGH_USERS ||Indicating a high number of connections  ||930
+|Down         ||disabled ||!$up                                     ||
+|-
+|Wrong_Login ||info     ||[ string match "ORA-01017*" $error_text ] ||
+|-
+|OK           ||normal   ||                                         ||
 |}
+<br>
+==== AlertLog Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
+'''States'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" bgcolor="#cccccc" | State
+!width="65"  bgcolor="#cccccc" | Severity
+!width="320" bgcolor="#cccccc" | Condition
+!width="190" bgcolor="#cccccc" | Escalation
+|-
+|ERROR    ||info   ||    ||Delete after acknowledgement
+|}
+<br>
+==== Archive_Logs Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
 '''States'''
 !width="120" bgcolor="#cccccc" | Escalation
 |-
-|DOWN         ||disabled||$ix_status != "Up"          ||
+|Down    ||disabled ||!$up          ||
 |-
-|HIGH_CLIENTS ||alarm   ||$active_users > $HIGH_USERS ||
+|OK      ||normal   ||              ||
 |-
-|MAX_CLIENTS  ||alarm   ||$active_users > $MAX_USERS  ||
+|Delete  ||built-in ||No data state ||
+|}
+<br>
+==== Control_Files Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
+'''States'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" bgcolor="#cccccc" | State
+!width="65"  bgcolor="#cccccc" | Severity
+!width="320" bgcolor="#cccccc" | Condition
+!width="190" bgcolor="#cccccc" | Escalation
+|-
+|-
+|Not_Exist||alarm   ||!$exists       ||
 |-
-|OK_CLIENTS   ||normal  ||                            ||
+|OK       ||normal  ||               ||
 |}
 <br>
+==== Extents Sentry ====
-==== Chunks Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64
+'''States'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" bgcolor="#cccccc" | State
+!width="65"  bgcolor="#cccccc" | Severity
+!width="320" bgcolor="#cccccc" | Condition
+!width="190" bgcolor="#cccccc" | Escalation
+|-
+|Down         ||disabled ||$error_text != ""         ||
+|-
+|Near_Max     ||warning  ||$extents != $last_extents ||Ack_Near_Max after acknowledgement
+|-
+|Ack_Near_Max ||normal   ||$extents == $last_extents ||
+|-
+|Delete       ||built-in ||No data state             ||
+|}
+<br>
+==== File_IO Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
 '''Constants'''
 !width="65"  bgcolor="#cccccc" | Value
 |-
-|LOW         ||Indicating low free chunkspace           ||35
+|HIGH_IO ||Indicating high I/O for data file ||70
+|}
+'''States'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" bgcolor="#cccccc" | State
+!width="65"  bgcolor="#cccccc" | Severity
+!width="390" bgcolor="#cccccc" | Condition
+!width="120" bgcolor="#cccccc" | Escalation
 |-
-|VERY_LOW    ||Indicating very low free chunkspace      ||25
+|Down    ||disabled ||$query_status != "" ||
 |-
-|NEARLY_FULL ||Indicating the chunkspace is nearly full ||15
+|High_IO ||info     ||$pct_phy_read > $HIGH_IO &#124;&#124; $pct_phy_write > $HIGH_IO ||
 |-
-|FULL        ||Indicating the chunkspace is full        ||0
+|OK      ||normal   ||                    ||
+|-
+|Delete  ||built-in ||No data state       ||
 |}
+<br>
+==== Monitor_locks Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
 '''States'''
 !width="120" bgcolor="#cccccc" | Escalation
 |-
-|DOWN   ||critical ||$chunk_status != "up" ||
+|Down    ||disabled ||$error_text != "" ||
+|-
+|Delete  ||built-in ||No data state     ||
+|}
+<br>
+==== Processes Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
+'''States'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" bgcolor="#cccccc" | State
+!width="65"  bgcolor="#cccccc" | Severity
+!width="390" bgcolor="#cccccc" | Condition
+!width="120" bgcolor="#cccccc" | Escalation
+|-
+|Not_Running ||disabled ||$count == 0   ||
+|-
+|OK          ||normal   ||              ||
+|}
+<br>
+==== Datafile Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
+'''Constants'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="150" bgcolor="#cccccc" | Constant
+!width="500" bgcolor="#cccccc" | Description
+!width="65"  bgcolor="#cccccc" | Value
+|-
+|LOW   ||Indicating a low percentage of free space ||10
+|}
+'''States'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" bgcolor="#cccccc" | State
+!width="65"  bgcolor="#cccccc" | Severity
+!width="390" bgcolor="#cccccc" | Condition
+!width="120" bgcolor="#cccccc" | Escalation
+|-
+|Down         ||disabled ||$query_status != ""      ||
+|-
+|Can_Not_Grow ||critical ||$autoextensible == "YES" && $pct_free <= $LOW && $free_space <= $next_increment && [ catch { exec Oracle-utl-filesystem_check $datafile $next_increment } ] == 0 && $last_usable_sz != $usable_size || Acknowledged after acknowledgement
+|-
+|Auto_Growing ||info     ||$autoextensible == "YES" && $pct_free <= $LOW && $free_space <= $next_increment && $last_usable_sz != $usable_size ||Acknowledged after acknowledgement
+|-
+|OK           ||normal   ||$autoextensible == "NO" &#124;&#124; $pct_free > $LOW &#124;&#124; $free_space > $next_increment ||
+|-
+|Acknowledged ||normal   ||$autoextensible == "YES" ||
+|-
+|Delete       ||built-in ||No data state            ||
+|}
+<br>
+==== Tablespace Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
+'''Constants'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="150" bgcolor="#cccccc" | Constant
+!width="500" bgcolor="#cccccc" | Description
+!width="65"  bgcolor="#cccccc" | Value
+|-
+|LOW         ||Indicating a low percentage of free space      ||10
+|-
+|VERY_LOW    ||Indicating a very low percentage of free space ||5
+|-
+|NEARLY_FULL ||Indicating tablespace is nearly full           ||2
+|}
+'''States'''
+{| border="1" cellpadding="6" cellspacing="0"
+!width="125" bgcolor="#cccccc" | State
+!width="65"  bgcolor="#cccccc" | Severity
+!width="370" bgcolor="#cccccc" | Condition
+!width="140" bgcolor="#cccccc" | Escalation
+|-
+|Down         ||disabled ||$error_text != ""        ||
+|-
+|Nearly_Full  ||severe   ||$pct_free < $NEARLY_FULL && $last_free_space != $free_space ||Acknowledged after acknowledgement
+|-
+|Very_Low     ||alarm    ||$pct_free < $VERY_LOW && $last_free_space != $free_space    ||Acknowledged after acknowledgement
+|-
+|Low          ||warning  ||$pct_free < $LOW && $last_free_space != $free_space         ||Acknowledged after acknowledgement
+|-
+|OK           ||normal   ||$pct_free >= $LOW        ||
 |-
-|ONLINE ||normal   ||                      ||
+|Acknowledged ||normal   ||                         ||
 |-
-|Delete ||built-in ||No data state         ||
+|Delete       ||built-in ||No data state            ||
 |}
 <br>

Sentry	AIX	HPUX	Linux	Solaris
Cache_Hit_Ratio	√	√	√	√
Init_File	√	√	√	√
Logons	√	√	√	√
Run_Query	√	√	√	√
Security_Info	√	√	√	√
Sessions	√	√	√	√
SGA	√	√	√	√
SID_Info	√	√	√	√
Spfile	√	√	√	√
Top_10	√	√	√	√
Uptime	√	√	√	√

Sentry	Class	Agent	Poll Time	States	Logging
Cache_Hit_Ratio	Oracle	Stats	120s	√	√
Init_File	Oracle	FileInfo	20s	√
Logons	Oracle	Stats	120s	√	√
Run_Query	Oracle	Null	n/a
Security_Info	Oracle	Security	7200s	√
Sessions	Oracle	Session	90s	√	√
SGA	Oracle	sga	7200s	√
SID_info	Oracle	InfoAg	n/a	√
Spfile	Oracle	FileInfo	20s	√
Top_10	Oracle	Null	n/a
Uptime	Oracle	Status	120s	√
Alert_Log	AlertLog	Alert_log	n/a	√
Archive_Logs	Archive_Logs	ArLogs	300s	√	√
Control_Files	Control_Files	FileInfo	20s	√
Extents	Extents	Extnts	300s	√
File_IO	File_IO	File_io	180s	√	√
Monitor_locks	Locks	Lock	120s	√
Processes	Processes	Ora_Process	75s	√	√
Datafile	Tablespaces	TSpace	300s	√
Tablespace	Tablespaces	TSpace	300s	√	√

Constant	Description	Value
AVG_CACHING	Indicating an OK buffer hit ratio	80
GOOD_CACHING	Indicating a good buffer hit ratio	90

State	Severity	Condition
Down	disabled	$sql_error != " "
Poor_Caching	warning	$bufferhit_ratio < $AVG_CACHING
Low_Caching	info	$bufferhit_ratio < $GOOD_CACHING && $bufferhit_ratio >= $AVG_CACHING
OK	normal	$bufferhit_ratio >= $GOOD_CACHING

State	Severity	Condition	Escalation
Not_Exist	alarm	!$exists
Modified	warning	$mtime != $prev_mtime	OK after acknowledgement
OK	normal

State	Severity	Condition
Slow	alarm	$query_time >= $SLOW_RESPONSE
Down	disabled	!$up
Wrong_Login	info	[ string match "ORA-01017*" $error_text ]
OK	normal

State	Severity	Condition	Escalation
Down	disabled	$error_text != ""
Near_Max	warning	$extents != $last_extents	Ack_Near_Max after acknowledgement
Ack_Near_Max	normal	$extents == $last_extents
Delete	built-in	No data state

State	Severity	Condition
Down	disabled	$query_status != ""
High_IO	info	$pct_phy_read > $HIGH_IO \|\| $pct_phy_write > $HIGH_IO
OK	normal
Delete	built-in	No data state

Constant	Description	Value
LOW	Indicating a low percentage of free space	10
VERY_LOW	Indicating a very low percentage of free space	5
NEARLY_FULL	Indicating tablespace is nearly full	2

Version	Availability Date	Min Sentinel Version
2.4	28th Sep, 2005	4.4
2.3	30th Sep, 2004	4.3

Search

Oracle KB

From Documentation

Current revision

Contents

Overview

Oracle Knowledge Base Version

Oracle Knowledge Base

Oracle Class

Oracle Alert Log Class

Oracle Archive Logs Class

Oracle Control Files Class

Oracle Extents Class

Oracle File I/O Class

Oracle Locks Class

Oracle Processes Class

Oracle Tablespaces Class

Sentry Details

Overview

Sentry State Details

Cache_Hit_Ratio Sentry

Init_File Sentry

Logons Sentry

Security_Info Sentry

Sessions Sentry

SGA Sentry

SID_info Sentry

Spfile Sentry

Uptime Sentry

AlertLog Sentry

Archive_Logs Sentry

Control_Files Sentry

Extents Sentry

File_IO Sentry

Monitor_locks Sentry

Processes Sentry

Datafile Sentry

Tablespace Sentry