Home > Technical Papers/Books >

  Investigating the Multiple Buffer Pool Feature of Oracle8 (mar-00)
 
 
Our Price: Free


Availability: Available for download now
Product Code: BP1

Description
 
The Oracle buffer cache is critical to obtaining optimal database performance. Prior to Oracle8, there were very few tuning options for the buffer cache other than assigning buffers using the DB_BLOCK_BUFFERS initialization parameter. In most cases, the LRU algorithm governing the buffer cache works quite well, no other tuning is required. However, certain data access patterns have been identified that could benefit from alternative buffer aging algorithms. Oracle8 allows the buffer cache to be divided into up to three separate buffer pools to accommodate multiple cache management strategies and assignment of objects to specific buffer pools. These new cache areas are known as the DEFAULT, RECYCLE and KEEP buffer pools.

This paper presents results of preliminary investigations into this new and little-utilized feature of Oracle8, including some experimental evidence that it can provide significant performance benefits under the right circumstances.

In addition, the paper discusses some Oracle8i enhancements to the buffer cache and presents test results of the midpoint insertion algorithms introduced in Oracle8i.
 


Browse for more products in the same category as this item:

Technical Papers/Books


Scalability Models Spreadsheet (1a, 13-April-07) Free
Index Organized Tables -- When should they be used? (April-2002) Free
WebLoad - Load Generator (1h 19-April-05) Free
Basic CPU Forecasting Excel Workbook (1b, 21-October-2007) Free
All About Oracle Database Fragmentation (June-01) Free
Multiple Linear Regression Analysis Template (2g 12-April-07) Free
All About Oracle's Touch-Count Data Block Buffer Algorithm (Jan 2004) Free
Oracle Performance Firefighting Book in *PDF* (OraPub) $39.95
Erlang-C Mathematics in Perl (1a,Jan 2007) Free