In Part 1 of this post, I pointed out the key difference between two different types of Oracle chained rows — chained rows that were
Tag: Exadata
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
An Oracle Data Dictionary Anomaly: VARCHAR2, CLOB, and Exadata
A.K.A. The Serendipitous Nature of Debugging ORA- Errors There is usually an Exadata angle to my posts, and this one won’t disappoint. It started out
RMAN on Oracle Database 19c on Exadata: Performance Tradeoffs
Oracle’s RMAN (Recovery Manager) tool is the Oracle-recommended tool to create and manage your Oracle Database backups. It’s not clear, however, which RMAN settings are
What’s the deal with Exadata HCC and UPDATEs anyway?
Oracle Exadata users have long known that the available compression levels for HCC provide both extreme compression (lower storage footprint) and in many cases improved
