What Is The Recommended P6 Reporting Database Oracle Tablespace Location?
Last updated on AUGUST 21, 2016
Applies to:Primavera P6 Reporting Database - Version: 6.2.1-R1
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms