Oracle Database - DISK_ASYNCH_IO parameter

About

For optimum performance make sure you use asynchronous I/Os.

TRUE is the default parameter value for the majority of platforms.

gerardnico@orcl>SHOW PARAMETER disk_asynch_io

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------
disk_asynch_io                       boolean     TRUE
SELECT * FROM v$parameter WHERE lower(name) = 'disk_asynch_io' ;

These parameters enable or disable the operating system's asynchronous I/O facility. They allow query server processes to overlap I/O requests with processing when performing table scans.

Asynchronous operations are currently supported for parallel table scans, hash joins, sorts, and serial table scans. However, this feature can require operating system specific configuration and may not be supported on all platforms.

Articles Related

Documentation / Reference

  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at del.icio.us
  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at Digg
  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at Ask
  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at Google
  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at StumbleUpon
  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at Technorati
  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at Live Bookmarks
  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at Yahoo! Myweb
  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at Facebook
  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at Yahoo! Bookmarks
  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at Twitter
  • Bookmark "Oracle Database - DISK_ASYNCH_IO parameter" at myAOL
 
database/oracle/disk_asynch_io.txt · Last modified: 2011/03/07 09:20 by gerardnico