Sometimes performance on Exadata can be so good that you don’t think there’s a problem! I recently ran into a situation where an Exadata offloaded
Tag: Exadata
IOTs on Oracle Database 23c: What’s old is new again? Part 2
In part 1 of the mini-series on Oracle Database Index-Organized tables (IOTs), I reviewed some of the pitfalls of using IOTs, especially on an Exadata
Sometimes I Can’t Live Without ARCHIVELOG Mode and I Can’t Live With It
The title of this article does not have a typo. ARCHIVELOG mode has been a foundational element of Oracle Database for every version I can
Are IOTs Relevant in the Exadata World? Part 1
I’m not talking about Internet Of Things devices, but of course Oracle Index Organized Tables, which have been available in Oracle Database long before Exadata
Oracle “Always Free” Autonomous Database: A Free Slice of Exadata?
In September of 2019 Oracle started offering an Autonomous Database (Data Warehouse or OLTP) that is part of their “Always Free” Oracle Cloud tier. “Free”
Exadata and Partitioning and Bloom Filters: Old School Features are New Again
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