On Oracle
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...
Cache Buffer Chains Latch Contention Case Study-3: index root block Modification Blocking
›
Continuing from previous Blog: Cache Buffer Chains Latch Contention Case Study-2: Reverse Primary Key Index , we will look index root (...
‹
›
Home
View web version