本文详细解释了DB_BLOCK_SIZE参数的作用，并提供了在不同条件下的优化建议，以提高磁盘IO效率和数据存储效率。
DB_BLOCK_SIZE Initialization
Parameter
<wbr><wbr> The most commonly used block size should be picked as the standard block size. In many cases, this is the only block size that you need to specify. Typically, DB_BLOCK_SIZE<wbr> is set to either 4K or 8K. If you<wbr> do not set a value for this parameter, the default data block size is operating system specific, which is generally adequate. You cannot change the block size after database creation except by re-creating the database. If the database block size is different from the operating system block size, ensure that the database block size is a multiple of the operating system block size. For example, if your operating system block size is 2K (2048 bytes), the following setting for the DB_BLOCK_SIZE<wbr> initialization parameter is valid:<br> DB_BLOCK_SIZE=4096<br><wbr><wbr><br><wbr><wbr> A larger data block size provides greater efficiency in disk and memory I/O (access<br> (使用较大的db_block_size对于磁盘io的提高有较大的好处)<br> and storage of data). Therefore, consider specifying a block size larger than your<br> operating system block size if the following conditions exist:<br> ■ Oracle Database is on a large computer system with a large amount of memory and fast disk drives. For example, databases controlled by mainframe computers with vast hardware resources typically use a data block size of 4K or greater.<br> ■ The operating system that runs Oracle Database uses a small operating system block size. For example, if the operating system block size is 1K and the default data block size matches this, the database may be performing an excessive amount of disk I/O during normal operation. For best performance in this case, a database block should consist of multiple operating system blocks.<br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
<wbr><wbr> The most commonly used block size should be picked as the standard block size. In many cases, this is the only block size that you need to specify. Typically, DB_BLOCK_SIZE<wbr> is set to either 4K or 8K. If you<wbr> do not set a value for this parameter, the default data block size is operating system specific, which is generally adequate. You cannot change the block size after database creation except by re-creating the database. If the database block size is different from the operating system block size, ensure that the database block size is a multiple of the operating system block size. For example, if your operating system block size is 2K (2048 bytes), the following setting for the DB_BLOCK_SIZE<wbr> initialization parameter is valid:<br> DB_BLOCK_SIZE=4096<br><wbr><wbr><br><wbr><wbr> A larger data block size provides greater efficiency in disk and memory I/O (access<br> (使用较大的db_block_size对于磁盘io的提高有较大的好处)<br> and storage of data). Therefore, consider specifying a block size larger than your<br> operating system block size if the following conditions exist:<br> ■ Oracle Database is on a large computer system with a large amount of memory and fast disk drives. For example, databases controlled by mainframe computers with vast hardware resources typically use a data block size of 4K or greater.<br> ■ The operating system that runs Oracle Database uses a small operating system block size. For example, if the operating system block size is 1K and the default data block size matches this, the database may be performing an excessive amount of disk I/O during normal operation. For best performance in this case, a database block should consist of multiple operating system blocks.<br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
扫一扫
4048
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
