Oracle KB
From Documentation
(Difference between revisions)
| 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
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_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
| 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_Exist | alarm | !$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_Exist | alarm | !$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_Exist | alarm | !$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 |