* Primary Note: SQL Query Performance Overview
(Doc ID 199083.1)
Last updated on AUGUST 31, 2023
Applies to:
Oracle Database - Personal Edition - Version 7.1.4.0 and later Oracle Database - Enterprise Edition - Version 6.0.0.0 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 Information in this document applies to any platform.
Purpose
This document gives a overview of the SQL tuning issues for all DBAs.
SQL Query Performance Handling in Oracle
Every statement submitted to the Oracle engine passes through a number of phases that determine, for example, the statements validity or if it has run before etc. In terms of SQL Query Performance, the most important area is Query optimization which is nominally part of the PARSE phase.
Performance Service Request Diagnostic Collection (SRDC) documents
Service Request Data Collection (SRDC) documents have been specially designed to provide the reader with the necessary instructions to provide a step by step guide to collecting information for a various common Database Performance Issues.
<Document 1938786.1> List of Available Database Performance Related SRDC Documents
Questions and Answers
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!