* 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