My Oracle Support Banner

How to Troubleshoot Performance Issues (Doc ID 1542322.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle Agile Formulation and Compliance for Process - Version 5.2.2 to 6.1.1.0 [Release 5.2.0 to 6.1.0]
Oracle Agile Product Supplier Collaboration for Process - Version 5.2.2 to 6.1.1.0 [Release 5.2.0 to 6.1.0]
Oracle Agile New Product Development and Introduction for Process - Version 5.2.2 to 6.1.1.0 [Release 5.2.0 to 6.1.0]
Oracle Agile Product Lifecycle Management for Process - Version 5.2.2 to 6.1.1.0 [Release 5.2.0 to 6.1.0]
Agile Product Quality Management for Process - Version 6.1.1.0 to 6.1.1.0 [Release 6.1.0]
Information in this document applies to any platform.

Purpose

This document can be used to reference for narrowing down 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
Details
 I. General Information
 A. Baseline
 B. Narrowing down the root cause of the performance issue
 II. What is the root cause?
 A. Database performance
 B. Available Troubleshooting Methods
 Database administrators can investigate the longest running queries in SQL trace.
 If possible, undo any recent changes that were made.
 SQL Tracing
 III. Database Performance
 IV. Microsoft .NET Performance Tasks
 V. PLM FOR PROCESS APPLICATION PERFORMANCE
 Performance Logging Tool (PLM for Process 6.1.1.1 and higher)
  VI. SYSTEM PERFORMANCE
 CAPACITY PLANNING GUIDE
References

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