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
Tag: Oracle Database
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
Hidden Parameter Bug Fixes That Don’t Always Fix the ORA-00600 Bug
Within the last year under a recent RU of 19c (approximately 19.13) an ORA-00600 started showing up in the alert logs. I say “approximately” since