My Oracle Support Banner

* FAQ: Database Performance Frequently Asked Questions (Doc ID 1360119.1)

Last updated on FEBRUARY 08, 2022

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Personal Edition - Version 7.1.4.0 and later
Oracle Database - Enterprise Edition - Version 6.0.0.0 and later
Oracle Database - Standard Edition - Version 7.0.16.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document outlines a number of Frequently Asked Database Performance Questions

Best Practices

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!


In this Document
Purpose
 Best Practices
 Pro-Active Problem Avoidance and Diagnostic Collection
Questions and Answers
 Where is there Information About Performance Related Features
 Where can I find performance Troubleshooting Information?
 Where is there an Overview of the Main Database Performance Articles?
 Where can I find Performance Information Centres?
 Community: Database Tuning
 ** How do I Investigate a Database Performance Issue
 ** How do I gather Performance Related Diagnostics?
 AWR reports/Statspack reports
 10046 Trace (SQL_TRACE)
 Querying Waits from V$Session_wait
 Finding Current Session ID
 System State Dumps
 Errorstack
  PSTACK
 PL/SQL Profiler
 Hanganalyze
 OS Watcher
 ** How do I Interpret the Results of Various Traces
 Statspack Reports
 10046 traces
 Systemstates
 Hanganalyze
 Errorstacks
 ** Top Database Performance Issues/Problems and How To Resolve Them
 Library Cache/Shared Pool Latch waits
 High Version Counts
 Log File Sync waits
 Buffer Busy waits
 Cache Buffers Chains Latch waits
 WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!
  ORA-60 DEADLOCK DETECTED/enqueue hash chains latch
 **What If I cannot Find an Answer to my Issue?
References

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