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!

"DB_nK_CACHE_SIZE"

KeenOnOracleJun 5 2007 — edited Jun 5 2007

hello everyone...

I'm implementing a non-standard database block size for a DSS tablespace in my OLTP database...

I have the following doubt:

Is the value of alter system set "DB_16K_CACHE_SIZE" = [ k| m| g] included on the SGA_MAXMS_ZE ? for example:

I have 744MB of buffer cache, but the value for those 16k datafiles would fit on 100M... Do I have to subtract this value from the 744MB ???

How does it work ? the reference note on metalink isn't so cleary to me...

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2007

Added on Jun 5 2007

#general-database-discussions

7 comments

386 views