Great paper. Learned about the hash table, hash buckets, chains and buffer
headers. I hope the structure is still applicable in 12c, as Mladen has
said.
Anyway, based on the paper, I started searching on ways to reduce logical
IOs. Any pointers on that are welcome too.
On Mon, Apr 2, 2018 at 10:14 AM, Cary Millsap <cary.millsap@xxxxxxxxxxxx>
wrote:
https://method-r.com/2013/02/19/why-you-should-focus-on-
lios-instead-of-pios/
Cary Millsap
Method R Corporation
Author of *Optimizing Oracle Performance <http://amzn.to/OM0q75>* and *The
Method R Guide to Mastering Oracle Trace Data, 2nd edition
<http://amzn.to/1U7q8X1>*
On Sat, Mar 31, 2018 at 12:57 PM, Orlando L <oralrnr@xxxxxxxxx> wrote:
HI
I am reading a book on internals. It talks about Hash latch, hash bucket,
hash chain, buffer header etc and contention for those things. I somewhat
understand what a latch is, but do not know what a 'bucket', 'chain', are.
Is there a paper that explains them in detail at a basic level. thanks.
Orlando.