Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Relationship between db_block_size Vs db_cache_size.

GTS (DBA)Jan 5 2014 — edited Jan 9 2014

Good morning all ;

DB_CACHE_SIZE specifies the cache for the default block size. Cannot explicitly specify a cache for that.

For example if your default block size is 8K then you cannot specify DB_8K_CACHE_SIZE.


From  above comments ,


In 10g oracle database , what's the close relationship between  db_block_size and db_cache_size.

I read 10g oracle official documents. Not clear to understand.

REF_LINK : http://docs.oracle.com/cd/B19306_01/server.102/b14220/memory.htm


Can anyone provide show me little demo with simple example ?  - If possible , clean information also.


Thanks in advance.


This post has been answered by Aman.... on Jan 8 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2014
Added on Jan 5 2014
16 comments
1,253 views