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,
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
All Kinds of Exadata Stuff 