High CPU Usage on Server When Calls Made to DBMS_APPLICATION_INFO.SET_MODULE from P6 (Web) And P6services.jar
Last updated on JULY 14, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
P6 and p6services.jar is generates high utilization against the following package procedure:
- BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1 , :2 ); END;
For example, in a 1 hour timespan:
- "P6WebApp" SQL Module triggered the call to this 131,113 times as noted in an Oracle AWR report.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms