Doug Burns has started an interesting blog thread about the Oracle Database 11g PARALLEL_IO_CAP_ENABLED parameter in his blog entry about Parallel Query and Oracle Database 11g. Doug is discussing Oracle’s new concept of built-in I/O subsystem calibration-a concept aimed at more auto-tuning database instances. The idea is that Oracle is trying to make PQ more [...]
In the comment section of my recent post about Tim Hall’s excellent NFS step-by-step Linux RAC install Guide, Tim came full circle to ask a question about asynchronous I/O on NFS. He wrote:
What do you set your filesystemio_options init.ora parameter to when using Oracle over NFS?
Based on what you’ve written before I know NFS supports [...]
The Oracle Server is completely functional on platforms that do not support asynchronous I/O—it always has been. Two of the three main areas async I/O comes in to play are DBWR buffer flushing and Parallel Query Option direct path read and writes. These two uses of async I/O can usually be worked around with either [...]