FS
Documentation
You are here
Search
 

Oracle KB

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

From Documentation

(Difference between revisions)
Jump to: navigation, search
Revision as of 05:10, 17 July 2006
Moff (Talk | contribs)
(→Oracle Class)
← Previous diff		 Current revision
Moff (Talk | contribs)
(→File_IO Sentry)
Line 134: Line 134:
<br> <br>
-==== Informix Chunks Class ====+==== Oracle Alert Log Class ====
{| border="1" cellpadding="6" cellspacing="0" {| border="1" cellpadding="6" cellspacing="0"
Line 146: Line 146:
!width="65" | Windows !width="65" | Windows
|- |-
-|Chunks+|AlertLog
-|align="center" | &radic;+
-|align="center" | &radic;+
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
 +|
|align="center" | &radic; |align="center" | &radic;
 +|
| |
|} |}
<br> <br>
-==== Informix DBspaces Class ====+ 
 +==== Oracle Archive Logs Class ====
{| border="1" cellpadding="6" cellspacing="0" {| border="1" cellpadding="6" cellspacing="0"
Line 169: Line 170:
!width="65" | Windows !width="65" | Windows
|- |-
-|DB_Spaces+|Archive_Logs
-|align="center" | &radic;+
-|align="center" | &radic;+
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
 +|
|align="center" | &radic; |align="center" | &radic;
 +|
| |
|} |}
<br> <br>
-==== Informix Extents Class ====+ 
 +==== Oracle Control Files Class ====
{| border="1" cellpadding="6" cellspacing="0" {| border="1" cellpadding="6" cellspacing="0"
Line 192: Line 194:
!width="65" | Windows !width="65" | Windows
|- |-
-|Extents+|Control_Files
-|align="center" | &radic;+
-|align="center" | &radic;+
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
 +|
|align="center" | &radic; |align="center" | &radic;
 +|
| |
|} |}
<br> <br>
-==== Informix Mirror Chunks Class ====+ 
 +==== Oracle Extents Class ====
{| border="1" cellpadding="6" cellspacing="0" {| border="1" cellpadding="6" cellspacing="0"
Line 215: Line 218:
!width="65" | Windows !width="65" | Windows
|- |-
-|Mirror_Chunks+|Extents
-|align="center" | &radic;+
-|align="center" | &radic;+
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
 +|
|align="center" | &radic; |align="center" | &radic;
 +|
| |
|} |}
<br> <br>
-==== Informix Online Log Class ====+ 
 +==== Oracle File I/O Class ====
{| border="1" cellpadding="6" cellspacing="0" {| border="1" cellpadding="6" cellspacing="0"
Line 238: Line 242:
!width="65" | Windows !width="65" | Windows
|- |-
-|Online_Log+|File_IO
-|align="center" | &radic;+
-|align="center" | &radic;+
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
 +|
|align="center" | &radic; |align="center" | &radic;
 +|
| |
|} |}
<br> <br>
-==== Informix Performance Class ====+ 
 +==== Oracle Locks Class ====
{| border="1" cellpadding="6" cellspacing="0" {| border="1" cellpadding="6" cellspacing="0"
Line 261: Line 266:
!width="65" | Windows !width="65" | Windows
|- |-
-|Buffers+|Monitor_locks
-|align="center" | &radic;+
-|align="center" | &radic;+
-|align="center" | &radic;+
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
| |
-|- 
-|CPU_States 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
|align="center" | &radic; |align="center" | &radic;
| |
-|- 
-|Checkpoint_Waits 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
| |
 +|}
 +
 +<br>
 +
 +==== Oracle Processes 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
|- |-
-|Deadlocks+|Processes
-|align="center" | &radic;+
-|align="center" | &radic;+
-|align="center" | &radic;+
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
| |
-|- 
-|Latch_Waits 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
|align="center" | &radic; |align="center" | &radic;
| |
-|- 
-|Locks 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-| 
-|- 
-|Over_User_Threads 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-| 
-|- 
-|Read_Ahead 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-| 
-|- 
-|Read_Cache 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-| 
-|- 
-|Sequential_Scans 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-| 
-|- 
-|Write_Cache 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
-|align="center" | &radic; 
| |
|} |}
<br> <br>
-==== Informix Processes Class ====+==== Oracle Tablespaces Class ====
{| border="1" cellpadding="6" cellspacing="0" {| border="1" cellpadding="6" cellspacing="0"
Line 374: Line 313:
!width="65" | Windows !width="65" | Windows
|- |-
-|Virtual_Processor+|Datafile
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
 +|
 +|align="center" | &radic;
 +|
 +|
 +|-
 +|Tablespace
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
|align="center" | &radic; |align="center" | &radic;
 +|
 +|align="center" | &radic;
 +|
| |
|} |}
<br> <br>
 +
== Sentry Details == == Sentry Details ==
Line 397: Line 346:
!width="65" bgcolor="#cccccc" | Logging !width="65" bgcolor="#cccccc" | Logging
|- |-
-|Active_Transactions ||Informix ||Status ||60s ||align="center" | &radic; ||align="center" | &radic;+|Cache_Hit_Ratio||Oracle ||Stats ||120s ||align="center" | &radic; ||align="center" | &radic;
|- |-
-|Onconfig_File ||Informix ||FileInfo ||20s ||align="center" | &radic; ||+|Init_File ||Oracle ||FileInfo ||20s ||align="center" | &radic; ||
|- |-
-|Server_Info ||Informix ||infoAg ||30s ||align="center" | &radic; ||+|Logons ||Oracle ||Stats ||120s ||align="center" | &radic; ||align="center" | &radic;
|- |-
-|Shared_Memory ||Informix ||Status ||60s ||align="center" | &radic; ||+|Run_Query ||Oracle ||Null ||n/a || ||
|- |-
-|Uptime ||Informix ||Status ||60s ||align="center" | &radic; ||+|Security_Info ||Oracle ||Security ||7200s||align="center" | &radic; ||
|- |-
-|Users ||Informix ||Status ||60s ||align="center" | &radic; ||align="center" | &radic;+|Sessions ||Oracle ||Session ||90s ||align="center" | &radic; ||align="center" | &radic;
|- |-
-|Chunks ||Chunks ||CSpace ||900s ||align="center" | &radic; ||+|SGA ||Oracle ||sga ||7200s||align="center" | &radic; ||
|- |-
-|DB_Spaces ||DBspaces ||CSpace ||900s ||align="center" | &radic; ||+|SID_info ||Oracle ||InfoAg ||n/a ||align="center" | &radic; ||
|- |-
-|Extents ||Extents ||Extnts ||300s ||align="center" | &radic; ||+|Spfile ||Oracle ||FileInfo ||20s ||align="center" | &radic; ||
|- |-
-|Mirror_Chunks ||Mirror_Chunks||CSpace ||900s ||align="center" | &radic; ||+|Top_10 ||Oracle ||Null ||n/a || ||
|- |-
-|Online_Log ||Online_Log ||OnLog ||n/a ||align="center" | &radic; ||+|Uptime ||Oracle ||Status ||120s ||align="center" | &radic; ||
|- |-
-|Buffers ||Performance ||Perf ||90s ||align="center" | &radic; ||+|Alert_Log ||AlertLog ||Alert_log ||n/a ||align="center" | &radic; ||
|- |-
-|CPU_States ||Performance ||Perf ||90s ||align="center" | &radic; ||align="center" | &radic;+|Archive_Logs ||Archive_Logs ||ArLogs ||300s ||align="center" | &radic; ||align="center" | &radic;
|- |-
-|Checkpoint_Waits ||Performance ||Perf ||90s ||align="center" | &radic; ||+|Control_Files ||Control_Files||FileInfo ||20s ||align="center" | &radic; ||
|- |-
-|Deadlocks ||Performance ||Perf ||90s ||align="center" | &radic; ||+|Extents ||Extents ||Extnts ||300s ||align="center" | &radic; ||
|- |-
-|Latch_Waits ||Performance ||Perf ||90s ||align="center" | &radic; ||+|File_IO ||File_IO ||File_io ||180s ||align="center" | &radic; ||align="center" | &radic;
|- |-
-|Locks ||Performance ||Perf ||90s ||align="center" | &radic; ||+|Monitor_locks ||Locks ||Lock ||120s ||align="center" | &radic; ||
|- |-
-|Over_User_Threads ||Performance ||Perf ||90s ||align="center" | &radic; ||+|Processes ||Processes ||Ora_Process ||75s ||align="center" | &radic; ||align="center" | &radic;
|- |-
-|Read_Ahead ||Performance ||Perf ||90s ||align="center" | &radic; ||align="center" | &radic;+|Datafile ||Tablespaces ||TSpace ||300s ||align="center" | &radic; ||
|- |-
-|Read_Chche ||Performance ||Perf ||90s ||align="center" | &radic; ||align="center" | &radic;+|Tablespace ||Tablespaces ||TSpace ||300s ||align="center" | &radic; ||align="center" | &radic;
-|-+
-|Sequential_Scans ||Performance ||Perf ||90s ||align="center" | &radic; ||align="center" | &radic;+
-|-+
-|Write_Cache ||Performance ||Perf ||90s ||align="center" | &radic; ||align="center" | &radic;+
-|-+
-|Virtual_Processor ||Processes ||virtual_proc||75s ||align="center" | &radic; ||+
|} |}
Line 448: Line 391:
=== Sentry State Details === === Sentry State Details ===
-==== Active_Transactions Sentry ====+==== Cache_Hit_Ratio Sentry ====
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64+;Availability: AIX, HPUX, Linux, Solaris
 + 
 +'''Constants'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="150" bgcolor="#cccccc" | Constant
 +!width="500" bgcolor="#cccccc" | Description
 +!width="65" bgcolor="#cccccc" | Value
 +|-
 +|AVG_CACHING ||Indicating an OK buffer hit ratio ||80
 +|-
 +|GOOD_CACHING ||Indicating a good buffer hit ratio ||90
 +|}
'''States''' '''States'''
Line 460: Line 415:
!width="120" bgcolor="#cccccc" | Escalation !width="120" bgcolor="#cccccc" | Escalation
|- |-
-|DOWN ||disabled ||$ix_status != "Up" ||+|Down ||disabled ||$sql_error != " " ||
|- |-
-|OK_TRANS ||normal || ||+|Poor_Caching ||warning ||$bufferhit_ratio < $AVG_CACHING ||
 +|-
 +|Low_Caching ||info ||$bufferhit_ratio < $GOOD_CACHING && $bufferhit_ratio >= $AVG_CACHING ||
 +|-
 +|OK ||normal ||$bufferhit_ratio >= $GOOD_CACHING ||
|} |}
<br> <br>
-==== Onconfig_File Sentry ====+==== Init_File Sentry ====
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64+;Availability: AIX, HPUX, Linux, Solaris
'''States''' '''States'''
Line 476: Line 435:
!width="125" bgcolor="#cccccc" | State !width="125" bgcolor="#cccccc" | State
!width="65" bgcolor="#cccccc" | Severity !width="65" bgcolor="#cccccc" | Severity
-!width="330" bgcolor="#cccccc" | Condition+!width="320" bgcolor="#cccccc" | Condition
-!width="180" bgcolor="#cccccc" | Escalation+!width="190" bgcolor="#cccccc" | Escalation
|- |-
|- |-
-|MODIFIED ||warning ||$mtime != $prev_mtime ||OK after acknowledgement+|Not_Exist||alarm ||!$exists ||
|- |-
-|DOWN ||disabled ||$ix_status != "Up" ||+|Modified ||warning ||$mtime != $prev_mtime ||OK after acknowledgement
|- |-
-|DELETED ||alarm ||!$exists ||+|OK ||normal || ||
 +|}
 + 
 +<br>
 + 
 +==== Logons Sentry ====
 + 
 +;Availability: AIX, HPUX, Linux, Solaris
 + 
 +'''States'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="125" bgcolor="#cccccc" | State
 +!width="65" bgcolor="#cccccc" | Severity
 +!width="390" bgcolor="#cccccc" | Condition
 +!width="120" bgcolor="#cccccc" | Escalation
|- |-
-|OK ||normal n || ||+|Down ||disabled ||$sql_error != "" ||
|} |}
<br> <br>
-==== Server_Info Sentry ====+==== Security_Info Sentry ====
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64+;Availability: AIX, HPUX, Linux, Solaris
'''States''' '''States'''
Line 503: Line 477:
!width="120" bgcolor="#cccccc" | Escalation !width="120" bgcolor="#cccccc" | Escalation
|- |-
-|DOWN ||alarm ||$ix_status != "Up" ||+|Down ||disabled ||$sql_error != "" ||
-|-+|}
-|OFFLINE ||warning ||$mode == "Off-Line" ||+ 
-|-+ 
-|RASTRECOVERY ||info ||$mode == "Fast Recovery" &#124;&#124; $mode == "Fast Recovery (CKPT REQ)" ||+<br>
 + 
 +==== Sessions Sentry ====
 + 
 +;Availability: AIX, HPUX, Linux, Solaris
 + 
 +'''States'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="125" bgcolor="#cccccc" | State
 +!width="65" bgcolor="#cccccc" | Severity
 +!width="390" bgcolor="#cccccc" | Condition
 +!width="120" bgcolor="#cccccc" | Escalation
|- |-
-|QUIESCENT ||info ||$mode == "Quiescent" ||+|Down ||disabled||$error_test != "" ||
|- |-
-|UP ||normal || ||+|OK ||normal || ||
|} |}
<br> <br>
-==== Shared_Memory Sentry ==== 
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64+==== SGA Sentry ====
 + 
 +;Availability: AIX, HPUX, Linux, Solaris
'''States''' '''States'''
Line 527: Line 514:
!width="120" bgcolor="#cccccc" | Escalation !width="120" bgcolor="#cccccc" | Escalation
|- |-
-|DOWN ||disabled||$ix_status != "Up" ||+|Down ||disabled ||!$up ||
|- |-
-|SHARED_MEM ||normal || ||+|OK ||normal || ||
|} |}
<br> <br>
-==== Uptime Sentry ====+==== SID_info Sentry ====
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64+;Availability: AIX, HPUX, Linux, Solaris
'''States''' '''States'''
Line 546: Line 533:
!width="120" bgcolor="#cccccc" | Escalation !width="120" bgcolor="#cccccc" | Escalation
|- |-
-|DOWN ||disabled||$ix_status != "Up" ||+|Down ||disabled ||!$up ||
|- |-
-|UPTIME ||normal || ||+|OK ||normal || ||
|} |}
<br> <br>
 +==== Spfile Sentry ====
-==== Users Sentry ====+;Availability: AIX, HPUX, Linux, Solaris
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64+'''States'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="125" bgcolor="#cccccc" | State
 +!width="65" bgcolor="#cccccc" | Severity
 +!width="320" bgcolor="#cccccc" | Condition
 +!width="190" bgcolor="#cccccc" | Escalation
 +|-
 +|-
 +|Not_Exist||alarm ||!$exists ||
 +|-
 +|Modified ||warning ||$mtime != $prev_mtime ||OK after acknowledgement
 +|-
 +|OK ||normal || ||
 +|}
 + 
 +<br>
 + 
 +==== Uptime Sentry ====
 + 
 +;Availability: AIX, HPUX, Linux, Solaris
'''Constants''' '''Constants'''
Line 564: Line 572:
!width="65" bgcolor="#cccccc" | Value !width="65" bgcolor="#cccccc" | Value
|- |-
-|OK_USERS ||Indicating OK number of connections ||790+|SLOW_RESPONSE ||Indicating a SQL query response problem (ms) ||5000
 +|}
 + 
 +'''States'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="125" bgcolor="#cccccc" | State
 +!width="65" bgcolor="#cccccc" | Severity
 +!width="390" bgcolor="#cccccc" | Condition
 +!width="120" bgcolor="#cccccc" | Escalation
|- |-
-|MAX_USERS ||Indicating maximum number of connections ||830+|Slow ||alarm ||$query_time >= $SLOW_RESPONSE ||
|- |-
-|HIGH_USERS ||Indicating a high number of connections ||930+|Down ||disabled ||!$up ||
 + 
 +|-
 +|Wrong_Login ||info ||[ string match "ORA-01017*" $error_text ] ||
 +|-
 +|OK ||normal || ||
|} |}
 +
 +<br>
 +==== AlertLog Sentry ====
 +
 +;Availability: AIX, HPUX, Linux, Solaris
 +
 +'''States'''
 +
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="125" bgcolor="#cccccc" | State
 +!width="65" bgcolor="#cccccc" | Severity
 +!width="320" bgcolor="#cccccc" | Condition
 +!width="190" bgcolor="#cccccc" | Escalation
 +|-
 +|ERROR ||info || ||Delete after acknowledgement
 +|}
 +
 +
 +<br>
 +==== Archive_Logs Sentry ====
 +
 +;Availability: AIX, HPUX, Linux, Solaris
'''States''' '''States'''
Line 579: Line 623:
!width="120" bgcolor="#cccccc" | Escalation !width="120" bgcolor="#cccccc" | Escalation
|- |-
-|DOWN ||disabled||$ix_status != "Up" ||+|Down ||disabled ||!$up ||
|- |-
-|HIGH_CLIENTS ||alarm ||$active_users > $HIGH_USERS ||+|OK ||normal || ||
|- |-
-|MAX_CLIENTS ||alarm ||$active_users > $MAX_USERS ||+|Delete ||built-in ||No data state ||
 +|}
 + 
 +<br>
 +==== Control_Files Sentry ====
 + 
 +;Availability: AIX, HPUX, Linux, Solaris
 + 
 +'''States'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="125" bgcolor="#cccccc" | State
 +!width="65" bgcolor="#cccccc" | Severity
 +!width="320" bgcolor="#cccccc" | Condition
 +!width="190" bgcolor="#cccccc" | Escalation
 +|-
 +|-
 +|Not_Exist||alarm ||!$exists ||
|- |-
-|OK_CLIENTS ||normal || ||+|OK ||normal || ||
|} |}
<br> <br>
 +==== Extents Sentry ====
-==== Chunks Sentry ====+;Availability: AIX, HPUX, Linux, Solaris
-;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64+'''States'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="125" bgcolor="#cccccc" | State
 +!width="65" bgcolor="#cccccc" | Severity
 +!width="320" bgcolor="#cccccc" | Condition
 +!width="190" bgcolor="#cccccc" | 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 ||
 +|}
 + 
 +<br>
 +==== File_IO Sentry ====
 + 
 +;Availability: AIX, HPUX, Linux, Solaris
'''Constants''' '''Constants'''
Line 601: Line 683:
!width="65" bgcolor="#cccccc" | Value !width="65" bgcolor="#cccccc" | Value
|- |-
-|LOW ||Indicating low free chunkspace ||35+|HIGH_IO ||Indicating high I/O for data file ||70
 +|}
 + 
 +'''States'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="125" bgcolor="#cccccc" | State
 +!width="65" bgcolor="#cccccc" | Severity
 +!width="390" bgcolor="#cccccc" | Condition
 +!width="120" bgcolor="#cccccc" | Escalation
|- |-
-|VERY_LOW ||Indicating very low free chunkspace ||25+|Down ||disabled ||$query_status != "" ||
|- |-
-|NEARLY_FULL ||Indicating the chunkspace is nearly full ||15+|High_IO ||info ||$pct_phy_read > $HIGH_IO &#124;&#124; $pct_phy_write > $HIGH_IO ||
|- |-
-|FULL ||Indicating the chunkspace is full ||0+|OK ||normal || ||
 +|-
 +|Delete ||built-in ||No data state ||
|} |}
 +
 +<br>
 +
 +==== Monitor_locks Sentry ====
 +
 +;Availability: AIX, HPUX, Linux, Solaris
'''States''' '''States'''
Line 618: Line 717:
!width="120" bgcolor="#cccccc" | Escalation !width="120" bgcolor="#cccccc" | Escalation
|- |-
-|DOWN ||critical ||$chunk_status != "up" ||+|Down ||disabled ||$error_text != "" ||
 +|-
 +|Delete ||built-in ||No data state ||
 +|}
 + 
 +<br>
 +==== Processes Sentry ====
 + 
 +;Availability: AIX, HPUX, Linux, Solaris
 + 
 +'''States'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="125" bgcolor="#cccccc" | State
 +!width="65" bgcolor="#cccccc" | Severity
 +!width="390" bgcolor="#cccccc" | Condition
 +!width="120" bgcolor="#cccccc" | Escalation
 +|-
 +|Not_Running ||disabled ||$count == 0 ||
 +|-
 +|OK ||normal || ||
 +|}
 + 
 +<br>
 +==== Datafile Sentry ====
 + 
 +;Availability: AIX, HPUX, Linux, Solaris
 + 
 +'''Constants'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="150" bgcolor="#cccccc" | Constant
 +!width="500" bgcolor="#cccccc" | Description
 +!width="65" bgcolor="#cccccc" | Value
 +|-
 +|LOW ||Indicating a low percentage of free space ||10
 +|}
 + 
 +'''States'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="125" bgcolor="#cccccc" | State
 +!width="65" bgcolor="#cccccc" | Severity
 +!width="390" bgcolor="#cccccc" | Condition
 +!width="120" bgcolor="#cccccc" | 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" &#124;&#124; $pct_free > $LOW &#124;&#124; $free_space > $next_increment ||
 +|-
 +|Acknowledged ||normal ||$autoextensible == "YES" ||
 +|-
 +|Delete ||built-in ||No data state ||
 +|}
 + 
 +<br>
 +==== Tablespace Sentry ====
 + 
 +;Availability: AIX, HPUX, Linux, Solaris
 + 
 +'''Constants'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="150" bgcolor="#cccccc" | Constant
 +!width="500" bgcolor="#cccccc" | Description
 +!width="65" bgcolor="#cccccc" | 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
 +|}
 + 
 +'''States'''
 + 
 +{| border="1" cellpadding="6" cellspacing="0"
 +!width="125" bgcolor="#cccccc" | State
 +!width="65" bgcolor="#cccccc" | Severity
 +!width="370" bgcolor="#cccccc" | Condition
 +!width="140" bgcolor="#cccccc" | 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 ||
|- |-
-|ONLINE ||normal || ||+|Acknowledged ||normal || ||
|- |-
-|Delete ||built-in ||No data state ||+|Delete ||built-in ||No data state ||
|} |}
<br> <br>

Current revision

Contents

[edit]

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.


[edit]

Oracle Knowledge Base Version

Version Availability Date Min Sentinel
Version
2.4 28th Sep, 2005 4.4
2.3 30th Sep, 2004 4.3


[edit]

Oracle Knowledge Base

[edit]

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


[edit]

Oracle Alert Log Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
AlertLog √ √ √ √


[edit]

Oracle Archive Logs Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Archive_Logs √ √ √ √


[edit]

Oracle Control Files Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Control_Files √ √ √ √


[edit]

Oracle Extents Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Extents √ √ √ √


[edit]

Oracle File I/O Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
File_IO √ √ √ √


[edit]

Oracle Locks Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Monitor_locks √ √ √ √


[edit]

Oracle Processes Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Processes √ √ √ √


[edit]

Oracle Tablespaces Class

Sentry AIX HPUX Linux SCO Solaris Tru64 Windows
Datafile √ √ √ √
Tablespace √ √ √ √


[edit]

Sentry Details

[edit]

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


[edit]

Sentry State Details

[edit]

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


[edit]

Init_File Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Not_Existalarm !$exists
Modified warning $mtime != $prev_mtime OK after acknowledgement
OK normal


[edit]

Logons Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled $sql_error != ""


[edit]

Security_Info Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled $sql_error != ""



[edit]

Sessions Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled$error_test != ""
OK normal


[edit]

SGA Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled !$up
OK normal


[edit]

SID_info Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled !$up
OK normal


[edit]

Spfile Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Not_Existalarm !$exists
Modified warning $mtime != $prev_mtime OK after acknowledgement
OK normal


[edit]

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


[edit]

AlertLog Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
ERROR info Delete after acknowledgement



[edit]

Archive_Logs Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled !$up
OK normal
Delete built-in No data state


[edit]

Control_Files Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Not_Existalarm !$exists
OK normal


[edit]

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


[edit]

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


[edit]

Monitor_locks Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Down disabled $error_text != ""
Delete built-in No data state


[edit]

Processes Sentry

Availability
AIX, HPUX, Linux, Solaris

States

State Severity Condition Escalation
Not_Running disabled $count == 0
OK normal


[edit]

Datafile Sentry

Availability
AIX, HPUX, Linux, Solaris

Constants

Constant Description Value
LOW Indicating a low percentage of free space 10

States

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


[edit]

Tablespace Sentry

Availability
AIX, HPUX, Linux, Solaris

Constants

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

States

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


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