DBWR 寫資料檔案 （zt）
Server Process
1. First, the server checks whether the required block is available in the buffer cache using a hash function. If the block is found, it is moved to another point in LRU list away from the LRU end. This is a logical read, because no actual I/O took place. If the block is not found in the buffer cache, the server process has to read the block from the data file.
2. Before reading from the data file, the server process searches the LRU list for a free block.
3. While searching the LRU list, the server process moves dirty blocks to the dirty list.
4. If the dirty list exceeds its size threshold, the server signals DBWn to flush dirty blocks from the data buffer cache. If the server cannot find a free block within a search threshold, it signals DBWn to flush.
5. After a free block is found, the server reads the block from the data file into the free block in the database buffer cache. Oracle server process moves the block away from the LRU end of the LRU list.
6. If the blocks is not consistent, the server rebuilds an earlier version of the block from the current block and rollback segments.
DBWn Process
7. Dirty List Exceeds its Size Threshold: A server process finds that the dirty list has exceeded its size threshold, so it signals DBWn to flush. DBWn writes out the blocks on the dirty list.
8. Search Threshold Exceeded: A server process that cannot find a free block on the LRU list within the search threshold signals DBWn to flush dirty blocks. DBWn writes out dirty blocks directly from the LRU list.
9. Three Second Time-Out: Every three seconds, DBWn checks the dirty list for blocks to write. DBWn moves dirty blocks from the LRU list to the dirty list, so that it has enough blocks for a full write buffer. Then DBWn writes blocks on the dirty list from the buffer cache to the data files. If there is no update activity for extended periods of time, DBWn eventually writes out all of the dirty blocks during the three-second time-outs.
10. LGWR Signal a Checkpoint: When LGWR signals that a checkpoint has occurred, DBWn copies dirty blocks from the LRU to the dirty list and writes out the blocks on the dirty list.
11. Alter Tablespace Offline Temporary or Alter Tablespace Begin Backup: When a tablespace is altered offline temporary or its online backup is started, DBWn copied the dirty blocks for that tablespace from the LRU to the dirty list (step 8) and writes out the blocks on the dirty list (steps 6 and 7).
12.Drop Object: When an object is dropped, DBWn first flushes the objects dirty blocks to disk (steps 8 and 7).
13. Clean Shutdown (Normal, Immediate, or Transactional)
1. First, the server checks whether the required block is available in the buffer cache using a hash function. If the block is found, it is moved to another point in LRU list away from the LRU end. This is a logical read, because no actual I/O took place. If the block is not found in the buffer cache, the server process has to read the block from the data file.
2. Before reading from the data file, the server process searches the LRU list for a free block.
3. While searching the LRU list, the server process moves dirty blocks to the dirty list.
4. If the dirty list exceeds its size threshold, the server signals DBWn to flush dirty blocks from the data buffer cache. If the server cannot find a free block within a search threshold, it signals DBWn to flush.
5. After a free block is found, the server reads the block from the data file into the free block in the database buffer cache. Oracle server process moves the block away from the LRU end of the LRU list.
6. If the blocks is not consistent, the server rebuilds an earlier version of the block from the current block and rollback segments.
DBWn Process
7. Dirty List Exceeds its Size Threshold: A server process finds that the dirty list has exceeded its size threshold, so it signals DBWn to flush. DBWn writes out the blocks on the dirty list.
8. Search Threshold Exceeded: A server process that cannot find a free block on the LRU list within the search threshold signals DBWn to flush dirty blocks. DBWn writes out dirty blocks directly from the LRU list.
9. Three Second Time-Out: Every three seconds, DBWn checks the dirty list for blocks to write. DBWn moves dirty blocks from the LRU list to the dirty list, so that it has enough blocks for a full write buffer. Then DBWn writes blocks on the dirty list from the buffer cache to the data files. If there is no update activity for extended periods of time, DBWn eventually writes out all of the dirty blocks during the three-second time-outs.
10. LGWR Signal a Checkpoint: When LGWR signals that a checkpoint has occurred, DBWn copies dirty blocks from the LRU to the dirty list and writes out the blocks on the dirty list.
11. Alter Tablespace Offline Temporary or Alter Tablespace Begin Backup: When a tablespace is altered offline temporary or its online backup is started, DBWn copied the dirty blocks for that tablespace from the LRU to the dirty list (step 8) and writes out the blocks on the dirty list (steps 6 and 7).
12.Drop Object: When an object is dropped, DBWn first flushes the objects dirty blocks to disk (steps 8 and 7).
13. Clean Shutdown (Normal, Immediate, or Transactional)
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/35489/viewspace-84717/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- java資料list寫入檔案Java
- 檢視 Linux 檔案佔用程式寫資料?Linux
- python——將excel檔案寫入mysql資料庫中PythonExcelMySql資料庫
- 【Python】將網格資料寫入到VTK檔案Python
- python如何將資料寫入本地txt文字檔案Python
- php百萬資料透過指令碼檔案寫入csvPHP指令碼
- ocfs2檔案系統問題總結(zt)
- 檔案與資料
- 資料庫課程作業筆記 - 編寫資料庫遷移檔案資料庫筆記
- 檔案排版（文字檔案讀寫）
- oracle升級後資料檔案路徑變為大寫Oracle
- 資料庫課程作業筆記 - 編寫模型檔案資料庫筆記模型
- 修改Oracle資料庫字符集(zt)Oracle資料庫
- SYBASE資料庫dbcc命令詳解(zt)資料庫
- ORA-1122/ORA-1208 資料檔案頭寫丟失故障
- Xilinx內建RAM的初始化資料COE檔案編寫
- 用 ABAP 新建本地 Excel 檔案並寫入資料試讀版Excel
- 畸形檔案 資料夾
- Oracle 資料檔案回收Oracle
- Oracle資料檔案和臨時檔案的管理Oracle
- git的gitignore檔案排除資料夾和檔案Git
- 【淺出 PHP】PHP 檔案操作 寫檔案PHP
- VBA建立文字檔案、讀寫文字檔案
- Linux-檔案寫入和檔案同步Linux
- Golang 讀、寫檔案Golang
- Python 讀寫檔案Python
- PHP寫入檔案PHP
- Python——檔案讀寫Python
- keras讀寫檔案Keras
- 「Python」：檔案讀寫Python
- 檔案的讀寫
- 修改Oracle資料檔名及資料檔案存放路徑Oracle
- 織夢資料庫配置檔案-DedeCMS織夢資料庫檔案在哪裡資料庫
- 學習筆記(30):Python資料清洗實戰-Excel檔案讀寫筆記PythonExcel
- 【深入】體系結構-002-資料變化如何寫入檔案
- Oracle叢集檔案系統（OCFS2）使用者指南(zt)Oracle
- SQLServer移動資料檔案SQLServer
- 讀取資料夾檔案
- [20190410]dg建立臨時表檔案資料檔案.txt