My Oracle Support Banner

* Primary Note: Database Performance Overview (Doc ID 402983.1)

Last updated on AUGUST 30, 2023

Applies to:

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
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.


This Document provides an overview reference to content that pertains to the resolution of Performance issues affecting the whole database.

For the Database Performance Frequently Asked Questions FAQ,information regarding Performance Related Features or  issues involving individual SQL statements, see:

<Document 1360119.1> FAQ: Database Performance Frequently Asked Questions
<Document 1361401.1> Where to Find Information About Performance Related Features

<Document 199083.1> Primary Note: SQL Query Performance Overview
<Document 1516494.2> Information Center: SQL Query Performance Overview
<Document 398838.1> FAQ: SQL Query Performance - Frequently Asked Questions

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
Questions and Answers
 Pro-Active Problem Avoidance and Diagnostic Collection
 Performance Information Centres
 Troubleshooting Guides
 Common Problem Topics
 Commonly searched performance related Events, Warnings and Errors
 Slow Database Performance
 Concurrency Issues
 Database Hangs/Spins
 Session Hangs/Spins
 Single SQL Statement Hangs/Spins
 Locking Issues
 Pre-Upgrade Planning
 Post-Upgrade Performance Issue Resolution
 Debugging Waits for Various Events
 Library Cache/Mutex Contention/Cursor Type Events:
 Other Types:
 Common Causes of Performance issues
 Cursor Sharing/High Version Counts for Cursors
 High CPU usage
 Issues With waits for 'log file sync'
 Buffer Busy/Cache Buffers Chains Latch waits
 SYSAUX Issues
 Performance Diagnostics References
 Performance Service Request Diagnostic Collection (SRDC) documents
 General Diagnostics Overview
 10046 Trace
 Errorstacks for Performance Issues
 PL/SQL Profiler
 OS Watcher
 Trace/Result Interpretation
 Performance (and other) Webcasts
 Performance and Scalability Technical Briefs and Documentation
 Interacting With Performance Support
 Community: Database Tuning
 Community Discussions

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