What Is The Recommended P6 Reporting Database Oracle Tablespace Location?

(Doc ID 909533.1)

Last updated on AUGUST 21, 2016

Applies to:

Primavera P6 Reporting Database - Version: 6.2.1-R1 and later   [Release: 6.2 and later ]
All Platforms

Symptoms

What is the recommended Enterprise Reporting Database Oracle tablespace location?

Enterprise Reporting Administrators Guide states:

Recommended locations for Stage, ODS, and Star It is recommended that the Stage, ODS, and Star databases reside on different physical machines than the one on which the main Project Management database resides. This minimizes the impact on the main applications that access the Project Management database. The ETL process is CPU intensive, and runs on the physical server hosting the Stage database. The Stage, ODS, and Star databases may reside on the same server or on three different servers. 

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