Which configuration could have enabled the block selection of 16 KB?

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?

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

Explanation:
DB_16K_CACHE_SIZE parameter used to specify size of cache in 16K buffers i.e. other than
default size specified by using DB_BLOCK_SIZE. This can be used only when DB_BLOCK_SIZE
is not set 16384. Do not set this parameter value to zero if any tablespace has block size as 16KB.
This parameter can be set only when operating system specific minimum block size not restricted
greater than 4KB.



Leave a Reply 0

Your email address will not be published. Required fields are marked *