My Oracle Support Banner

Recommendations for Obtaining an Oracle Database Session Trace for Performance Troubleshooting of the Project Management Client Application (Doc ID 891566.1)

Last updated on FEBRUARY 06, 2023

Applies to:

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!

In this Document
 Option 1:  Using The Oracle DBMS_SYSTEM Package To Obtain A Level 1 Session Trace
 Option 2:  Using The Oracle DBMS_SUPPORT Package To Obtain A Session Trace Which Includes Wait Events And Bind Variables
 Obtaining And Reading the Trace File
 Recommendations For Tracing A Performance Issue At Login

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