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

Posted by Nitin Pai
Comments (0)
October 26th, 2007

Comments (0)