Home » RDBMS Server » Server Administration » db_cache_size
db_cache_size [message #260459] Mon, 20 August 2007 00:55 Go to next message
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.


Re: db_cache_size [message #260463 is a reply to message #260459] Mon, 20 August 2007 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Initialization Parameters

Regards
Michel
Re: db_cache_size [message #260874 is a reply to message #260463] Tue, 21 August 2007 03:05 Go to previous message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks Michel.
Previous Topic: Manual Clone DB
Next Topic: Database not opening,error "Block Size small"
Goto Forum:
  


Current Time: Mon Dec 05 19:07:33 CST 2016

Total time taken to generate the page: 0.09885 seconds