Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 11:39 AM
p175
Guest
 
Posts: n/a
Default Bufferpools

Can anyone please explain in english the difference between blocked and
non-pages in a bufferpool.

What would be a typical ration one would use for say a 100,000 4kb size
BP. 50/50 blocked v unblocked ?

  #2  
Old November 12th, 2005, 11:39 AM
m0002a@yahoo.com
Guest
 
Posts: n/a
Default Re: Bufferpools

Applications that employ sequential prefetching can benefit from
improved performance through the use of blockbased buffer pools, which
allow blocks of contiguous pages to be moved into contiguous portions
of memory. Keep in mind that block-based pages will be wasted if your
application doesn't perform sequential prefetching.

Typically, SQL statements that do table scans large tables will do
sequential prefetching Blockbased buffer pool pages should not be used
for OLTP applications or whenever sequential prefetch is not common.

Where you have large data warehouse tables that are often accessed via
full table scans, you can place those tables in tablespaces that are
specifically linked to bufferpools with block based pages.

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,174 network members.