For Oracle support & training call (800) 766-1884
Free Oracle Tips

Home
Oracle Tips
Oracle Code Depot
Oracle Monitoring
Oracle Consulting
Oracle Training
Oracle News
Oracle Forum
Oracle Support





 

Free Oracle Tips

image

 
HTML Text

Free Oracle App Server Tips

image

 
HTML Text


Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle


 

 
 

Oracle Tips by Burleson Consulting
 

The UNIX watch command

One common method for watching UNIX server load is to monitor the load average for the server. The load average is an arbitrary number that shows overall resource consumption of the server. Most load average displays have three values for the load average. The load average display shows the load averages for the past minute, the past 5 minutes, and the past 10 minutes. A low load average is ideal, and the load average should stay below zero. Whenever the value exceeds “1” there may be a CPU overload problem.

root> w

5:54pm up 2 days, 22:45, 29 users, load average: 0.08, 0.14, 0.22
User tty login@ idle JCPU PCPU what
root ttyp1 7:11pm 25:47 tee -a /u01/home/crup
triha ttyp2 4:48pm 20 3 3 runmenu50 pamenu
lpayne ttyp3 5:29pm 24 runmenu50 pamenu
burleson ttyp5 5:50pm -sh
tteply ttyp6 5:05pm 10 1 1 runmenu50 pamenu
kjoslin ttyp7 1:29pm 30 38 38 runmenu50 pamenu
jperry ttyp8 6:48am 1 51 51 runmenu50 pamenu
kharstad ttype 3:38pm 2:16 -sh
cmconway ttyqc 11:53am 17 5 5 runmenu50 pamenu
jhahn ttyr7 1:43pm 10 2 2 runmenu50 pamenu
tbailey ttyrb 12:12pm 1:38 4 4 runmenu50 pamenu


The above is an excerpt from the "Oracle9i UNIX Administration Handbook" by Oracle press, authored by Donald K. Burleson.

 

For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot.

 

 

  
 

 
 
 
 
Oracle performance tuning software
 
 

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544


Email BC:

 

Hit Counter