Recommendations For Obtaining An Oracle Database Session Trace For Performance Troubleshooting Of The Project Management Client Application
(Doc ID 891566.1)
Last updated on JUNE 01, 2020
Primavera P6 Professional Project Management - Version 5.0 and later Primavera P6 Enterprise Project Portfolio Management - Version 5.0 and later All Platforms
This document provides steps to allow tracing of direct SQL calls that are made to the database via user(s) action(s) within the Project Management or Methodology Management Windows client application for the purpose of diagnosing performance problem(s) such as query inefficiency. There are many ways to capture a session trace and this document will demonstrate two of them.
Capturing an Oracle session trace may not provide benefit when diagnosing Web performance issues because the web application(s) spawn multiple sessions which end users cycle through. Therefore, it may be too difficult to determine which session opened will be used by an end user's action. To troubleshoot performance issues from the Web, it is best to following the detail in Document 894429.1.
This document is intended for Oracle DBAs.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!