| db_cache_size [message #260459] |
Mon, 20 August 2007 00:55  |
shahnazurs
Messages: 240
Registered: June 2005
Location: India
|
Senior Member |
|
|
Hi,
I can see some of DB configuration parameters as
db_cache_size=0
db_keep_cache_size=0
db_recycle_cache_size=0
db_nk_cache_size=0
where n is 2 4 8 16 32
db_block_buffer=12000
db_block_size=16k
Hope default block size is 2k, why the parameters with 0 values are not been used.
In which scenario we have to use those parameters.
and also please explain me what is the purpose of
db_file_multiblock_read_count parameters
DB is Oracle 9i release 2
Thanks.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
