My Oracle Support Banner

Best Practices for Performance Tuning of the P6 EPPM Database (Doc ID 1327603.1)

Last updated on JUNE 20, 2024

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.2.1 and later
Primavera P6 Professional Project Management - Version 6.2.1 and later
Information in this document applies to any platform.
P6 performance is slow
P6 performance issues










Purpose

The purpose of this document is to provide best practices for performance tuning of a P6 EPPM or P6 Professional database hosted in an on-premise SQL Server or Oracle database platform.

This document applies only to self-hosted P6 environments.  By default all required performance-tuning tasks are performed automatically on a recurring schedule for customer databases in Oracle Cloud-hosted environments.

Scope

This document is intended for Database Administrators (DBAs).

Note:  Refer to the following knowledge base document for guidance with providing database performance parameters when requested:  SRDC - Process for Providing the Database Performance Parameters to Customer Support (Doc ID 2015654.1)

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
 Physical Database Design Performance Tuning
 Background Processes and Clean Up in P6 EPPM
 Oracle Performance Tuning Considerations
   Oracle Database Performance Tuning
             Oracle Database Table Partitioning For P6 EPPM Schema
   Oracle Database 12c Considerations
             Oracle Database Optimizer Cost Parameter Recommendations [For Project Management Schema Only]
             Statistics Gathering Process for Oracle Databases
                P6 EPPM Index Rebuilding for Oracle Databases
 SQL Server Performance Tuning Considerations
 Monitoring and Tuning for Performance
 Optimizing SQL Server and Database Performance
 Optimizing SQL Server Performance
 Considerations When Using VMWare
 Snapshot Isolation:
 Index Tuning:
 Statistics:
References

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