Oracle 18c Scalable Sequences
- Posted by Gavin Soorma
- On June 8, 2019
- 1 Comments
Index block contention is very common databases with high insert activity and it’s especially common on tables that have monotonically increasing key values typically generated via a sequence. Oracle B-tree indexes are “right-handed” and the right-hand leaf nodes of the B-tree contain the highest key which is located in the lowest tree level. Index leaf […]
Read More