Big Savings on Oracle REDO Via Temp UNDO July 12, 2022 When Oracle introduced version 12.1 of the RDBMS, an interesting new parameter was included:...
Statspack vs. AWR: Wrong number of SQL Executions October 27, 2021 This post is about a Statspack anomaly I discovered while analyzing execution trends of a...
DML by Unique Index Supposedly Affecting Many Rows March 16, 2021 This blog post is based on a real customer case, and illustrates how v$sql reports execution...
Select vs Assign – How To Assign PL/SQL Variables February 8, 2021 Select vs Assign It isn’t unusual to see PL/SQL that contains select columns into variables from...