Speeding up Oracle disk I/O on RHEL4 systems

While poking around the web last wek, I came across a good paper from Redhat that describes how to utilize asynchronous and direct I/O with Oracle. I have been using the Oracle filesystemio_options=”SetAll” initialization parameter on a few RHEL 4 database servers to efficiently use memory, and had no idea idea that it provided the throughput numbers listed in Figure 2. Nice!

One Comment

Mike  on April 14th, 2007

Who are you o’ Blog o’ Matty?

I read your blog a lot and appreciate the fo-shizzle.

Keep it up.

-Mike

Leave a Comment