My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Personal Edition - Version 9.2.0.8 and later
Oracle Database - Enterprise Edition - Version 9.2.0.8 and later
Enterprise Manager for Oracle Database - Version 9.2.0.8 and later
Oracle Database - Standard Edition - Version 9.2.0.8 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> Master 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
Purpose
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
 Hangs
 Database Hangs/Spins
 Session Hangs/Spins
 Single SQL Statement Hangs/Spins
 Locking Issues
 Deadlock
 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'
 WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!
 Buffer Busy/Cache Buffers Chains Latch waits
 SYSAUX Issues
 Performance Diagnostics References
 Performance Service Request Diagnostic Collection (SRDC) documents
 General Diagnostics Overview
 AWR/Statspack
 10046 Trace
 Systemstates/Hanganalyze
 Errorstacks for Performance Issues
 PStack
 PL/SQL Profiler
 OS Watcher
 Trace/Result Interpretation
 Performance (and other) Webcasts
 Performance and Scalability White Papers and Documentation
 Interacting With Performance Support
 Community: Database Tuning
 Community Discussions
References

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