WIO is very high !! how to reduce it?

[ndisang]

I disagree.

How do you Tune an insert to do less I/O or an update or a delete???

I/O sometimes can not be avoided in order to do meaningful work (hmm what ever that means)... In those cases when the I/O waits are high then proper disk managment and analysis of the system layout is required to improve system performance and response times.

I think one can tune inserts and updates...since you can generate explain plan for them.

what about nolloging, parallism, indexes, paralell dml?