In most of the environments I work in, ETL is a necessary evil: extract the information from one or more OLTP tables and insert it
Exadata HCC Query Low: My New Best Friend
Is Swiss Cheese That Bad for your Database? HCC (Hybrid Columnar Compression) has been a feature of Oracle Exadata since the beginning; its four variations
Oracle Exadata Offloading Anomalies: How Much is DML a Factor?
I was testing a few of the functions identified in V$SQLFN_METADATA to see if some of the REGEXP-related functions were offloadable (they are!) and the
Exadata In-Memory Column Store with INMEMORY_FORCE: The Sequel
In a previous blog post, I showed how using flash storage on Exadata can extend the Oracle in-memory capacity by using flash storage in conjunction
Finding Non-Existent Time Zone Dates the Exadata Way
Exadata features save the day for me more often than not, but it’s also the built-in features of Oracle Database that come to the rescue
Exadata In-Memory Column Store and INMEMORY_FORCE on OCI
While testing the In-Memory feature extensions at the Exadata storage level, I thought I was going to hit a limitation that would prevent a full