Expert Insights
Technical Blog

Technical and Product News and Insights from Rackspace

Transfer SQL plans by using a SQL plan baseline

A particular SQL query might perform poorly on one database (such as production) but work fine on another database (such as development). This situation might occur if the same query has a different execution plan on each instance. This blog shows how to transfer the execution plan from an instance, where query works fine, to another instance, where query behaves poorly, by using the SQL plan baseline feature that OracleĀ® DatabaseĀ® first introduced in version 11g.

Read More

Edition Based Redefinition (EBR) and enabling an application to support EBR

Originally published by Tricore: May 5, 2017

This blog covers some basic concepts of Edition Based Redefinition (EBR) and how to use it to support an applications upgrade, which can reduce downtime.

Read More