Re: buffer cache structure in SGA

From: Orlando L <oralrnr_at_gmail.com>
Date: Mon, 2 Apr 2018 19:07:39 -0500
Message-ID: <CAL8Ae75PeeP2g-yQEs2aU=3cqtoP_8UgQPmjHTfbEqto09WZNA_at_mail.gmail.com>



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_at_method-r.com> 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_at_gmail.com> 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.
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 03 2018 - 02:07:39 CEST

Original text of this message