* Master Note: SQL Query Performance Overview
(Doc ID 199083.1)
Last updated on AUGUST 04, 2018
Oracle Database - Standard Edition - Version 126.96.36.199 and later Oracle Database - Personal Edition - Version 188.8.131.52 and later Oracle Database - Enterprise Edition - Version 184.108.40.206 and later Information in this document applies to any platform.
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!