My Oracle Support Banner

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

Last updated on APRIL 10, 2019

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 the P6 EPPM database (SQL or Oracle database platform).

Scope

This document is intended for 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
 Optimizing Database Performance
 Snapshot Isolation:
 Index Tuning:
 Statistics:
 Database Shrinking
References

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