Negative Unaccounted-for
Analyzing negative unaccounted-for in an Oracle SQL extended trace file profile with DTrace. Continue Reading
DTrace
DTrace
Database Call CPU Instrumentation
Exploring Oracle database instrumentation internals with DTrace Continue Reading
Tracking Wait Events with DTrace
Measuring Oracle database wait event durations with DTrace Continue Reading
Event Propagation in Oracle 12.2
Troubleshooting event propagation in Oracle 12.2 Continue Reading
Debugging Session Creation
Attaching gdb to a dedicated process immediately after forking Continue Reading
Large TCHK Allocations in Shared Pool
Large TCHK allocations in shared pool caused by create table as select Continue Reading
Large Memory Allocations due to Query Parsing
Troubleshooting high PGA memory allocations which escalated in ORA-04036 error. High memory consuption was related to a parsing problem. Continue Reading
Solaris 11.3 Hangs Because of Kernel Object Manager
The blog post describes a hanging issue which occurs after upgrading to Solaris 11.3. The problem is caused by the new kernel memory allocation mechanism. Continue Reading
Comparing Latency on Emulex and QLogic HBA Driver
The blog post describes the implementation differences between Emulex and HBA drivers which are relevant for latency. Continue Reading
DTrace: Tracing Specific Kernel Threads
The blog post explains how to trace threads based on the first procedure on the stack. Continue Reading