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
PGA: An Often Underutilized Resource. And . . . Exadata.
I’ve noticed on many customer systems that PGA memory is underutilized. With parameters available since Oracle Database 12c Release 1 (12.1.0.1/2) such as PGA_AGGREGATE_LIMIT, you
Not All Chained Rows are Created Equal: Exadata to the Rescue
Chained rows in a table are generally a “bad thing”, but how bad depends on the type of chained row. Oracle Database contributes to the
A Picture of a Syntax Diagram is Worth 1024 Words
I was moving some interval partitioned tables to a new tablespace and discovered some interesting omissions in the Oracle documentation, but eventually found the answer
