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
***Checked for relevance 06-Aug-2014***
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.
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|