Nonstandard Block Sizes (93)

最新推荐文章于 2025-12-17 14:20:19 发布

转载最新推荐文章于 2025-12-17 14:20:19 发布 · 171 阅读

文章标签：

#数据库

本文介绍了如何使用非标准块大小创建表空间的方法，并强调了为不同块大小配置SGA缓冲区的重要性。此外，还讨论了在不同数据库环境中迁移表空间时使用多种块大小的好处。

部署运行你感兴趣的模型镜像

Tablespaces of nonstandard block sizes can be created using the CREATE
TABLESPACE statement and specifying the BLOCKSIZE clause. These nonstandard
block sizes can have any of the following power-of-two values: 2K, 4K, 8K, 16K or 32K.
Platform-specific restrictions regarding the maximum block size apply, so some of
these sizes may not be allowed on some platforms.

To use nonstandard block sizes, you must configure subcaches within the buffer cache
area of the SGA memory for all of the nonstandard block sizes that you intend to use.

The ability to specify multiple block sizes for your database is especially useful if you
are transporting tablespaces between databases. You can, for example, transport a
tablespace that uses a 4K block size from an OLTP environment to a data warehouse
environment that uses a standard block size of 8K.

非标准块值
1. 要使用非标准的块值 , 需要配置非标准块的SGA缓冲区
2. 在数据库之间传输表空间时 , 多样的块值非常有用

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-995936/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-995936/

您可能感兴趣的与本文相关的镜像