关于创建不同大小块的表空间的问题

whtm8868

版本10.2.0.4，我创建了几个不是默认块（8192）大小的表空间，但是是db_nk_cache_size 都是默认的0，sga是默认的自动分配，我现在是要手动为相对应的块大小设置db_nk_cache_size 的值，才能实现每次读更大的块的磁盘读吗，还是自动sga管理会自动实现？

psufnxk2000

DB_nK_CACHE_SIZE (where n = 2, 4, 8, 16, 32) specifies the size of the cache for the nK buffers. You can set this parameter only when DB_BLOCK_SIZE has a value other than nK. For example, if DB_BLOCK_SIZE=4096, then it is illegal to specify the parameter DB_4K_CACHE_SIZE (because the size for the 4 KB block cache is already specified by DB_CACHE_SIZE).

Do not set this parameter to zero if there are any online tablespaces with an nK block size.

Operating system-specific block size restrictions apply. For example, you cannot set DB_32K_CACHE_SIZE if the operating system's maximum block size is less than 32 KB. Also, you cannot set DB_2K_CACHE_SIZE if the minimum block size is greater than 2 KB.

Maclean Liu(刘相兵

SQL> show parameter 16k

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
db_16k_cache_size                    big integer
0
SQL> create tablespace l32k datafile size 10M blocksize 16384;
create tablespace l32k datafile size 10M blocksize 16384
*
第 1 行出现错误:
ORA-29339: 表空间块大小 16384 与配置的块大小不匹配


SQL> alter system set db_16k_cache_size=10M;

系统已更改。

SQL> create tablespace l16k datafile size 10M blocksize 16384;

表空间已创建。


10g ocp要考的内容哦