Posted by Nitin Pai
October 26th, 2007

In this post I will share a tuning tip that I used to improve the performance of the PeopleSoft Upgrade data conversion AE.

Data Conversion AE was truncating the temporary table è Inserting 35 million rows into temporary table from transaction table è Updating stats

The above steps combined took around 6hrs to complete. It ran in 30mins after the below changes to AE.

Tune_ae_data_conversion

þ We dropped the index on temporary table

þ INSERT was modified to use APPEND hint

þ Recreated the index using NOLOGGING

Summary:PeopleSoft does not necessarily ship optimal code. We have to keep our eyes open to identify and modify the problem code to improve conversion performance

Comments (0)