My Oracle Support Banner

P6 EPPM Application Queries Can Execute Inefficiently After Upgrading to Oracle Database 12.2 (Doc ID 2649868.1)

Last updated on MARCH 22, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 17.7 and later
Information in this document applies to any platform.


The example from which the investigation started was a large Web Services export job that was taking an extraordinarily long time to complete.  After analysis of the top SQL executed by the Web Services job, it was found that the queries were using an 'Index Fast Full Scan' instead of an 'Index Range Scan' that was causing queries to take roughly twice as long to complete.  Database tuning was done as part of the troubleshooting process but the queries continued to perform the 'Index Fast Full Scan'.


P6 EPPM connected to an Oracle Database 12.2.


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

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