Login to P6 Professional As Non-admin Superuser Is Slow

(Doc ID 2311552.1)

Last updated on OCTOBER 09, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3 to 8.3.15.0 [Release 8.3]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
--------------------
When attempting P6 Professional login as a non-admin superuser, observe very poor performance. For example, it takes nearly 10 minutes longer to login as a non-admin superuser than it does as a user assigned to the admin superuser profile.

When reviewing an AWR report, note that the populate_uaccess procedure is responsible for most of the waiting time.

EXPECTED BEHAVIOR
--------------------
For login to P6 Professional as a non-admin superuser to perform more quickly.

Changes

 

Cause

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