oracle on Linux/Nehalem: start to see run queue>10 when cpu usage lower than 50%

hi, All,
   We are testing HP DL380 G7 with Redhat Linux 5.4, load it with lots of
very small SQL (through a jdbc client with 50~100~200 session) continuesly
issue SQL to database server; It is 2 socket/12 core system with 72gb
memory; there are still tons of free emmory there;

   It is little bit interesting; We haven't used Linux on database server
here, my last linux running oracle was 8 years ago with very early
deployment of oracle rac on linux:).

  Does anyelse have similar experience?  Any tuning needed from linux? We
tested both dedicated server and shared server and see similar result;  But
if we continue to add more clients onto the server, the througput put will
continue increase; I checked oracle hidden parameter and NUMA was not
enabled; (_db_block_numa=1);
  There was nearly no disk IO(all in memory test, close to our real
application running on that db);


*pro*cs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
* r * b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy*id
*wa st
*24 * 0      0 28717536 584652 42109568    0    0     0     0 105512 184374
38 20 *42 * 0  0
*32 * 0      0 28718652 584652 42109568    0    0     0    64 104028 181991
37 20 *44 * 0  0
*30 * 0      0 28717784 584652 42109568    0    0    16    76 105590 184456
38 20 *42 * 0  0
*20 * 0      0 28718528 584652 42109572    0    0     0    64 97483 170011
35 18 4*7  *0  0
*29 * 0      0 28717908 584652 42109572    0    0     0     0 104939 182623
37 20 *43 * 0  0
*21 * 0      0 28718776 584652 42109576    0    0    16    61 105254 183564
37 20 *43 * 0  0
*16 * 0      0 28718032 584652 42109576    0    0     0     0 105541 184965
36 19 *44 * 0  0
*19 * 0      0 28718280 584652 42109576    0    0     0     0 93986 163849
32 17 5*1  *0  0
*23 * 0      0 28716420 584652 42109576    0    0    48   108 105028 182659
39 20 *42 * 0  0
*36 * 0      0 28717164 584652 42109576    0    0     0     0 105100 182699
36 20 *44 * 0  0
*34 * 0      0 28715552 584652 42109576    0    0     0     4 105538 183129
36 19 *45 * 0  0
*27 * 0      0 28716552 584652 42109608    0    0    16    60 95618 166890
33 18 5*0  *0  0
*31 * 0      0 28715056 584652 42109608    0    0     0     0 105478 183278
38 20 *43 * 0  0
*30 * 0      0 28715552 584652 42109608    0    0     0   104 105884 185131
38 20 *42 * 0  0
*22 * 0      0 28714808 584652 42109608    0    0    16    60 105680 185074
36 20 *44 * 0  0



-- 
Regards
Zhu Chao

Other related posts: