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

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!

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) (click on video below)

Date: Jan 7, 2016


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


Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×