FS
Documentation

Oracle KB

From Documentation

(Difference between revisions)
Jump to: navigation, search
Revision as of 08:31, 17 July 2006
Moff (Talk | contribs)
(Monitor_locks Sentry)
← Previous diff
Revision as of 08:34, 17 July 2006
Moff (Talk | contribs)
(File_IO Sentry)
Next diff →
Line 678: Line 678:
'''Constants''' '''Constants'''
- +{| border="1" cellpadding="6" cellspacing="0"
 +!width="150" bgcolor="#cccccc" | Constant
 +!width="500" bgcolor="#cccccc" | Description
 +!width="65" bgcolor="#cccccc" | Value
 +|-
 +|HIGH_IO ||Indicating high I/O for data file ||70
 +|}
'''States''' '''States'''
Line 698: Line 704:
<br> <br>
 +
==== Monitor_locks Sentry ==== ==== Monitor_locks Sentry ====

Revision as of 08:34, 17 July 2006

Contents

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.


Oracle Knowledge Base Version

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


Oracle Knowledge Base

Oracle Class

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


Oracle Alert Log Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
AlertLog


Oracle Archive Logs Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Archive_Logs


Oracle Control Files Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Control_Files


Oracle Extents Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Extents


Oracle File I/O Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
File_IO


Oracle Locks Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Monitor_locks


Oracle Processes Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Processes


Oracle Tablespaces Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Datafile
Tablespace


Sentry Details

Overview

Sentry Class Agent Poll Time States Logging
Cache_Hit_RatioOracle 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_FilesFileInfo 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


Sentry State Details

Cache_Hit_Ratio Sentry

Availability
AIX, HPUX, Linux, Solaris

Constants

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

States

State Severity Condition Escalation
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


Init_File Sentry

Availability
AIX, HPUX, Linux, Solaris

States

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


Logons Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled $sql_error != ""


Security_Info Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled $sql_error != ""



Sessions Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled$error_test != ""
OK normal


SGA Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled !$up
OK normal


SID_info Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled !$up
OK normal


Spfile Sentry

Availability
AIX, HPUX, Linux, Solaris

States

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


Uptime Sentry

Availability
AIX, HPUX, Linux, Solaris

Constants

Constant Description Value
SLOW_RESPONSE Indicating a SQL query response problem (ms) 5000

States

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


AlertLog Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
ERROR info Delete after acknowledgement



Archive_Logs Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled !$up
OK normal
Delete built-in No data state


Control_Files Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Not_Existalarm !$exists
OK normal


Extents Sentry

Availability
AIX, HPUX, Linux, Solaris

States

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


File_IO Sentry

Availability
AIX, HPUX, Linux, Solaris

Constants

Constant Description Value
HIGH_IO Indicating high I/O for data file 70

States

State Severity Condition Escalation
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


Monitor_locks Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled $error_text != ""
Delete built-in No data state


Processes Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Not_Running disabled $count == 0
OK normal