Oracle Database - Personal Edition - Version 184.108.40.206 and later Oracle Database - Standard Edition - Version 220.127.116.11 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Information in this document applies to any platform.
This document records a number of Frequently Asked Questions pertaining to the tuning of SQL statements.
Pro-Active Problem Avoidance and Diagnostic Collection
Although some problems may be unforeseen, in many cases problems may be avoidable if signs are detected early enough. Additionally, if an issue does occur, it is no use collecting information about that issue after the event. For information on proactive preparations and diagnostics, see:
<Document 1482811.1> Best Practices: Proactively Avoiding Database and Query Performance Issues <Document 1477599.1> Best Practices Around Data Collection For Performance Issues
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!