Performance issue in Batch Processing

satheesh_color · Post by **satheesh_color** » Wed Mar 18, 2009 12:37 am

Hi All,

We have a Batch Job for POS file processing.Main issue is that POS file processing takes 80 seconds per file to complete. It usually takes 20-30 seconds per file.The Batch process usually takes 3 hour to process and now it took 4.5 hours, so we are missing our SLA.

The performance de-gradation happens only after the Oracle 9.2.0.8 patch hash been applied.

Can you please share your thoughts on this issue on how to get back the job into a normal state.

Thanks,
Satheesh

ray.wurlod · Post by **ray.wurlod** » Wed Mar 18, 2009 2:09 am

If the only change is the Oracle patch then there's your culprit. But be very, very certain that that IS the only change. Have data volumes increased?

satheesh_color · Post by **satheesh_color** » Mon Mar 23, 2009 2:54 am

Hi Ray,

Thanks for your inputs. No increase in data volumes. We just rolled back to oracle 9.0.0 and now it is running as expected. We have opened a Case Ticket for Oracle 9.2.0.8 patch issue.

Thanks,
Satheesh