Let me clarify… in a previous post, I showed some of the arithmetic around some of Oracle’s floating point literals and how that arithmetic didn’t
Tag: Exadata
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
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
