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

SQL Patch – fast way to add a hint without changing the code

SQL Patches are internally used by SQL Recovery advisor to fix SQL statements that fail with critical errors at run time. SQL Recovery advisor does this job by patching / hints the SQL statement, basically telling the optimizer to avoid an access path for example. The same undocumented package can also be used to insert … Continue reading SQL Patch – fast way to add a hint without changing the code