* 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.

Purpose

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

Pre-Upgrade Planning

Post-Upgrade Performance Issue Resolution

Debugging Waits for Various Events

Library Cache/Mutex Contention/Cursor Type Events:

Common Causes of Performance issues

Cursor Sharing/High Version Counts for Cursors

Issues With waits for 'log file sync'

WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!

Buffer Busy/Cache Buffers Chains Latch waits

Performance Diagnostics References

Performance Service Request Diagnostic Collection (SRDC) documents

General Diagnostics Overview

Systemstates/Hanganalyze

Errorstacks for Performance Issues

PL/SQL Profiler

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.