SkillBuilders Welcome  |  Log in
All Oracle Tutorials

How to Tune SQL with DBMS_ADVANCED_REWRITE (Tuning when You Can't Edit the Source Code)

Oracle Consultants Available

How do you tune SQL if you don't have access to the source code? Sometimes Oracle indexes, statistics, stored outlines, profiles or 12c directives will solve a tuning problem.  However, as a last resort, you may want to add a hint.  In this case  DBMS_ADVANCED_REWRITE could be the solution.  In this tutorial, Oracle Certified Master DBA John Watson of SkillBuilders demonstrates using DBMS_ADVANCED_REWRITE to change the SQL Oracle executes - without changing the source code!

Dec 11 - Oracle 12c SQL Tuning for Developers and DBAs

This free training is segmented into several separate lessons:

1. Part 1, Introduction and Demonstration of DBMS_ADVANCED_REWRITE   (3:17)  
2. Part 2, Demonstration and What Can Advanced Rewrite Do For You   (1:46)  

Date: Jan 7, 2016

View all videos now - Free Online Registration required

Here is a preview:

NOTE: Some corporate firewalls will not allow videos hosted by YouTube.