RE: How many of you use S.A.M.E?

I use S.A.M.E to some extent, but not blindly. It all depends on your performance needs, available funds/hardware, OS, etc. If you have the time and resources to fine tune for every type of I/O your database performs and continually maintain such a configuration in order to get an extra 5-10% performance boost, then go for it, but I prefer the simplicity and generally very good peformance of of S.A.M.E. All my systems have I/O times under 10ms, but that is of course a function of how many spindles you stripe across, the amount of cache you have (for the DB, the OS & the SAN), how many IOPS, etc. I prefer to spend my time tuning the queries to reduce their I/O demands - that is by far where you get the biggest ROI (unless you happen to have a very well tuned application, which is quite rare).  

Regards,
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l