5. Stabilizing Query Response Time Using SQL Plan Management
Every database administrator (DBA) has experienced the frustrating occasion when a query, which performed well earlier, suddenly starts deviating from its normal response time and becomes alarmingly lethargic. This performance degradation might be attributable to several direct or indirect causes, but it is fairly likely that the cause is a change in the execution plan. If you do not have enough in-house tuning experience to identify its root cause, but the problem requires an immediate solution and you want to set the critical query back to its original accepted response time, then using a SQL plan baseline to fix an acceptable execution plan and stabilize the query execution time ...
Get Oracle Database Problem Solving and Troubleshooting Handbook 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.
