[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

[rhelv5-list] IO tuning rhel5.3 and Oracle 11g



Hi,

One of our Oracle 11g database servers seems to have an io related
performance bottle-neck. DBA complain about lack of performance, and indeed
monitoring the system while running some test Oracle queries show io related
problems:

]# vmstat 1
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
 r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id
wa st
 2 10 110012  90012   8012 2934768    1    0  2797   237    3    2 10  1 80
9  0
 2 10 110012 125728   8024 2897996    0    0 96560    44 7027 7927 22  3 33
42  0
 1 10 110012 101376   8072 2922136    4    0 73452    36 6834 7377 22  3 46
29  0
 2  9 110012 110076   8040 2913072    0    0 118236    96 7716 8594 22  3 43
31  0
 1 10 110012 104080   8112 2919176    0    0 84912  7880 7096 7920 19  3 37
41  0
 1 10 110012  92572   8076 2931128    0    0 96220    48 7225 8276 24  3 32
42  0
 2  9 110012 112192   7996 2911412    0    0 99088   148 7444 8531 21  3 44
32  0
 4  7 110012  97496   8040 2926508    0    0 86388    60 7475 8212 22  3 44
31  0

To find an optimal balance between the HP-EVA-8000 SAN system and this Linux
system, we modifed max_sectors_kb per connected SAN lun from 512 to 32.

Oracle itself is using huge pages, and we present three 2TB luns to the
system to host the database instead of one big lun. File system is ext3 with
extra mount option noatime.

Server is a HP Prolaint Blade BL460C with 2 FC-HBA's, dual quad core en 16GB
memory.

Any input is welcome about how to improve IO performance or how to determine
why IO is the bottleneck.
 
Cheers,
Andre

---
Wageningen University
The Netherlands

Attachment: smime.p7s
Description: S/MIME cryptographic signature


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]