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 DECEMBER 06, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 5.0 and later
Primavera P6 Professional Project Management - Version 5.0 and later
All Platforms
***Checked for relevance 06-Aug-2014***

Purpose

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>. 

Scope

This document is intended for Oracle DBAs.

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
 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.