Oracle KB

From Documentation

(Difference between revisions)

Revision as of 07:29, 17 July 2006

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	Solaris
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_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	√	√

Sentry State Details

Cache_Hit_Ratio Sentry

Availability: AIX, HPUX, Linux, Solaris

Constants

States

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 n	normal	$bufferhit_ratio >= $GOOD_CACHING

Onconfig_File Sentry

Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64

States

State	Severity	Condition	Escalation
MODIFIED	warning	$mtime != $prev_mtime	OK after acknowledgement
DOWN	disabled	$ix_status != "Up"
DELETED	alarm	!$exists
OK	normal n

Server_Info Sentry

Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64

States

State	Severity	Condition
DOWN	alarm	$ix_status != "Up"
OFFLINE	warning	$mode == "Off-Line"
RASTRECOVERY	info	$mode == "Fast Recovery" \|\| $mode == "Fast Recovery (CKPT REQ)"
QUIESCENT	info	$mode == "Quiescent"
UP	normal

Shared_Memory Sentry

Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64

States

State	Severity	Condition	Escalation
DOWN	disabled	$ix_status != "Up"
SHARED_MEM	normal

Uptime Sentry

Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64

States

State	Severity	Condition	Escalation
DOWN	disabled	$ix_status != "Up"
UPTIME	normal

Users Sentry

Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64

Constants

Constant	Description	Value
OK_USERS	Indicating OK number of connections	790
MAX_USERS	Indicating maximum number of connections	830
HIGH_USERS	Indicating a high number of connections	930

States

State	Severity	Condition
DOWN	disabled	$ix_status != "Up"
HIGH_CLIENTS	alarm	$active_users > $HIGH_USERS
MAX_CLIENTS	alarm	$active_users > $MAX_USERS
OK_CLIENTS	normal

Chunks Sentry

Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64

Constants

Constant	Description	Value
LOW	Indicating low free chunkspace	35
VERY_LOW	Indicating very low free chunkspace	25
NEARLY_FULL	Indicating the chunkspace is nearly full	15
FULL	Indicating the chunkspace is full	0

States

State	Severity	Condition
DOWN	critical	$chunk_status != "up"
ONLINE	normal
Delete	built-in	No data state

Retrieved from "https://documentation.fs.com.au/index.php/Oracle_KB"

 === Sentry State Details ===
-==== Active_Transactions Sentry ====
+==== Cache_Hit_Ratio Sentry ====
+;Availability: AIX, HPUX, Linux, Solaris
+'''Constants'''
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64
 '''States'''
 !width="120" bgcolor="#cccccc" | Escalation
 |-
-|DOWN      ||disabled ||$ix_status != "Up" ||
+|Down         ||disabled ||$sql_error != " "                 ||
+|-
+|Poor_Caching ||warning  ||$bufferhit_ratio < $AVG_CACHING   ||
+|-
+|Low_Caching  ||info     ||$bufferhit_ratio < $GOOD_CACHING && $bufferhit_ratio >= $AVG_CACHING ||
 |-
-|OK_TRANS  ||normal   ||                   ||
+|OK n         ||normal   ||$bufferhit_ratio >= $GOOD_CACHING ||
 |}

Search

Oracle KB

From Documentation

Revision as of 07:29, 17 July 2006

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

Onconfig_File Sentry

Server_Info Sentry

Shared_Memory Sentry

Uptime Sentry

Users Sentry

Chunks Sentry