The difference can be drastical from the I/O subsystem
sizing perspective if you have 500 blocks modified and
if you have 50 blocks.
Anybody ever trade-off the design (the different
column order in the index, ...) to slowdown INSERT 's
by imposing Oracle waits (to insert into less blocks
as possible) to have downsized I/O subsystem that can
resist the volume.
If my thinking is stupid let me know too :)
Also, I am aware that somebody will tell me why do you
want to have less disks when disks are the cheapest.
Anyway I will spend the similar amount of CPU in both
cases, just will have less I/O.
It looks that sometimes things like right-handed index
or not optimal table/index design can save us of the
disaster when I/O subsystem is not sized properly :)
Thanks in advance for all comments.
Regards,
Zoran Martic
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
