My Oracle Support Banner

Performance Related Oracle Service Request Data Collection (SRDC) Articles (Doc ID 1938786.1)

Last updated on APRIL 04, 2019

Applies to:

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

Purpose

This article lists the performance related Service Request Diagnostic Collection (SRDC) documents.

For the full catalog of SRDC documents across all areas, refer to the following article:

<Document 1987484.2> SRDC - Catalog: All Products - Database - Exadata - EBS - JDE - Fusion - Middleware - GBUs - Siebel - Sun Systems - Peoplesoft - Enterprise Manager - SR Data Collection

Scope

Users looking to collect diagnostics for performance issues.

Details

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
Scope
Details
 Whole Database is slow/hung or multiple SQLs Slow
 High CPU/Memory Usage or I/O Issues
 PMON failed to acquire latch
 Slow SQL, Hung SQL, SQL Not Using an Index
 Wrong Results
 ORA-00600/7445 error with slow database or SQL performance
 ORA-00054 Errors
 ORA-00060 Errors
 "ORA-12751: cpu time or run time policy violation" Errors
 Waits for 'enq: TX - ...' type events
 Waits for 'latch: cache buffers chains'
 Waits for 'log file sync'
 Waits for 'library cache lock' 
 Using or troubleshooting SPM
 Database Replay Pre-Processing Issues
 Database Replay Initialization Performance Problem
 Database Replay Problem
 Database Capture Problem
 Excessive SYSAUX Space used by the Automatic Workload Repository (AWR)
 Materialized View Rewrite
 Parallel Execution
 Discuss Performance Diagnostics
References

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