Perilous New Undocumented Tracing Feature in Oracle 21c
Database writer performance impaired by sudden debug trace. Continue Reading
redo
A Case Study: How Advanced Queuing and Alerts Prevented Private Strands Usage
A process waiting on an Advanced Queue or alert allocates an in-memory undo buffer and holds it as long as it’s waiting, even when there aren’t any incoming mesages. Many such processes can prevent private strands usage.
Continue Reading
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