UK Oracle User Group

No You Can’t Make A *!#@$&% Code Change (or, an Introduction to SQL Translation Framework)

« Return to event

Time: 3:30 PM - 4:15 PM

Track: Track 1

There are many features in the database to help us manage and stabilise performance.  Tables needs appropriate indexes to enable us to find data efficiently.  The optimizer needs data about the data (statistics) to enable it to determine how to execute a given SQL statement.  We can apply hints directly to control the execution plan either directly in the SQL code or have the database apply them with one of the plan stability features (outlines, profiles, baselines or patches).  However, sometimes that isn’t enough.  Sometimes there is no option but to change the code.  If you are lucky your in-house developers may be able to change the code, but in a third-party package that might require a service request to the vendor. 

SQL Translation Framework is new in Oracle 12c.  This little known feature permits SQL statements to be substituted on-the-fly at execution.  While it has the potential to wreak havoc if used maliciously, used responsibly it could be an effective tool to correct and optimise code when all other alternatives have been exhausted.

Presented by

  • David Kurtz, Accenture Enkitec Group

Attached Documents

PPTXSQLTranslationFramework - David Kurtz, Accenture Enkitec Group

Published: 27.01.2016 - This document is restricted to members