different oracle server process has different priority value in the same instance
- From: "zhu chao" <chao_ping@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 22 Feb 2004 00:17:32 +0800
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@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 557292K
cached
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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
