In my last post, I described a quick show case for Oracle 12c Automatic Big Table Caching. But ABTC is just a crock, nevertheless a useful one. The biggest help from Automatic Big Table Caching for “sustainable” database performance management is the temperature of segments, heated up by TABLE ACCESS FULL. In my case, after enabling ABTC […]
Tag: partitioning
Oracle Technology Day Storage Optimisation – Impressions
In January, I’ve bee rather busy, so the blog was left alone. No sense in blogging just to blog. Now some content. I attended the Oracle Technology Day – Storage Optimisation in Bonn, Germany. It was a nice event, lots of information, a bit commercials, excellent catering. But this is a technical blog, let’s talk […]
Oracle: Convert a partitioned table into an unpartitioned one
License fees can bee massive. So for some machines it’s just useless to buy Oracle Enterprise Edition, sometimes Standard Edition is simply enough. Migration to SE for a schema with partitioned tables leaves you one option: CTAS all partitioned tables and export them, reimport them on your new box and modify all DBMS_METADATA-generated DDLs so […]