PL/SQL-based Transformations

Previous TopicNext TopicContents

PL/SQL does a portion of the transformation process. The largest portion of this is referred to as direct SQL. SQL update statements run directly against tables to perform simple transformation that does not require business logic. These processes are generally executed in parallel, and are very CPU intensive, on the database server. With the large chunk of data processed, the disk IO performance is limiting. A high performing SAN system improves the overall system response time.



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

Last Published Friday, January 31, 2014