Have you set noatime for the oracle filesystems?
It is I believe a standard practice on linux/unix, though I'm not sure of any solid measurements of performance difference.
see http://www.oracle.com/technology/oramag/webcolumns/2002/techarticles/scalzo_linux01.html for example.
(google for it, the supplied URL was the first I found that mentioned it for Oracle)
Jared
We set up a side by side comparison to test our Oracle DB application on Windows 2003 32 Bit vs. Red Hat Linux. We set up two virtual partitions and alternately stopped one and tested the other. We have been reading different benchmark tests and came to believe that we would see a 30% to 40% performance advantage using linux. We used Load Runner and tested three program functions with 30-60-90 users. Windows performed about 10% better. Does anybody have any advice or observations on this? Any configuration advice?
Don Freeman Database Administrator 1 Bureau of Information Technology Pennsylvania Department of Health (717) 703-5782
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist