Search Training and Resources Training Schedule FORECASTING Publications Tools Quick Links About OraPub About OraPub Training Testimonials Class Pics OraPub Consulting Forecasting Forum Speaker Request About

Home > Publications >   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: Publications Investigating the Multiple Buffer Pool Feature of Oracle8 (mar-00) Free

	OraPub		About Us  Privacy Policy  Send Us Feedback Company Info | Advertising | Product Index | Category Index | Help | Terms of Use Copyright © 2005 OraPub, Inc.. All Rights Reserved. Portland, Oregon USA - tel:+1.503.636.0228 Online Store Builder Powered By Volusion.