db_file_multiblock_read_count
- Segment headers ard read with single-block reads
- Physical reads never span server extents.
- Blocks already in the buffer cache, except for direct read, are not reread from I/O subsystem.
If the initialization parameter db_file_multiblock_read_count is set to 8, the following
physical reads are performed:
• One single-block read of the segment header (block 1).
• One multiblock read of two blocks (2 and 3). More blocks cannot be read because block 4
is cached.
• One multiblock read of four blocks (from 5 to 8). More blocks cannot be read because
block 9 is cached.
• One multiblock read of six blocks (from 11 to 16). More blocks cannot be read because
block 16 is the last one of the extent.
• One multiblock read of two blocks (17 and 18). More blocks cannot be read because
block 19 is cached.
• One single-block read of block 20. More blocks cannot be read because block 21 is cached.
• One multiblock read of eight blocks (from 22 to 29). More blocks cannot be read because
the initialization parameter db_file_multiblock_read_count is set to 8.
• One multiblock read of three blocks (from 30 to 32).
- 大小: 28.6 KB
分享到:
相关推荐
Oracle init.ora 配置详解 Oracle init.ora 配置详解 Oracle init.ora 配置详解
oracle init.ora 文件据在位置
Oracle Solaris 10 Oracle SolarisTunable Parameters Reference Manual-202
ORACLE9i的INIT参数的详细说明
Oracle Solaris 11 Oracle Solaris Tunable Parameters Reference Manual-182
。。。
oracle_init_20221231-20220926.sql
Oracle Solaris 11.3 Tunable Parameters Reference Manual-198
Oracle Solaris 11.2 Tunable Parameters Reference Manual-186
Oracle Solaris 11.1 Tunable Parameters Reference Manual-192
navicate-jeecg-boot-v1.1-oracle-sys-init,为jeecg-boot-oracle初始化脚本
Oracle 9i Client (Oracle 9i 客户端) 简化版 (不安装Oracle客户端,也可以使用PLSQL Developer 不用安装Oracle客户端也可以使用PLSQL Developer 绿色! 安全! 轻便! 可靠! 1、本软件可作为简单的Oracle9i客户端...
navicate-jeecg-boot-v1.0-oracle-sys-init,为jeecg-boot框架oracle初始化脚本。
Oracle Solaris 9 Solaris Tunable Parameters Reference Manual-174
# This is a sample agent init file that contains the HS parameters that are # needed for the Transparent Gateway for SQL Server # # HS init parameters # HS_FDS_CONNECT_INFO="SERVER=192.168.100.102;...
oracle_课件oracle_课件oracle_课件oracle_课件oracle_课件oracle_课件oracle_课件oracle_课件oracle_课件oracle_课件oracle_课件
oracle 数据库oracle 数据库oracle 数据库oracle 数据库oracle 数据库oracle 数据库oracle 数据库
oracle 9i所有版本最新下载链接 直接迅雷下载 Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP ...
Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典Oracle宝典...