Wednesday, July 4, 2012

Avoid double caching to improve disk I/O performance in Oracle

If Oracle data are stored in a Filesystem a Concurrent IO mount option can improve performance ...
  • Data is transfered directly from the disk to the application buffer, bypassing the file buffer cache hence avoiding double caching (filesystem cache + Oracle SGA)
  • Emulates a raw-device implementation
  • Give a faster access to the backend disk and reduce the CPU utilization
  • Disable the inode-lock to allow several threads to read and write the same file

No comments:

Post a Comment