Universal Logging System

User Tools

Site Tools

Trace:
uls:agents:oracle_tools:watch_oracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
uls:agents:oracle_tools:watch_oracle [2013-12-05 18:14]
uls [Gathered Metrics] 		uls:agents:oracle_tools:watch_oracle [2015-01-13 11:25] (current)
uls
Line 1: Line 1:
 ===== watch_oracle ===== ===== watch_oracle =====
  
-This is a monitoring script for Oracle 9i, 10g and 11g database instances. ​+This is a monitoring script for Oracle 9i, 10g, 11g and 12c database instances. ​
 It only does SELECTs on system tables, definitely no changes to anything! It only does SELECTs on system tables, definitely no changes to anything!
 No *_HIST_* tables are used. No *_HIST_* tables are used.
Line 40: Line 40:
 the default is "<​oracle_tools_dir>/​var"​. the default is "<​oracle_tools_dir>/​var"​.
  
 +-----
  
 ==== Configuration ==== ==== Configuration ====
Line 74: Line 75:
 </​code>​ </​code>​
  
 +-----
  
 ==== Usage ==== ==== Usage ====
Line 89: Line 91:
 defined for WORKING_DIR in the "​oracle_tools.conf", ​ defined for WORKING_DIR in the "​oracle_tools.conf", ​
 the default is "<​oracle_tools_dir>/​var/"​. the default is "<​oracle_tools_dir>/​var/"​.
 +
 +-----
  
 === Regular Execution === === Regular Execution ===
Line 103: Line 107:
 </​file>​ </​file>​
  
 +-----
  
 ==== Output Results ==== ==== Output Results ====
Line 109: Line 114:
 of watch_oracle.pl,​ version 0.55: of watch_oracle.pl,​ version 0.55:
  
 +-----
  
 === Alert Log === === Alert Log ===
Line 139: Line 145:
 **if** error entries were found in the **selected** time period! **if** error entries were found in the **selected** time period!
  
 +-----
  
 === Buffer Cache === === Buffer Cache ===
Line 157: Line 164:
  been found in the buffer cache without requiring disk access:  been found in the buffer cache without requiring disk access:
 <code oracle11>​ <code oracle11>​
-SELECT physical_reads,​ db_block_gets + consistent_gets FROM V$BUFFER_POOL_STATISTICS;​+SELECT physical_reads,​ db_block_gets + consistent_gets ​ 
 +  ​FROM V$BUFFER_POOL_STATISTICS;​
 </​code>​ </​code>​
  Using the above results for each buffer cache, its hit ratio is calculated with the following formula:  Using the above results for each buffer cache, its hit ratio is calculated with the following formula:
Line 166: Line 174:
 |} |}
  
 +-----
  
 === Dictionary Cache === === Dictionary Cache ===
Line 200: Line 209:
 |} |}
  
 +-----
  
 === Detailed Dictionary Cache === === Detailed Dictionary Cache ===
Line 226: Line 236:
 |} |}
  
 +-----
  
 === Fast Recovery Area === === Fast Recovery Area ===
Line 252: Line 263:
 |} |}
  
 +-----
  
 === Flashback Recovery Area === === Flashback Recovery Area ===
Line 280: Line 292:
 |} |}
  
 +-----
  
 === Info === === Info ===
Line 304: Line 317:
 | Is the ISO timestamp of when this instance has been started. | Is the ISO timestamp of when this instance has been started.
 |} |}
 +
 +-----
  
 === Jobs === === Jobs ===
Line 347: Line 362:
 |} |}
  
 +-----
  
 === Latches === === Latches ===
Line 365: Line 381:
 |} |}
  
 +-----
  
 === Library Cache === === Library Cache ===
Line 406: Line 423:
 |} |}
  
 +-----
  
 === Open Cursors === === Open Cursors ===
Line 415: Line 433:
 Raise the OPEN_CURSORS parameter if sessions reach the current limit. If a session continuously gets an ORA-1000, it may indicate a leak in the application code. Raise the OPEN_CURSORS parameter if sessions reach the current limit. If a session continuously gets an ORA-1000, it may indicate a leak in the application code.
  
-See also: [[http://​orafaq.com/​node/​758|Monitoring Open and Cached Cursors]].+See also: [[uls:misc:​references#​Monitoring Open and Cached Cursors]].
  
 {| {|
Line 430: Line 448:
 | The average number of opened cursors for all sessions. | The average number of opened cursors for all sessions.
 |} |}
 +
 +-----
  
 == Session Cached Cursors == == Session Cached Cursors ==
Line 448: Line 468:
 |} |}
  
 +-----
  
 === PGA === === PGA ===
Line 618: Line 639:
 |} |}
  
 +-----
  
 === Scheduler === === Scheduler ===
Line 628: Line 650:
 |} |}
  
 +-----
  
 === Sessions and Processes === === Sessions and Processes ===
Line 643: Line 666:
 | The defined max number of processes. | The defined max number of processes.
 |} |}
 +
 +-----
  
 === Shared Pool === === Shared Pool ===
Line 675: Line 700:
 In newer Oracle databases, the parameter SGA_TARGET or MEMORY_MAX_TARGET (dynamically manage both the SGA and PGA) is set and Oracle manages all pools and the PGA by itself (Automatic Memory Management). In newer Oracle databases, the parameter SGA_TARGET or MEMORY_MAX_TARGET (dynamically manage both the SGA and PGA) is set and Oracle manages all pools and the PGA by itself (Automatic Memory Management).
  
 +-----
  
 === SGA === === SGA ===
Line 690: Line 716:
 You may change buffer cache, shared pool and large pool without bouncing the instance, as long as there is free memory available. You may change buffer cache, shared pool and large pool without bouncing the instance, as long as there is free memory available.
  
 +-----
  
 === System Statistics === === System Statistics ===
Line 763: Line 790:
 |} |}
  
 +-----
  
 === Tablespace Info === === Tablespace Info ===
Line 824: Line 852:
 |} |}
  
 +-----
  
 === Tablespace Usage === === Tablespace Usage ===
Line 848: Line 877:
 |} |}
  
 +-----
  
 === Wait Events Classes === === Wait Events Classes ===
Line 876: Line 906:
 | Percentage of the wait class 'time waited'​ to the sum of 'time waited'​ for all wait classes. | Percentage of the wait class 'time waited'​ to the sum of 'time waited'​ for all wait classes.
 |} |}
 +
 +-----
  
 === Wait Events === === Wait Events ===
Line 947: Line 979:
 TIMED_STATISTICS must be set to TRUE, which is not the default for some operating systems. TIMED_STATISTICS must be set to TRUE, which is not the default for some operating systems.
  
 +-----
  
 ==== Auto-Monitoring Settings ==== ==== Auto-Monitoring Settings ====
uls/agents/oracle_tools/watch_oracle.1386263689.txt.gz · Last modified: 2014-01-03 13:03 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
GNU Free Documentation License 1.3 Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki