Multiple buffer pool
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Multiple buffer pool

  1. #1
    Join Date
    Oct 2001
    Posts
    126
    Does anyone use buffer_pool_keep and buffer_pool_recycle? Do you experience any performance improvement? What is the populatrity of using the multiple buffer pool?

    Susan

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    A book by Donald Burleson ("Oracle Internals") has several chapters related to this subject (the book is a compilation of articles, white papers, etc. from many people). Whether or not to pin packages owned by sys, for example, depends on how you use your database (among other things). Is there a definitive answer? Depends on who you talk to.

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by srlhome00
    Does anyone use buffer_pool_keep and buffer_pool_recycle? Do you experience any performance improvement? What is the populatrity of using the multiple buffer pool?

    Susan
    I use buffer_pool_keep. I find buffer_pool_recycle too messy as a concept. The performance improvements are small.

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    From 8i onwards the database buffer cache is divided into default pool,buffer pool keep,buffer pool recycle.
    Buffer pool keep is basically used to pin blocks which are being used frequently so that they dont get aged out or removed from the database buffer cache by DBWR for want of space in the buffer cache for new block being read.
    Similarly buffer pool recycle is used to pin blocks that are less freqently used so that they dont compet for space with other frequenly used blocks in the database buffer cache.

    regards
    anandkl
    anandkl

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width