My Oracle Support Banner

Tuning Queries: 'Quick and Dirty' Solutions (Doc ID 207434.1)

Last updated on JUNE 15, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

Sometimes, when a query is performing badly, a solution is needed right away.
Other considerations are insignificant compared to the performance of this query.

In this situation a trial and error approach 'might' get the query to work in the required fashion. This article provides several trial and error suggestions that can be tried will little analysis.

The scope of this article is limited to factors affecting the costing algorithms in the Cost Based Optimizer (CBO). Only the most common examples are covered.
The article should be relevant to people seeking quick 'fixes' to query tuning problems.

Please also refer to the following articles which provide action plans for issues as well as some suggestions:

<Document 742112.1> Support Action Plan for Query Performance Degradation
<Document 745216.1> Support Action Plan for Query Performance Degradation After Upgrade

 

NOTE: There is a presentation entitled "Tips for Preventing Suboptimal Execution plans" available in:

<Document:1380043.1> Selected Performance Related Seminars from Oracle Openworld

Which also addresses and provides specific tips on this subject.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Potential Solutions
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.