O'Reilly logo

Oracle SQL Tuning with Oracle SQLTXPLAIN by Stelios Charalambides

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 12

image

Using XPLORE to Investigate Unexpected Plan Changes

I’m sure by now you’re thinking that SQLTXPLAIN is a pretty cool tool to be familiar with, if you want to tune Oracle SQL. In Chapter 11 we discussed the test case utility and how that could build an entire environment for testing SQL, system parameter, optimizer settings, objects statistics, enough of the settings in fact to make the optimizer behave as if it was on the source system. Once you achieve that state you have a superb environment to go exploring the optimizer’s choices. This intelligent, directed approach is extremely fruitful when you have a rough idea what the problem ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required