Minimum sga_target
Database won’t start after a hardware/OS change or a database upgrade?
You can monitor critical conditions and prevent unpleasant surprises. Continue Reading
Month: July 2021
Flashback Data Archive DDL Bottleneck
Undocumented flashback data archive internals Continue Reading
Bypassed Subquery Unnesting for Anti Join
Columns instead of constants in the SELECT clause of a NOT EXISTS subquery can lead to bad execution plans. Continue Reading