Tuning Data Conversion AE during PeopleSoft Upgrade – I

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.

e dropped the index on temporary table

NSERT 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

Read More About  Tuning Data Conversion