My Oracle Support Banner

* Master Note: SQL Query Performance Overview (Doc ID 199083.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Standard Edition - Version 7.0.16.0 and later
Oracle Database - Personal Edition - Version 7.1.4.0 and later
Oracle Database - Enterprise Edition - Version 6.0.0.0 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!


In this Document
Purpose
 SQL Query Performance Handling in Oracle
 Performance Service Request Diagnostic Collection (SRDC) documents
Questions and Answers
 Performance Information Centres
 Frequently Asked Questions
 Pro-Active Problem Avoidance and Diagnostic Collection
 Troubleshooting SQL Query Performance Issues
 Common Issues/Problem Avoidance
 Recommended Action Plans
 Recommended Diagnostics
 Performance Service Request Diagnostic Collection (SRDC) documents
 Using DBMS_SQLDIAG
 SQL Appears to Hang
 SQL Query Performance
 Troubleshooting General SQL Query Performance Issues
 Troubleshooting Specific Issues
 Statistics
 Hints
 SQL Plan Management (11g onwards) and Stored Outlines (10g and below)
 Community: SQL Performance
 Performance Webcasts
 Documentation, White Papers and Blogs
 Tuning Support
References

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