© Stelios Charalambides  2017

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

3. The Cost-Based Optimizer Environment

Stelios Charalambides

(1)New Hampton, New Hampshire, USA

After reviewing the AWR report and homing in on the SQL you want to work on (bear in mind there could be more than one), you now approach the tricky problem of dealing with an individual SQL.

Every SQL needs individual attention. Approach it with skepticism and caution and watch out for hidden complications and unexpected traps. Be like the alien who came to earth to try his hand at driving. He’d read all about it and knew the physics involved in the engine. It sounded like fun. He sat down in the driver’s seat and turned the ignition; ...

Get Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition, Second Edition 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.