Re: Cache hash chains
From: Stefan Koehler <contact_at_soocs.de>
Date: Wed, 4 Mar 2015 12:24:17 +0100 (CET)
Message-ID: <1630650991.228608.1425468257893.JavaMail.open-xchange_at_app03.ox.hosteurope.de>
Hi Paul,
in addition to Jonathan's reply - the hash bucket / chain and its related buffer headers is not necessarily linked to one working data set. The hashing mechanism for placing and locating buffers (headers) is working across working data sets. You can also see that in my blog post example - please check the first or last buffer header (obj 6399 & 8) for verification: http://tinyurl.com/qc7d65h
Date: Wed, 4 Mar 2015 12:24:17 +0100 (CET)
Message-ID: <1630650991.228608.1425468257893.JavaMail.open-xchange_at_app03.ox.hosteurope.de>
Hi Paul,
in addition to Jonathan's reply - the hash bucket / chain and its related buffer headers is not necessarily linked to one working data set. The hashing mechanism for placing and locating buffers (headers) is working across working data sets. You can also see that in my blog post example - please check the first or last buffer header (obj 6399 & 8) for verification: http://tinyurl.com/qc7d65h
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: _at_OracleSK
> Paul Harrison <cure_at_austin.rr.com> hat am 3. März 2015 um 22:50 geschrieben:
>
> Hi Team,
> Why do we have 4 database buffer headers linked to 1 working data set( database buffer cache block )?
>
> Thanks,
> Paul
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 04 2015 - 12:24:17 CET