CHAPTER 6
Forcing Execution Plans Through Profiles
Sometimes it’s best to fix a problem and figure out afterward what went wrong and determine the root cause. By this I mean that when there are production time pressures to get something done, any way that works is good enough. The idea is to get the business back up and running, then sit at your leisure and work out what went wrong, figure out how to stop it from happening again, and develop a plan to implement the permanent fix in a controlled manner during a planned outage if required. Management is not usually very tolerant of perfectionists who want to understand every detail of a 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.
