Database Tuning (MOSC)

MOSC Banner

Understand the top command output

edited Jun 11, 2012 7:58PM in Database Tuning (MOSC) 3 commentsAnswered
440 processes: 438 sleeping, 2 on cpu
CPU states: 70.3% idle, 25.0% user,  4.7% kernel,  0.0% iowait,  0.0% swap
Memory: 16G phys mem, 9089M free mem, 8193M total swap, 8193M free swap

   PID USERNAME LWP PRI NICE  SIZE   RES STATE    TIME    CPU COMMAND
   678 oracle     1   0    0 1266M 1219M cpu/1   58:41 24.86% oracle
   944 oracle     1  54    0 3192K 1960K cpu/0    0:00  1.28% top
  5631 oracle     1  59    0 1269M 1235M sleep    0:13  0.50% oracle
 15940 oracle     1  59    0 1268M 1238M sleep    0:42  0.29% oracle
 26538 oracle     1  59    0 1271M 1244M sleep    0:42  0.19% oracle
 14579 oracle    11  59    0 1278M 1186M sleep  116:29  0.18% oracle
 15706 oracle     1  59    0 1274M 1239M sleep    0:15  0.17% oracle
 14575 oracle    90  59    0 1270M 1186M sleep   18:34  0.16% oracle
   514 oracle    11  59    0 1270M 1221M sleep    1:58  0.16% oracle
 14581 oracle    15  59    0 1277M 1198M sleep   17:37  0.14% oracle
 27188 oracle     1  59    0 1271M 1245M sleep    1:03  0.14% oracle
 14577 oracle    87  59    0 1270M 1186M sleep   18:34  0.12% oracle
 21527 oracle     1  59    0 1278M 1244M sleep    1:14  0.12% oracle

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