On Oracle
Tuesday, February 25, 2020
Cache Buffer Chains Latch Contention Case Study-2: Reverse Primary Key Index
›
Continue with previous Blog: Cache Buffer Chains Latch Contention Case Study-1: Reverse Key Index , now we are going to make the second Cas...
Thursday, February 20, 2020
Cache Buffer Chains Latch Contention Case Study-1: Reverse Key Index
›
In Oracle Database, if a reverse key index is heavily accessed by many concurrent sessions, a minor change on the index can perturb whole sy...
Wednesday, January 29, 2020
Oracle Unique Index Non-Consistency Read with RowCR
›
RowCR is an optimization to avoid constructing a CR block if the unique index accessed row is not in an uncommitted transaction. If a row is...
‹
›
Home
View web version