Previous Topic: Buffer ManagementNext Topic: How Many Buffers Do You Need?


Planning Database Buffers

Tradeoffs to Consider

Buffers use space in main memory, but reduce the amount of I/O performed on behalf of your applications. You want to choose the optimal buffer attributes to achieve a balance between storage resources and I/O.

Considerations for assigning values to these attributes appear next, beginning with a discussion on how many database buffers to define.