Lateral View Improvement in Oracle 19c
Suboptimal handling of lateral views has improved in Oracle 19c. Continue Reading
Month: June 2020
Redo Copy Latch Contention 2: MTTR Advisor
MTTR advisor data gathering can cause redo copy latch contention on servers with many CPUs. Checkpoint queue internals. An example of analyzing a compiled function in a proprietary code without disassembling it. Continue Reading
Tracing Latches: Redo Copy Contention
Tracing latches with OS tools, case study: redo copy contention caused by a logon storm Continue Reading