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
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ rhelv5-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/rhelv5-list
