FS
Documentation
You are here
Search
 

Oracle KB

From Documentation

(Difference between revisions)
Jump to: navigation, search
Revision as of 06:47, 17 July 2006
Moff (Talk | contribs)
(→Informix Processes Class)
← Previous diff		 Revision as of 07:17, 17 July 2006
Moff (Talk | contribs)
(→Overview)
Next diff →
Line 346: Line 346:
!width="65" bgcolor="#cccccc" | Logging !width="65" bgcolor="#cccccc" | Logging
|- |-
-|Active_Transactions ||Informix ||Status ||60s ||align="center" | √ ||align="center" | √+|Cache_Hit_Ratio||Oracle ||Stats ||120s ||align="center" | √ ||align="center" | √
|- |-
-|Onconfig_File ||Informix ||FileInfo ||20s ||align="center" | √ ||+|Init_File ||Oracle ||FileInfo ||20s ||align="center" | √ ||
|- |-
-|Server_Info ||Informix ||infoAg ||30s ||align="center" | √ ||+|Logons ||Oracle ||Stats ||120s ||align="center" | √ ||align="center" | √
|- |-
-|Shared_Memory ||Informix ||Status ||60s ||align="center" | √ ||+|Run_Query ||Oracle ||Null ||n/a || ||
|- |-
-|Uptime ||Informix ||Status ||60s ||align="center" | √ ||+|Security_Info ||Oracle ||Security ||7200s||align="center" | √ ||
|- |-
-|Users ||Informix ||Status ||60s ||align="center" | √ ||align="center" | √+|Sessions ||Oracle ||Session ||90s ||align="center" | √ ||align="center" | √
|- |-
-|Chunks ||Chunks ||CSpace ||900s ||align="center" | √ ||+|SGA ||Oracle ||sga ||7200s||align="center" | √ ||
|- |-
-|DB_Spaces ||DBspaces ||CSpace ||900s ||align="center" | √ ||+|SID_info ||Oracle ||InfoAg ||n/a ||align="center" | √ ||
|- |-
-|Extents ||Extents ||Extnts ||300s ||align="center" | √ ||+|Spfile ||Oracle ||FileInfo ||20s ||align="center" | √ ||
|- |-
-|Mirror_Chunks ||Mirror_Chunks||CSpace ||900s ||align="center" | √ ||+|Top_10 ||Oracle ||Null ||n/a || ||
|- |-
-|Online_Log ||Online_Log ||OnLog ||n/a ||align="center" | √ ||+|Uptime ||Oracle ||Status ||120s ||align="center" | √ ||
|- |-
-|Buffers ||Performance ||Perf ||90s ||align="center" | √ ||+|Alert_Log ||AlertLog ||Alert_log ||n/a ||align="center" | √ ||
|- |-
-|CPU_States ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √+|Archive_Logs ||Archive_Logs ||ArLogs ||300s ||align="center" | √ ||align="center" | √
|- |-
-|Checkpoint_Waits ||Performance ||Perf ||90s ||align="center" | √ ||+|Control_Files ||Control_Files||FileInfo ||20s ||align="center" | √ ||
|- |-
-|Deadlocks ||Performance ||Perf ||90s ||align="center" | √ ||+|Extents ||Extents ||Extnts ||300s ||align="center" | √ ||
|- |-
-|Latch_Waits ||Performance ||Perf ||90s ||align="center" | √ ||+|File_IO ||File_IO ||File_io ||180s ||align="center" | √ ||align="center" | √
|- |-
-|Locks ||Performance ||Perf ||90s ||align="center" | √ ||+|Monitor_Locks ||Locks ||Lock ||120s ||align="center" | √ ||
|- |-
-|Over_User_Threads ||Performance ||Perf ||90s ||align="center" | √ ||+|Processes ||Processes ||Ora_Process ||75s ||align="center" | √ ||align="center" | √
|- |-
-|Read_Ahead ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √+|Datafile ||Tablespaces ||TSpace ||300s ||align="center" | √ ||
|- |-
-|Read_Chche ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √+|Tablespace ||Tablespaces ||TSpace ||300s ||align="center" | √ ||align="center" | √
-|-+
-|Sequential_Scans ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √+
-|-+
-|Write_Cache ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √+
-|-+
-|Virtual_Processor ||Processes ||virtual_proc||75s ||align="center" | √ ||+
|} |}

Revision as of 07:17, 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

Active_Transactions Sentry

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

States

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


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 Escalation
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 Escalation
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 Escalation
DOWN critical $chunk_status != "up"
ONLINE normal
Delete built-in No data state


Retrieved from "https://documentation.fs.com.au/index.php/Oracle_KB"
Home : About : Contact Us : Site Map : Terms of Use
All trademarks and registered trademarks of products mentioned in this web site are recognised by Functional Software. Site content and images © 1997-2021 Functional Software