P6 Analytics and P6 Reporting Database leverage PL/SQL Bulk operations to process smaller batches while performing interim commits. This results in linear scaling of update operations (for example, if it takes five minutes to update one million rows, it will take ten minutes to update two million rows). Rows per second performance remains constant here, regardless of amount of change or data size.
Many of the processes, including the PL/SQL Bulk operation processes, are run in parallel threads. The use of parallel PL/SQL processes not only increases the potential scalability of this process, but also the demand for CPU powers and network bandwidth on the server.
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014