By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,227 Members | 1,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,227 IT Pros & Developers. It's quick & easy.

Bufferpools

P: n/a
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 ?

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.