Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Block Space Utilisation Parameters

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

Related Posts Plugin for WordPress, Blogger...

Flag Counter