• About This Guide
  • About Database Users
  • Migrating Databases and Database Schema
    • Using the Migrate Database Wizard
      • Running a Schema Validation on the Database
      • Running the Migrate Database Wizard
      • Running the Migrate Database Wizard From the Command Line
    • Migrating Database Schema
      • Prerequisites for Schema Migration
      • Migrating P6 EPPM Schema to P6 Professional with Oracle
      • Migrating P6 EPPM Schema to P6 Professional with Microsoft SQL Server
  • Creating and Updating P6 EPPM Configurations
    • Creating P6 EPPM Configurations
    • Updating P6 EPPM Configurations
  • Setting Up the P6 EPPM Database
    • Installing a P6 EPPM Database with Oracle
    • Installing a P6 EPPM Database with Microsoft SQL Server
    • Upgrading a P6 EPPM Database with Oracle Database
    • Upgrading a P6 EPPM Database with Microsoft SQL Server
  • Changing the Database Base Currency
    • The Base Currency
    • Reviewing Currency Choices
    • Changing the Base Currency
  • Private Database Credentials for P6 EPPM
    • Resetting Private Database Passwords
    • Adding Private Database Logins for P6 EPPM
    • Modifying Private Database Logins for P6 EPPM
    • Deleting Private Database Logins for P6 EPPM
  • Setting Up Cloud Sync
    • Synchronizing data from P6 EPPM to Oracle Primavera Cloud
    • Synchronizing data from Oracle Primavera Cloud to P6 EPPM
  • Configuring Background Processes and Jobs
    • RDBMS Scheduler Configuration
    • Database Settings Table
    • Reading Setting Values
      • Using Code to Read Setting Values with Oracle
      • Using Code to Read Setting Values with Microsoft SQL Server
    • Writing Setting Values
      • Using Code to Write Setting Values with Oracle
      • Using Code to Write Setting Values with Microsoft SQL Server
    • Tracking Background Job Execution
      • High Level Status Settings
      • The BGPLOG Table
  • Monitoring Processes and Procedures
    • PAUDIT Auditing
      • Auditing Level Configuration
      • Simple Configuration
      • Detailed Configuration
        • Auditing Status
        • Options Setting
        • SETTINGS_WRITE_STRING Procedure
      • The Audit Table
      • Session Auditing
      • Column Audit Data
  • Tuning the P6 EPPM Database
    • Oracle Database Tuning
      • Partitioning Oracle Database Tables for P6 EPPM Schema
      • Gathering Statistics for Cost Based Optimizations
      • Viewing the USESSION Table for GET_SAFETY_DATE
      • Rebuilding the P6 EPPM Index Table
      • Where to Find Additional Oracle Database Tuning Information
    • Microsoft SQL Server Database Tuning
      • Where to Find Additional Microsoft SQL Server Database Tuning Information
      • Isolating Snapshots
      • Rebuilding the P6 EPPM Index
      • Gathering Statistics
    • General Tuning
      • Background Processes and Clean Up in P6 EPPM
        • SYMON (System Monitor) Procedures
          • OBSPROJ_PROCESS_QUEUE Procedure
          • USESSION_CLEANUP_EXPIRED Procedure
            • Tracking Concurrent Usage of P6 EPPM
        • DAMON (Data Monitor) Procedures
          • BGPLOG_CLEANUP Procedure
          • CLEANUP_DBERRLOG Procedure
          • REFRDEL_CLEANUP Procedure
          • REFRDEL Bypass Procedure
          • CLEANUP_PRMQUEUE Procedure
          • USESSION_CLEAR_LOGICAL_DELETES Procedure
          • CLEANUP_LOGICAL_DELETES Procedure
          • PAUDIT_CLEANUP Procedure
          • CLEANUP_PKXREF
          • CLEANUP_PCKEYXREF
          • CLEANUP_USESSAUD Procedure
          • CLEAN_PX_DELETE Procedure
          • USER_DEFINED_BACKGROUND Procedure
      • Safe Deletes
        • Turning Off Safe Deletes
  • Copyright