How to Troubleshoot Performance Issues (Doc ID 1542322.1)

Last updated on MARCH 03, 2023

Applies to:

Oracle Agile Formulation and Compliance for Process - Version 6.2.0.0 to 6.2.3.0 [Release 6.2.0]
Oracle Agile Product Supplier Collaboration for Process - Version 6.2.0.0 to 6.2.3.0 [Release 6.2.0]
Oracle Agile New Product Development and Introduction for Process - Version 6.2.0.0 to 6.2.3.0 [Release 6.2.0]
Oracle Agile Product Lifecycle Management for Process - Version 6.2.0.0 to 6.2.3.0 [Release 6.2.0]
Agile Product Quality Management for Process - Version 6.2.2.0 to 6.2.3.0 [Release 6.2.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

I. General Information

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.

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

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