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
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
