oracle on Linux/Nehalem: start to see run queue>10 when cpu usage lower than 50%
- From: "Zhu,Chao" <zhuchao@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Aug 2010 00:14:11 +0800
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:
