User Tools
uls:agents:oracle_tools:watch_oracle
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
uls:agents:oracle_tools:watch_oracle [2014-02-13 14:45] uls [Buffer Cache] |
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 167: | Line 174: | ||
| |} | |} | ||
| + | ----- | ||
| === Dictionary Cache === | === Dictionary Cache === | ||
| Line 201: | Line 209: | ||
| |} | |} | ||
| + | ----- | ||
| === Detailed Dictionary Cache === | === Detailed Dictionary Cache === | ||
| Line 227: | Line 236: | ||
| |} | |} | ||
| + | ----- | ||
| === Fast Recovery Area === | === Fast Recovery Area === | ||
| Line 253: | Line 263: | ||
| |} | |} | ||
| + | ----- | ||
| === Flashback Recovery Area === | === Flashback Recovery Area === | ||
| Line 281: | Line 292: | ||
| |} | |} | ||
| + | ----- | ||
| === Info === | === Info === | ||
| Line 305: | 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 348: | Line 362: | ||
| |} | |} | ||
| + | ----- | ||
| === Latches === | === Latches === | ||
| Line 366: | Line 381: | ||
| |} | |} | ||
| + | ----- | ||
| === Library Cache === | === Library Cache === | ||
| Line 407: | Line 423: | ||
| |} | |} | ||
| + | ----- | ||
| === Open Cursors === | === Open Cursors === | ||
| Line 431: | 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 449: | Line 468: | ||
| |} | |} | ||
| + | ----- | ||
| === PGA === | === PGA === | ||
| Line 619: | Line 639: | ||
| |} | |} | ||
| + | ----- | ||
| === Scheduler === | === Scheduler === | ||
| Line 629: | Line 650: | ||
| |} | |} | ||
| + | ----- | ||
| === Sessions and Processes === | === Sessions and Processes === | ||
| Line 644: | Line 666: | ||
| | The defined max number of processes. | | The defined max number of processes. | ||
| |} | |} | ||
| + | |||
| + | ----- | ||
| === Shared Pool === | === Shared Pool === | ||
| Line 676: | 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 691: | 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 764: | Line 790: | ||
| |} | |} | ||
| + | ----- | ||
| === Tablespace Info === | === Tablespace Info === | ||
| Line 825: | Line 852: | ||
| |} | |} | ||
| + | ----- | ||
| === Tablespace Usage === | === Tablespace Usage === | ||
| Line 849: | Line 877: | ||
| |} | |} | ||
| + | ----- | ||
| === Wait Events Classes === | === Wait Events Classes === | ||
| Line 877: | 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 948: | 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.1392299149.txt.gz ยท Last modified: 2014-02-13 14:45 by uls
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
