外文翻译--解析Oracle数据库后台进程的功能.docxVIP

PAGE PAGE 1 耿祥义.JSP 基础教程.北京: 清华大学出版社,2009.10 附录 英文原文 Analysis of Oracle database background process function 1.DBWR process: the process of the implementation of the buffer is written to the data file, is responsible for the buffer memory management in a Oracle background process. When a buffer buffer is modified, it is marked as dirty, DBWR is the main task of dirty buffer is written to disk, so that the buffer to maintain clean. Because the buffer memory buffer in the database or user process dirty, unused buffer to reduce the number of. When the unused buffer down to little, so that user processes from disk into memory block to store could not find unused buffer, DBWR will manage buffer storage, the user process always available unused buffer. Oracle uses LRU ( LEAST RECENTLY USED ) algorithm ( LRU ) keep the memory data block is a recently used, so that the I/O minimum. In the following case indicates that DBWR will dirty buffers to disk: When a server process will be a buffer into the dirty table, the dirty expression to the critical length, the service will notify DBWR writing. The critical length for the value of the parameter DB-BLOCK-WRITE-BATCH half. When a server process in a LRU look-up table in DB-BLOCK-MAX-SCAN-CNT buffer, did not find unused buffer, it stops to find and notify the DBWR to write. Timeout ( every3 seconds ), DBWR will inform itself. When a checkpoint, LGWR will inform DBWR. of the first two cases, DBWR will dirty table block is written to disk, each can write blocks by the initialization parameter DB-BLOCK- specified by WRITE-BATCH. If the dirty list without this parameter specifies the number of buffer, DBWR from the LUR table to find another dirty buffer. If the DBWR in three inactive, a time-out occurs. In this case the DBWR on the LRU table to find the specified number of buffer, to find any dirty buffers to disk. Whenever a timeout occurs, DBWR finds a new buffer group. Each time by the DBWR to find the number of buffers for s