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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

hash buckets per cache buffer chain latches

OracleGuy777Apr 26 2012 — edited Apr 26 2012

Hi,

I am reading Chapters 4 and 5 of Oracle Core, and I am a bit confused. I am sure the answer is in the book, but as I am still not at an advanced level in Oracle, please bear with me.

What I understand is we can have around 131,000 buckets.
And up to 10g the number of library cache latches was small - maximum of 67.
Therefore, we could have almost 2,000 buckets per library cache latch, yes?

Then on page 111 it says that in 10/11g, the number of buckets per latch seems to be fixed at 32. That's a HUGE change from 2,000 ... or is there something wrong in my understanding?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 24 2012

Added on Apr 26 2012

#general-database-discussions

2 comments

505 views