Fast Retrieval of DYNAMIC_SAMPLING_RESULT Information
Correlating an active dynamic sampling trace with the data dictionary Continue Reading
Author: Nenad Noveljic
Converting HASH_VALUE to SQL_ID
Converting HASH_VALUE to SQL_ID with SQL Continue Reading
SQL for Converting Decimal Integers to Any Base
A single SQL converts unsigned decimal integers to any other base. Continue Reading
first_rows Optimization in Uncorrelated Subqueries
Suboptimal execution plans can be generated for uncorrelated subqueries involved in set operations. Continue Reading
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
Negative Unaccounted-for
Analyzing negative unaccounted-for in an Oracle SQL extended trace file profile with DTrace. Continue Reading
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
Data Redaction and Virtual Columns
Data Redaction limitation in Oracle 12.2 Continue Reading