Search BC Sites

Free Oracle Tips   HTML Text

Free Oracle App Server Tips   HTML Text

Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson Consulting

The top CPU Summary

The first output from top shows the load on each processor and the current top sessions in terms of CPU utilization. Top gives details on each CPU on the server, and we can immediately see from the listing below that this server has six CPUs, numbered 0–5:

root> top

Cpu states:
CPU LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS
0 0.63 10.9% 0.0% 4.0% 85.1% 0.0% 0.0% 0.0% 0.0%
1 0.40 27.4% 0.0% 7.4% 65.3% 0.0% 0.0% 0.0% 0.0%
--- ---- - - - - - - - -----
avg 0.52 19.1% 0.0% 5.7% 75.3% 0.0% 0.0% 0.0% 0.0%

Memory: 100428K (25608K) real, 107920K (30120K) virtual, 328948K free

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.