inittrans - 1
maxtrans - 255
pctfree - 10%
pctused - 40%
In version 9i, oracle has introduced the concept of different block sizes likes 2k,4k,8k,16k,32k and 64k.
In order to create a tablespace of different block size, we need to set the following init.ora parameter.
db_nk_cache_size
n is an integer(2,4,8,16,32,64)
e.g : db_4k_cache_size = 800M
No comments:
Post a Comment