Re: Index Contention / Sequence Caching

From: Riyaj Shamsudeen <>
Date: Mon, 17 Mar 2014 09:27:02 -0700
Message-ID: <>

Hello Stephen
  In addition to Houri (and JL) has pointed out already, effect of a reverse key index is, to spread the values among ALL the leaf blocks of the index. So, the buffer cache(s) can be polluted with all these leaf blocks potentially. This problem is magnified if the number of leaf block in the index is huge.


Riyaj Shamsudeen
Principal DBA,
Ora!nternals - - Specialists in Performance, RAC and EBS
Blog: Oracle ACE Director and OakTable member <>

Co-author of the books: Expert Oracle
Practices<> , Pro Oracle SQL, <>

RAC Practices 12c. <> Expert PL/SQL practices <>


Received on Mon Mar 17 2014 - 17:27:02 CET

Original text of this message