Originally Posted by rajaniyer123
We have just migrated Oracle Database from Solaris Server to Linux VM [ESX] server.
We have observed that there is high I/O wait issues while database query is running on Linux VM, which was ideally zero in case of Solaris. In the same ref. please let me know, is there any tunning need to be done from linux side.
No idea, since there aren't enough details. Solaris probably wasn't running on a VM, and you don't tell us anything about how big that box was (CPU/Memory/disk/etc.), and you don't tell us what version/distro of Linux, or how you have the VMware box set up, and what resources you have assigned to that instance, or how big the database is, and on what kind of disk it's running and how many spindles.
Check the outputs of iostat/sar/top, and see what usages you're getting. Check the Oracle installation docs, and make sure you followed them for Linux installation.
Best thing to do would be to call Oracle support, since you're paying for it. They can run traces, and tell you where the bottleneck is.