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
Tag: Oracle Database
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
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
Underscoring the Magical World of Oracle Database’s Hidden Parameters: Part 2
As you might remember from Part 1, I was (and still am) struggling with a strange bug in Oracle Database 18c that sometimes swaps column
When is an Oracle Database NUMBER Column Not a Number (NaN)?
When it holds an infinite number, since “infinity” is not a number. Oracle Database OCM Franck Pachot reminded me recently about the floating point literals
All Kinds of Exadata Stuff 