orapub.com
Home
View Cart
My Account
Help
Training
Register Now!
Schedule
About OraPub Training
Class Pics & Video
Quick Links
Craig's Blog
Technical Papers/Books
Tools / Products
Consulting
Speaker Request
About OraPub
Corporate Giving (for real)
Search OraPub:
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