On databases with multiple DBAs and a not too rigorous change control policy, database parameters get changed and it’s not always clear who made the
In “Case” you missed it: Part 1
And you probably didn’t miss it, since I just posted it. A question came up a couple times recently, “Do WHERE clauses with CASE expressions
Indexes are Still a “Thing” on Exadata!
Even with Oracle Database 19c and its automatic indexing features on Exadata, and especially on the Oracle Autonomous Database, people still come up to me
Don’t They Mean Physical Distancing?
Yes, the COVID-19 pandemic is a serious health crisis, and it’s the most serious health crisis I’ve lived through my entire life, but I was
What's In A Name? Oracle SQL Developer Can Help You Find Out
What’s in a query block name, that is! I was trying to figure out the intricacies of how the Oracle optimizer works with set operators
Not All Chained Rows Are Created Equal: Exadata to the Rescue Part 2
In Part 1 of this post, I pointed out the key difference between two different types of Oracle chained rows — chained rows that were
