You should download ORION - it is free tool from Oracle. ORION is made from Oracle's IO libraries, so it is as close as possible to the real world. The first thing you have to do is to set some baselines for read-to-write ratio, large-to-small IOs and so on. You better get the data form your real Oracle DB (look at ORION docs, they explain how). There is not one BEST filesystem, some handle small files better, other - big ones. Take you real questions from a real database and you will get real answer.
ORION is really useful to me and I use it allays to check if the storage and OS admins have done their job fine. It makes real tests. Take a time to learn it.
-- Regards, Yavor Ivanov Oracle Certified Professional Oracle Certified RAC ExpertOn Tue, 27 Nov 2007 07:39:48 +0200, Haroon A. Qureshi <haroon_a_qureshi@xxxxxxxxx> wrote:
greetings,has anyone ever conducted any formal testing on filesystem i/o for performance? was there a methodology that was followed and what tools did you use to measure the performance?i'd like to do some research to better understand all the different types of filesystems and i/o and how they affect a database's performance. i know of some tools out there, such as iozone, but i'd like to understand the approach and methodology of formally conducing the test. any help our guidance would be greatly apprectiaed.thanks in advance, haroon -- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l
