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”
Oracle Compression Syntax: Read the Freakin’ Manual?
(Updated 6/4/2020 to reflect incremental features in 20c release; updated 11/16/2022 for 21c incremental features). “Bigger on the inside? No. Basic miniaturisation sustained by a
Want 10053 traces? Can you query GV$ views?
If so, you’re in luck. You may have ALTER SESSION privileges in your database, but when you enable a 10053 trace and run your query,