Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    36

    Unanswered: Strategy for Bufferpool

    Is there a identification strategy for candidates with 4K buffer pool to be moved to a bigger buffer pools like 16k, 32k.

    Regards
    sahana

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    If you're going to create a tablespace with the page size larger than 4K (tablespace page size and bufferpool page size must be the same)

  3. #3
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    For each table ask yourself:
    - is this row going to fit in the page?
    - okay, there are x rows stored in 1 page. All I/O is page-based so I might read (and store in the bufferpool) more rows than I actually require with this specific SQL. Is this behaviour benificial for me?
    if OLTP
    then the answer might be NO
    else the answer might be YES
    end-if

Posting Permissions

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