Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: different oracle server process has different priority value in the same instance
priority changes all the time - it depends on how much time it has already had on the cpu and on your priority table
From: oracle-l-bounce_at_freelists.org on behalf of zhu chao
Sent: Sat 21/02/2004 16:17
To: oracle-l_at_freelists.org
Subject: different oracle server process has different priority value in the same instance
Hi, friends:
I noticed that the different oracle server processes have different priority value , and all the oracle process belong to the same instance, spawned by the same listener.
I cannot understand it.How can this happen? The following is the result of top, look at the PRI column of the top output.
And some oraclel process has more threads, while others not.(the THR column).
Solaris:
last pid: 19320; load averages: 2.01, 2.24, 2.43
00:15:35
535 processes: 533 sleeping, 1 running, 1 on cpu
CPU states: 71.1% idle, 21.0% user, 3.4% kernel, 4.6% iowait, 0.0% swap
Memory: 16G real, 503M free, 13G swap in use, 16G swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
1568 oracle 11 50 0 12G 12G sleep 29.4H 1.82% oracle 1519 oracle 11 42 0 12G 12G sleep 31.3H 1.67% oracle 17755 oracle 1 58 0 12G 12G sleep 2:41 0.44% oracle 1028 oracle 1 58 0 12G 12G sleep 294:35 0.42% oracle 1637 oracle 11 58 0 12G 12G run 626:50 0.41% oracle 1633 oracle 11 55 0 12G 12G sleep 607:38 0.40% oracle 1560 oracle 1 58 0 12G 12G sleep 758:09 0.37% oracle 17682 oracle 1 58 0 12G 12G sleep 1:20 0.35% oracle 1078 oracle 1 59 0 12G 12G sleep 313:48 0.34% oracle 1580 oracle 11 59 0 12G 12G sleep 670:46 0.31% oracle 1050 oracle 11 58 0 12G 12G sleep 194:10 0.31% oracle 1639 oracle 11 58 0 12G 12G sleep 613:18 0.30% oracle 1635 oracle 11 48 0 12G 12G sleep 601:22 0.30% oracle 17670 oracle 1 58 0 12G 12G sleep 562:31 0.30% oracle
Linux top output:
[oracle_at_rac1 oracle]$ top -d 1
12:40am up 110 days, 11:25, 1 user, load average: 0.91, 0.92, 0.89 275 processes: 273 sleeping, 2 running, 0 zombie, 0 stopped
CPU0 states: 7.0% user, 0.1% system, 0.0% nice, 91.0% idle CPU1 states: 7.0% user, 2.0% system, 0.0% nice, 89.0% idle CPU2 states: 27.0% user, 2.0% system, 0.0% nice, 69.0% idle CPU3 states: 15.0% user, 0.1% system, 0.0% nice, 83.0% idle Mem: 3347708K av, 3341444K used, 6264K free, 0K shrd, 178868K buff Swap: 2096472K av, 51528K used, 2044944K free 557292Kcached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
28595 oracle 15 0 15004 13M 11388 D 16.4 0.4 0:41 oracle 11781 oracle 16 0 18784 16M 10872 S 9.6 0.5 35:13 oracle 24123 oracle 16 0 18064 16M 11124 S 7.7 0.5 419:48 oracle 16049 oracle 16 0 17808 16M 10896 S 5.8 0.5 208:08 oracle 23944 oracle 16 0 18044 16M 11132 S 4.8 0.5 416:40 oracle 26026 oracle 15 0 17800 16M 10892 S 4.8 0.5 97:14 oracle 28800 oracle 15 0 1200 1200 848 R 3.8 0.0 0:00 top 11574 oracle 15 0 19248 16M 11260 S 2.9 0.5 524:18 oracle 11568 oracle 15 0 17832 16M 10900 S 1.9 0.5 59:54 oracle 11602 oracle 15 0 17820 16M 10892 S 1.9 0.5 60:52 oracle 11566 oracle 15 0 17832 16M 10912 S 0.9 0.5 59:43 oracle 11628 oracle 15 0 11684 11M 9976 S 0.9 0.3 1:02 oracle 17832 oracle 15 0 17832 16M 10916 S 0.9 0.5 478:05 oracle 22350 oracle 15 0 18840 16M 10900 S 0.9 0.5 39:32 oracle
Regards.
Zhu Chao.
![]() |
![]() |