Windows版的Oracle到底會不會用到OS Cache
在文件中看到這段:
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.
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 到底人工智慧會不會統治世界人工智慧
- 刨根問底: Kafka 到底會不會丟資料?Kafka
- MySQL修改表結構到底會不會鎖表?MySql
- MYSQL DQL in 到底會不會走索引&in 範圍查詢引發的思考。MySql索引
- 不會git的程式設計師,會不會被鄙視?Git程式設計師
- **一些會用到的js方法JS
- 我到底會不會繼續寫日誌。。。4月東莞出差定目標
- 亞馬遜開的那個不用排隊結賬的便利店 到底會不會大面積開店?亞馬遜
- oracle增加主鍵也不會了Oracle
- 測試中會用到的四款工具
- javascript 的問題 ,不知你會不會。JavaScript
- 答 “SOA會不會造成IT黑洞?”
- 【學習筆記】不會吧不會吧,不會有人還在手寫堆吧筆記
- iOS實現幾種會用到的加密方式iOS加密
- 風口之上,車聯網系統到底會不會是“另一個”智慧手機系統?
- 不會吧不會吧,還有開發不會Java填充PDF模板資料的,趕緊看看吧Java
- securecrt保持會話不會斷掉Securecrt會話
- 你可能會用到的一個路由介面卡路由
- 開發可能會用到的三種快取key快取
- 你可能會用到的Android Studio快捷鍵Android
- 過年,你肯定會用到這款小程式!
- Windows10系統開機登入會解除嗎?不會可以這樣試試Windows
- 拯救不會函式的我!!函式
- 筆試不會的東西筆試
- Python是什麼?哪些領域會用到?Python
- Oracle10g Data guard會不會自動更新sys使用者密碼?Oracle密碼
- Flutter 會不會被蘋果限制其發展?Flutter蘋果
- 迭代器筆試題,看看你會不會?筆試
- Singleton模式會不會降低效率?模式
- 特斯拉會不會成為下一個蘋果?蘋果
- 高手不會和你聊天
- Windows下大量SYSMAN會話超出會話限制Windows會話
- 學習java一定會用到的應用軟體Java
- 直接拿去用!每個App都會用到的LoadingLayoutAPP
- 27個Asp.Net經常會用到的函式集ASP.NET函式
- oracle如何徹底kill掉會話及os作業系統資源Oracle會話作業系統
- Web 開發會用到的20款優秀的開源工具Web開源工具
- ChatGPT這波熱潮會不會讓我失業?ChatGPT