oracle优化_oracle参数优化--高速缓冲区大小调整

Database Buffer Cache

The database buffer cache, also called the buffer cache, is the memory area that stores copies of data blocks read from data files. A buffer is a main memory address in which the buffer manager temporarily caches a currently or recently used data block. All users concurrently connected to a database instance share access to the buffer cache.

database buffer cache小名buffer cache，它存储从数据文件中读取到的数据块的copies。Buffer是内存中的一个地址，buffer manager会临时的把currently or recently used数据块cache到那里(注意buffer与cache的区别)。同时连接到数据库实例的所有用户都能够访问buffer cache。

---

使用buffer cache有两个目的：

1、Optimize physical I/O(优化物理 I/O)

The database updates data blocks in the cache and stores metadata about the changes in the redo log buffer. After a COMMIT, the database writes the redo buffers to disk but does not immediately write data blocks to disk. Instead, database writer (DBWn) performs lazy writes in th