Database Buffer Cache (79)

tsinglee發表於2007-10-23

The database buffer cache is the portion of the SGA that holds copies of data blocks
read from datafiles. All user processes concurrently connected to the instance share
access to the database buffer cache.
The database buffer cache and the shared SQL cache are logically segmented into
multiple sets. This organization into multiple sets reduces contention on
multiprocessor systems.

Database Buffer Cache : 儲存從資料檔案中讀取的資料塊 , 使用者程式可共享 。
邏輯的分為多個子段 , 以便減少多使用者之間的競爭

[@more@]

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

相關文章