Oracle KB

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

From Documentation

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.

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

State	Severity	Condition	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" \|\| $pct_free > $LOW \|\| $free_space > $next_increment
Acknowledged	normal	$autoextensible == "YES"
Delete	built-in	No data state

State	Severity	Condition	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
Acknowledged	normal
Delete	built-in	No data state

Search

Oracle KB

From Documentation

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