My Oracle Support Banner

Statistics and Rebuilding Indexes for a P6 Schema Hosted on an Oracle Database Platform (Doc ID 1989838.1)

Last updated on MAY 07, 2023

Applies to:

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

Goal

This document provides recommendations for gathering statistics and rebuilding indexes for a P6 Database hosted on an 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.

Solution

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
Goal
Solution
 Section 1: Statistics
 Section 2: Indexes
References


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