Guidelines for DB_BLOCK_SIZE
发表于2004/11/4 11:14:00 772人阅读
To give some guidelines for the setting of the parameter DB_BLOCK_SIZE.
SCOPE & APPLICATION
To increase understanding of the issues related to the setting of the
Guidelines for DB_BLOCK_SIZE:
The setting of the parameter DB_BLOCK_SIZE depends on the type of data you are
looking at, the application and implementation.
The main considerations are as follows:
1. Balance with Operating System Block Size
For good performance, Oracle Block size should be made equal to or a
multiple of the operating system blocksize. If you do not do this then the
operating system may be doing many reads and writes to process Oracle
blocks. This is inefficient and wastes CPU cycles.
If your rows are small and you use a large blocksize, when you fetch a block
you may get lots of rows that you are (probably) not interested in. The
operating system has to do more work to get the row(s) that you are
On the other hand, if you were interested in the extra rows then altough
this may waste CPU on the initial fetch then you have already loaded the
block containing the rows in to the buffer cache.
Larger blocks also mean more rows cached for the same number of
DB_BLOCK_BUFFERS (taking up more memory).
2. Index Branches
Larger Oracle block sizes may give better index balancing with more rows in
3. Locking/Block Contention
Remember that with more processes looking at the same block you are more
likely to get block contention.
4. Row Length
If your rows are comparatively large then you may need a large blocksize to
(possibly) prevent chaining.
wanghui5767260 2014-09-04 12:22 2602
Android Code Style Guidelines for Contributors
AnnaLoad 2015-10-25 12:18 450
Style guidelines for C++
a130737 2014-06-25 22:19 579
jijibbbb 2010-04-26 16:30 1320
《iOS Human Interface Guidelines》——Designing for iOS
Cloudox_ 2015-09-24 17:21 1110
Coding GuideLines For Cocoa
u014615615 2016-11-02 10:54 271
Guidelines for Oral Presentations
aquathinker 2011-12-06 09:41 527
Android开源项目-编码风格规范-Code Style Guidelines for Contributors
geniuseoe2012 2012-08-23 11:30 5504