Windows版的Oracle到底會不會用到OS Cache

sundog315發表於2010-10-26
在文件中看到這段:

Operating systems and device controllers provide data caches that do not directly conflict with Oracle Database cache management. Nonetheless, these structures can consume resources while offering little or no performance benefit. This situation is most noticeable when database files are stored in a Linux or UNIX file system. By default, all database I/O goes through the file system cache.

On some Linux and UNIX systems, direct I/O is available to the filestore. This arrangement allows the database files to be accessed within the file system, bypassing the file system cache. Direct I/O saves CPU resources and allows the file system cache to be dedicated to non-database activity, such as program texts and spool files.

Note:
This problem does not occur on Windows. All file requests by the database bypass the caches in the file system.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/19423/viewspace-676710/,如需轉載,請註明出處,否則將追究法律責任。

相關文章