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
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
Underscoring the Magical World of Oracle Database’s Hidden Parameters
I’ll just start out with the usual disclaimer about not setting Oracle’s hidden parameters (that start with an underscore) in a production environment without specific
