Guidelines for DB_BLOCK_SIZE

原创 2004年11月04日 11:14:00

To give some guidelines for the setting of the parameter DB_BLOCK_SIZE.


To increase understanding of the issues related to the setting of the

parameter DB_BLOCK_SIZE.

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

interested in.

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

each branch.

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.


SQL>show parameter db_block_size NAME TYPE VALUE ------------------------------------ ----------- --...
  • victory_xing126
  • victory_xing126
  • 2015年04月19日 08:38
  • 1396


关于对db_block_gets的理解与实验 实验 一、 自己手动创建的小表 创建一个区大小为  40k  SYS@ORCL>show parameter db_block...
  • wanghui5767260
  • wanghui5767260
  • 2014年09月04日 12:22
  • 2782


from 在window环境下安装oracle 9i的时候遇到报的是db_block...
  • u010820135
  • u010820135
  • 2017年01月10日 22:41
  • 309

iOS:Cocoa编码规范 -[译]Coding Guidelines for Cocoa

  • houseq
  • houseq
  • 2014年06月01日 13:52
  • 2008

《iOS Human Interface Guidelines》——Color and Typography

本文翻译自苹果官方文档《iOS Human Interface Guidelines》——Color and Typography,讲解颜色和排版...
  • Cloudox_
  • Cloudox_
  • 2015年11月12日 19:38
  • 885

Alibaba Java Coding Guidelines使用

前言 版权归作者所有,如有转发,请注明文章出处: 背景阿里巴巴于10月14号在杭州云栖大会上,正式发布《阿里巴巴Java...
  • liduolp
  • liduolp
  • 2017年10月17日 12:15
  • 517

Framework Design Guidelines笔记

Framework Design Guidelines是微软对于好api设计的一个指导,当然针对的是.NET,其中对于Android/Java有裨益的记录一下。命名大小写 首字母大写:class、in...
  • pouloghost
  • pouloghost
  • 2017年03月02日 20:51
  • 210

《iOS 7 Human Interface Guidelines中文版》读书笔记(1)

这个是官网:iOS Human Interface Guidelines为iOS而设计(1)充分利用整个屏幕。 (2)尽量减少视觉修饰和拟物化的使用,UI面板、渐变和阴影有时会让UI元素显得很厚重。...
  • yyh3663477
  • yyh3663477
  • 2017年01月09日 10:19
  • 221

《iOS Human Interface Guidelines》——Apple Pay

本文翻译自苹果官方文档《iOS Human Interface Guidelines》——Apple Pay,讲解Apple Pay相关内容...
  • Cloudox_
  • Cloudox_
  • 2015年12月20日 16:04
  • 1418

Swift 3.0 API Design Guidelines

1, 这是官方版本编码设计规范 2, Github: Spec...
  • WUYANYANstrong
  • WUYANYANstrong
  • 2016年12月16日 09:18
  • 454
您举报文章:Guidelines for DB_BLOCK_SIZE