Database Tuning (MOSC)

MOSC Banner

Help me in interpreting TOP Command in unix

edited Dec 28, 2011 2:57AM in Database Tuning (MOSC) 13 comments
Hello Everyone,

Kindly help in interpreting TOPcommand, below is the output

System: ABC                                      Sat Dec 10 13:13:32 2011
Load averages: 0.39, 0.49, 0.56
523 processes: 487 sleeping, 35 running, 1 zombie
Cpu states:
CPU  LOAD   USER   NICE    SYS   IDLE  BLOCK  SWAIT   INTR   SSYS
 0     0.42      21.3%   4.4%  15.9%  58.4%   0.0%   0.0%   0.0%   0.0%
 1     0.36      4.6%   1.6%  70.8%  23.1%   0.0%   0.0%   0.0%   0.0%
 2     0.38      3.2%   4.8%  19.5%  72.6%   0.0%   0.0%   0.0%   0.0%
 3     0.39      4.0%   2.8%  15.1%  78.1%   0.0%   0.0%   0.0%   0.0%
 4     0.35      4.4%   2.8%  22.1%  70.8%   0.0%   0.0%   0.0%   0.0%
 5     0.33      5.0%   7.8%  23.1%  64.2%   0.0%   0.0%   0.0%   0.0%
 6     0.37      2.6%   5.4%  22.1%  70.0%   0.0%   0.0%   0.0%   0.0%
 7     0.37      9.7%   3.6%  16.5%  70.2%   0.0%   0.0%   0.0%   0.0%
 8     0.41      4.4%   1.0%  32.4%  62.2%   0.0%   0.0%   0.0%   0.0%
 9     0.39     4.2%   9.3%  20.9%  65.6%   0.0%   0.0%   0.0%   0.0%
10    0.37      3.8%   6.0%  18.3%  72.0%   0.0%   0.0%   0.0%   0.0%
11    0.37     4.2%   4.6%  21.5%  69.8%   0.0%   0.0%   0.0%   0.0%
12    0.33     5.2%   5.8%  23.1%  66.0%   0.0%   0.0%   0.0%   0.0%
13    0.39     5.4%   8.3%  30.4%  55.9%   0.0%   0.0%   0.0%   0.0%
14    0.39      3.8%   7.0%  22.3%  67.0%   0.0%   0.0%   0.0%   0.0%
15    0.66     82.1%   0.8%   5.0%  12.1%   0.0%   0.0%   0.0%   0.0%
---   ----  -----  -----  -----  -----  -----  -----  -----  -----
avg   0.39  10.5%   4.8%  23.7%  61.0%   0.0%   0.0%   0.0%   0.0%

Memory: 22618252K (11753440K) real, 23266264K (12285496K) virtual, 28800008K free  Page# 1/24

CPU TTY     PID  USERNAME PRI NI   SIZE    RES STATE    TIME %WCPU  %CPU COMMAND
 7     ?    24364   ora10g      241 20 17130M  8096K run   2319:46 98.56 98.38 oraclePREPCDR
12    ?    28356   ora10g      241 20 17193M 70560K run      0:58 76.71 76.41 ora_j002_PREPCDR
 3    ?    19669   ora10g       245 22  2224K   624K run     33:45 63.50 63.39 compress
10   ?    24938   ora10g       241 20 17242M   119M run    125:19 33.55 33.50 ora_j005_PREPCDR
 9    ?    21705   ora10g       149 20 17799M   677M sleep 1332:21 24.71 24.66 ora_j000_PREPCDR

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center