We are currently running Apps10 UPD14
We run nightly and weekly jobs to extract data from our IFS database, run an ETL, and then post the final information set to PowerBI.
We recently discovered that some of our initial data extract statements are running noticeably slower. Our business opportunity extract starting running 7 minutes slower immediately after the UPD14 installation.
Wondering if anyone else has noticed a similar performance impact and looking for suggestions to fix it
Could it be that data (due to the update or other influx) changed recently? We have found that when we refresh large mounts of data (e.g. thousands of records in a CLU) that queries take longer until Oracle optimizes things. I am not really much of an Oracle tuning expert, though, but are the queries getting better over time? Can you manually run the queries several times and see if their performance increases?
Thanks,
Joe Kaufman
Hi
On top of what Joe as suggested i would also look at the explain plans for your queries to see whether a code change in the new UPD is causing it to run slower. Sometimes with changes in the baseline code you would want to make sure the queries are optimized to the current logic.
Cheers.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.