Configuring ETL Settings for ODS

Previous TopicNext TopicContents

On the ETL Settings screen:

  1. In the JVM Location field, enter or verify the path to the Java Virtual Machine (JRE path).
  2. In the Log Detail Level field, choose the level of logging detail that you want to use. The following are the logging detail levels you can choose:
  3. In the Max Java Heap Size (MB) field, enter parameter for the Java Heap Size. This value maps to the JVM –Xmx setting in the Java Runtime Environment settings. The default value (and recommended value) is 1,024 MB.
  4. In the Log Detail Level field, choose the level of logging detail that you want to use. The following are the logging detail levels you can choose:
  5. In the General Thread Count field, choose the number of threads the ETL process will run. Extraction and Load processes are multi-threaded.

    Oracle recommends keeping the default (5) for this setting.

  6. In the Index Building Thread Count field, choose the number of threads that will build the index. It specifies how many threads to run for building indexes for the ODS or Star database.

    Oracle recommends keeping the default (5) for this setting.

  7. Click Next.

Related Topics

Configuring the Oracle ODS Database

Configuring the P6 EPPM Database Connection on an Oracle Instance

Configuring the P6 EPPM Database Connection on a Microsoft SQL Server Database

Configuring the ODS Database Connection

Finishing the Configuration Wizard for ODS

Finishing the ODS Database Configuration



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014