Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

RE: different oracle server process has different priority value in the same instance

David Sharples

2004-02-21


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@(protected)
Sent: Sat 21/02/2004 16:17
To: oracle-l@(protected)
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@(protected)

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@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



-- Binary/unsupported file stripped by Ecartis --
-- Type: application/ms-tnef
-- File: winmail.dat


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.