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 ...

Get Oracle SQL Tuning with Oracle SQLTXPLAIN now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.