oracle DB_FILE_MULTIBLOCK_READ_COUNT
来源:互联网 发布:采购数据分析 编辑:程序博客网 时间:2024/06/07 19:43
oracle 官方文档:http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams047.htm
DB_FILE_MULTIBLOCK_READ_COUNT
ALTER SESSION
, ALTER SYSTEM
Range of valuesOperating system-dependentBasicNoDB_FILE_MULTIBLOCK_READ_COUNT
is one of the parameters you can use to minimize I/O during table scans. It specifies the maximum number of blocks read in one I/O operation during a sequential scan. The total number of I/Os needed to perform a full table scan depends on such factors as the size of the table, the multiblock read count, and whether parallel execution is being utilized for the operation.
As of Oracle Database 10g release 2, the default value of this parameter is a value that corresponds to the maximum I/O size that can be performed efficiently. This value is platform-dependent and is 1MB for most platforms.Because the parameter is expressed in blocks, it will be set to a value that is equal to the maximum I/O size that can be performed efficiently divided by the standard block size. Note that if the number of sessions is extremely large the multiblock read count value is decreased to avoid the buffer cache getting flooded with too many table scan buffers.
Even though the default value may be a large value, the optimizer will not favor large plans if you do not set this parameter. It would do so only if you explicitly set this parameter to a large value.
Online transaction processing (OLTP) and batch environments typically have values in the range of 4 to 16 for this parameter. DSS and data warehouse environments tend to benefit most from maximizing the value of this parameter. The optimizer is more likely to choose a full table scan over an index if the value of this parameter is high.
The maximum value is the operating system's maximum I/O size expressed as Oracle blocks ((max I/O size)/DB_BLOCK_SIZE
). If you set this parameter to a value greater than the maximum, Oracle uses the maximum.
SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdPL/SQL Release 10.2.0.1.0 - ProductionCORE 10.2.0.1.0 ProductionTNS for 32-bit Windows: Version 10.2.0.1.0 - ProductionNLSRTL Version 10.2.0.1.0 - ProductionSQL>
SQL> select name,type,value,isdefault from v$parameter where name='db_file_multiblock_read_count';NAME TYPE VALUE ISDEFAULT------------------------------ ---------- -------------------- --------------------db_file_multiblock_read_count ########## 16 FALSESQL>
- oracle DB_FILE_MULTIBLOCK_READ_COUNT
- oracle中的db_file_multiblock_read_count参数
- Why Change the Oracle DB_FILE_MULTIBLOCK_READ_COUNT?
- db_file_multiblock_read_count
- 使用 db_file_multiblock_read_count测试Oracle在不同系统中的IO能力
- oracle DB_FILE_MULTIBLOCK_READ_COUNT参数和区间尺寸的设置
- 通过案例学调优之--Oracle参数(db_file_multiblock_read_count)
- db_file_multiblock_read_count 的自动调整
- stripe /block size/db_file_multiblock_read_count
- db_file_multiblock_read_count 的自动调整
- db_file_multiblock_read_count的研究
- db_file_multiblock_read_count参数设置取值测试
- 考量参数DB_FILE_MULTIBLOCK_READ_COUNT的脚本
- 关于db_file_multiblock_read_count的物理读
- 关于db_file_multiblock_read_count的物理读
- 关于参数db_file_multiblock_read_count与_db_file_optimizer_read_count
- 讨论一下DB_FILE_MULTIBLOCK_READ_COUNT参数和区间尺寸的设置问题
- How is Parameter DB_FILE_MULTIBLOCK_READ_COUNT Calculated? (Doc ID 1398860.1)
- Google Custom Search API使用详解
- Linux(Fedora)下mysql安装、卸载、jdbc驱动安装
- C++ 多线程并发控制——互斥锁 pthread_mutex
- 【BZOJ】【P1051】【HAOI2006】【受欢迎的牛】【强连通分量】
- 创建表空间语句详解
- oracle DB_FILE_MULTIBLOCK_READ_COUNT
- FFT原理及实现
- 聚类分析(五)基于密度的聚类算法 — DBSCAN
- HighCharts之2D回归直线的散点
- MyEclipse10中文注释太小
- List,数组,map,set 相互转化
- Niblack算法和OTSU算法的实现
- Hibernate4获取session
- 浅谈响应式布局