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”
Tag: Oracle Database
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
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
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
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