Oracle KB
From Documentation
(Difference between revisions)
| Revision as of 06:46, 17 July 2006 Moff (Talk | contribs) (→Locks Class) ← Previous diff |
Revision as of 06:47, 17 July 2006 Moff (Talk | contribs) (→Informix Processes Class) Next diff → |
||
| Line 278: | Line 278: | ||
| <br> | <br> | ||
| - | ==== Informix Processes Class ==== | + | ==== Oracle Processes Class ==== |
| {| border="1" cellpadding="6" cellspacing="0" | {| border="1" cellpadding="6" cellspacing="0" | ||
| Line 290: | Line 290: | ||
| !width="65" | Windows | !width="65" | Windows | ||
| |- | |- | ||
| - | |Virtual_Processor | + | |Processes |
| |align="center" | √ | |align="center" | √ | ||
| |align="center" | √ | |align="center" | √ | ||
| |align="center" | √ | |align="center" | √ | ||
| + | | | ||
| + | |align="center" | √ | ||
| + | | | ||
| + | | | ||
| + | |} | ||
| + | |||
| + | <br> | ||
| + | ==== Oracle Tablespaces 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 | ||
| + | |- | ||
| + | |Datafile | ||
| |align="center" | √ | |align="center" | √ | ||
| |align="center" | √ | |align="center" | √ | ||
| |align="center" | √ | |align="center" | √ | ||
| + | | | ||
| + | |align="center" | √ | ||
| + | | | ||
| + | | | ||
| + | |- | ||
| + | |Tablespace | ||
| + | |align="center" | √ | ||
| + | |align="center" | √ | ||
| + | |align="center" | √ | ||
| + | | | ||
| + | |align="center" | √ | ||
| + | | | ||
| | | | | ||
| |} | |} | ||
| <br> | <br> | ||
| + | |||
| == Sentry Details == | == Sentry Details == | ||
Revision as of 06:47, 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 |
|---|---|---|---|---|---|
| Active_Transactions | Informix | Status | 60s | √ | √ |
| Onconfig_File | Informix | FileInfo | 20s | √ | |
| Server_Info | Informix | infoAg | 30s | √ | |
| Shared_Memory | Informix | Status | 60s | √ | |
| Uptime | Informix | Status | 60s | √ | |
| Users | Informix | Status | 60s | √ | √ |
| Chunks | Chunks | CSpace | 900s | √ | |
| DB_Spaces | DBspaces | CSpace | 900s | √ | |
| Extents | Extents | Extnts | 300s | √ | |
| Mirror_Chunks | Mirror_Chunks | CSpace | 900s | √ | |
| Online_Log | Online_Log | OnLog | n/a | √ | |
| Buffers | Performance | Perf | 90s | √ | |
| CPU_States | Performance | Perf | 90s | √ | √ |
| Checkpoint_Waits | Performance | Perf | 90s | √ | |
| Deadlocks | Performance | Perf | 90s | √ | |
| Latch_Waits | Performance | Perf | 90s | √ | |
| Locks | Performance | Perf | 90s | √ | |
| Over_User_Threads | Performance | Perf | 90s | √ | |
| Read_Ahead | Performance | Perf | 90s | √ | √ |
| Read_Chche | Performance | Perf | 90s | √ | √ |
| Sequential_Scans | Performance | Perf | 90s | √ | √ |
| Write_Cache | Performance | Perf | 90s | √ | √ |
| Virtual_Processor | Processes | virtual_proc | 75s | √ |
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 |