Database Administration (MOSC)

MOSC Banner

Highly system resource is utilized frequently


$ top

top - 00:44:20 up 26 days, 17:49, 2 users, load average: 18.49, 18.94, 19.60

Tasks: 1333 total, 22 running, 1311 sleeping,  0 stopped,  0 zombie

%Cpu(s): 86.0 us, 2.4 sy, 0.0 ni, 7.5 id, 3.8 wa, 0.0 hi, 0.3 si, 0.0 st

KiB Mem : 59267756+total, 69426304 free, 51548288 used, 47170297+buff/cache

KiB Swap: 18874364 total, 18846452 free,  27912 used. 18494136+avail Mem


$ ps -eo user,pid,cmd,%cpu,%mem --sort=-%cpu | head

USER    PID CMD             %CPU %MEM

oracle  81344 ora_dw03_NGLOBAL2      60.3 11.0

oracle  81346 ora_dw04_NGLOBAL2      48.1 0.0

oracle  81342 ora_dw02_NGLOBAL2      46.5 0.1

oracle  81338 ora_dw00_NGLOBAL2      40.6 0.1

oracle  81340 ora_dw01_NGLOBAL2      33.0 1.1

oracle  195036 oracleNGLOBAL2 (LOCAL=NO)  30.3 1.0

oracle  113809 oracleNGLOBAL2 (LOCAL=NO)  23.8 1.1

oracle  113811 oracleNGLOBAL2 (LOCAL=NO)  21.9 0.9

oracle  113817 oracleNGLOBAL2 (LOCAL=NO)  21.4 0.9

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