| |
GeekInterview.com > Interview Questions > Oracle > System Architecture
| Print | |
Question: What do Database Buffers contain ?
Answer: Database buffers store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk. |
| February 02, 2009 08:41:26 |
#3 |
| taya_ronak |
Member Since: November 2008 Total Comments: 8 |
RE: What do Database Buffers contain ?
|
Database buffer contains the data which server process reads recently from disk.
Database buffer may have three parts:
1. free buffer
2. dirty buffer
3. pinned buffer
Free buffer area is free to be used to store data.
Dirty buffer area contains the data which is updated since read from disk, but not written to the disk till now.
Pinned buffer is a area where processing on specific data for current transaction is going on.
Database buffer may be of three types:
1. keep
2. recycle
3. default
Database buffer may be divided into five different block size buffers:
2k,4k,8k,16k,32k and 64k also but supported by most of the servers (HP, IBM AIX, SOLARIS 10) |
| |
Back To Question | |
