© Stelios Charalambides  2017

Stelios Charalambides, Oracle SQL Tuning with Oracle SQLTXPLAIN, 10.1007/978-1-4842-2436-6_17

17. Using XPLORE to Investigate Unexpected Plan Changes

Stelios Charalambides

(1)New Hampton, New Hampshire, USA

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 16 we discussed the test case utility and how that could build an entire environment for testing SQL, system parameter, optimizer settings, objects statistics, and 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 ...

Get Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.