DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003

    Multi-Part Buffer Pool

    Not quite, a "how to" question, but I'm interested in knowing or having someone describe or show me an example of when a company or DBA would setup and use the Multi-Part Buffer Pool. I understand the purpose, but looking for something a little more concrete. Thanks in advance.

  2. #2
    By multi-part buffer pool, are you talking about the DEFAULT, KEEP and RECYCLE pool?

    I would certainly use the KEEP pool for any small table that was rarely altered and often queried. For example a table that just had descriptions for codes, where existing codes are rarely changed would be a good candidate.

    Recycle is for all that data that is probably never going to be looked at again. Example of tables like that is perhaps ATM transaction logs where the data is very rarely looked at.


  3. #3
    Join Date
    Jun 2000
    or you are interested in Oracle 9i's
    n can be 2,4,8,16,32?

    If this is the case, here is an example (assuming your db_block_size
    is not 16K):

    alter system set db_16k_cache_size=8M
    create tablespace test_tbs blocksize 16K;

    You can then create segments on test_tbs.

    Two reason I think of it:
    1: different tablespaces/tables use different block size (DSS and OLTP hybrid)
    2: transportable TBS

  4. #4
    Join Date
    Aug 2003
    Thanks guys. I see.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.