Home » RDBMS Server » Server Administration » Data Cache
Data Cache [message #249056] Tue, 03 July 2007 03:28 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi,

what is the difference between db_16k_cache_size and db_block_buffers?
my data_block_size is 16k

Thanks,
Shahnaz.
Re: Data Cache [message #249060 is a reply to message #249056] Tue, 03 July 2007 03:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't use db_16k_cache_size if your block size is 16K.
db_nk_cache_size is for non standard block size.

Btw, don't use db_block_buffers, use db_cache_size. Or better use SGA_TARGET.

Regards
Michel
Re: Data Cache [message #249329 is a reply to message #249060] Wed, 04 July 2007 01:58 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks Michel,
Please let me know what is that non standard block size?
Is 16k is standard one? why we have this parameter...(db_nk_cache_size )

Thanks.
Re: Data Cache [message #249338 is a reply to message #249329] Wed, 04 July 2007 02:19 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A non standard block is one that is different from the SYSTEM tablespace block size (also known as database block size).

Regards
Michel
Previous Topic: Connectiong as sysdba
Next Topic: sga documentation
Goto Forum:
  


Current Time: Mon Dec 05 23:49:46 CST 2016

Total time taken to generate the page: 0.09287 seconds