We have upgraded a database from 8.1.7 to 9.2.

We still have following parameter set for db cache.

db_block_buffers integer 39321
db_block_checking boolean FALSE
db_block_checksum boolean TRUE
db_block_size integer 8192
db_cache_advice string OFF
db_cache_size unknown 0

I am assuming that since we don't have db_cache_size set to a valid value it'll be calculated as db_block_buffers * db_block_size as it was earlier.

Am i correct.Can you please advise.

Deepak


This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.

Oracle LazyDBA home page