On Oracle
Tuesday, May 26, 2020
12cR2 Index Usage Tracking Manual Flushing
›
Oracle 12.2 introduced index usage tracking to replace the previous index monitoring. Instead of only telling if an index is used (DBA_OBJE...
Monday, May 25, 2020
One "row cache lock" Test Case
›
"row cache lock" is an Oracle locking mechanisms to protect disk layer persistent data (e.g. 'sys.user$'), whereas "l...
Saturday, May 2, 2020
ORA-600 [504] LATCH HIERARCHY ERROR Deadlock
›
Latches in Oracle are positioned in different levels (15 levels from 0 to 16 in Oracle 12c and 19c) in order to enforce ordering rules. If n...
Tuesday, April 7, 2020
Index Service ITL and Recursive Transaction
›
Continuing with previous Blog: Cache Buffer Chains Latch Contention Case Study-1: Reverse Key Index Index Block Split Point D...
Index Block Split Point Distribution
›
Continuing with previous Blog: Cache Buffer Chains Latch Contention Case Study-1: Reverse Key Index , this Blog will look the split point d...
‹
›
Home
View web version