OCP 1Z0 052 147

来源:互联网 发布:用循环给二维数组赋值 编辑:程序博客网 时间:2024/05/18 15:05
147. View the Exhibit. 

You want  to  create  a  tablespace  to  contain  objects with  block  size  16  KB.  But  while  configuring  the 
storage you find that the block size that you can provide is only 8 KB.  
Which configuration could have enabled the block selection of 16 KB? 
A.choosing the extent allocation type to uniform 
B.choosing the Segment Space Management option to manual 
C.setting autoextension on for the data file mentioned for the tablespace 
D.setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value 

Answer: D   


http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams046.htm#REFRN10027

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 whenDB_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.


0 0
原创粉丝点击