A crashed process can leave a dead transaction behind. Generally, SMON is the one who’ll be rolling it back. Under certain circumstances, though, a server process might lend a helping hand. That’s exactly the scenario we’ll be focusing on. Continue Reading
Analyzing negative unaccounted-for in an Oracle SQL extended trace file profile with DTrace. Continue Reading
Exploring Oracle database instrumentation internals with DTrace Continue Reading
Measuring Oracle database wait event durations with DTrace Continue Reading
Troubleshooting event propagation in Oracle 12.2 Continue Reading
Attaching gdb to a dedicated process immediately after forking Continue Reading
Large TCHK allocations in shared pool caused by create table as select Continue Reading
Analyzing Emulex HBA driver performance with DTrace Continue Reading
Troubleshooting high PGA memory allocations which escalated in ORA-04036 error. High memory consuption was related to a parsing problem. Continue Reading
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