first_rows Optimization in Uncorrelated Subqueries
Suboptimal execution plans can be generated for uncorrelated subqueries involved in set operations. Continue Reading
Month: June 2018
Dead Transaction Rollback
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
Negative Unaccounted-for (2) – Pitfalls
Find out which information in SQL Monitor report and ASH becomes unreliable in the case of a negative unaccounted-for. Continue Reading