OpenWorld 2015 – 18 months of production experience with Oracle database 12c

Thanks to all for attending our session UGF6827 at Oracle OpenWorld 2015. This is a place holder for getting the slides of our presentation

Advertisements

Convert non-partitioned table to partitioned table using DBMS_REDEFINITION

I had a request from my users that suddenly one of the query is running slowly. I did the usual checks, SQL Plan regression, storage response time, load on the database, there was nothing unusual. Then I told my user that the elapsed time for this query is as usual and the plan has not changed … Continue reading Convert non-partitioned table to partitioned table using DBMS_REDEFINITION