Oracle Database
An object-level view helps identify which tables are involved in current transactions. It does not by itself show a complete row-level blocking chain.
Sessions, Locks & Transactions2 min read
Read article : Map transaction locks to Oracle objects
Oracle Database
A serializable transaction can fail when concurrent committed changes conflict with its view of data. This is an application transaction-design issue, not a corrupted block.
Sessions, Locks & Transactions2 min read
Read article : ORA-08177: handle serializable transaction conflicts correctly
Oracle Database
An interrupted distributed commit can leave a transaction holding resources until its outcome is resolved. Gather the transaction identifier from the error.
Sessions, Locks & Transactions1 min read
Read article : ORA-01591: inspect an in-doubt distributed transaction
Oracle Database
An expected savepoint may no longer exist after a commit, full rollback or implicit DDL boundary. Capture the operation sequence rather than only the final rollback error.
Sessions, Locks & Transactions2 min read
Read article : Investigate a rollback-to-savepoint failure in application code
Oracle Database
A slow system needs a shortlist of statements consuming time, with execution count kept in view. Cached totals are not a historical workload report.
SQL Performance & Memory2 min read
Read article : Find cached SQL with high total elapsed time
Oracle Database
Excessive logical reads can consume CPU even when storage latency is low. Inspect per-child buffer gets with execution counts.
SQL Performance & Memory2 min read
Read article : Find logical-read-heavy Oracle SQL
Oracle Database
Slow read-heavy work may reflect a large intended scan, poor access path or storage latency. Start by identifying the cached statements involved.
SQL Performance & Memory2 min read
Read article : Inspect SQL with high physical-read totals
Oracle Database
A hypothetical plan may differ from the one the application executed. Display the correct cached child cursor when investigating a regression.
SQL Performance & Memory1 min read
Read article : Inspect a cached execution plan without running EXPLAIN PLAN
Oracle Database
A single SQL ID can have many children because its executions cannot share one cursor environment. Collect the mismatch reasons before changing caches.
SQL Performance & Memory1 min read
Read article : Investigate many child cursors for one SQL statement
Oracle Database
A parse storm can increase CPU and shared-pool pressure. Capture related counters twice rather than diagnosing from one lifetime total.
SQL Performance & Memory1 min read
Read article : Measure Oracle parse activity as interval deltas
Oracle Database
An application may issue nearly identical statements with values embedded in the text, reducing reuse and increasing parsing work.
SQL Performance & Memory2 min read
Read article : Detect many literal variants of Oracle SQL
Oracle Database
An optimizer can estimate poorly when statistics no longer represent the data. Inspect relevant table and partition statistics before gathering everything.
SQL Performance & Memory1 min read
Read article : Check optimizer statistics for the actual table and partition