performance tunning

Oracle Apps How to do Performance Tuning for Interfacing Programs
Dear Readers,
Most of the times we face Performance issue in the customised concurrent programs,especially apps interface concurrent programs.Since oracle corp does not support customisation in apps ,its the job of the technical consultant and Apps DBA to tune these concurrent programs. Now the question comes as what we can do for concurrent programs and most of us will look into other aspects of tuning inspite of tuning the conc program itself. the best method is to enable the raw trace of such concurrent programs and do a tkprof on it and then according implement the recommendations.To enable the trace in the concurrent program do the following.Open the Define Concurrent Programs Forms and query that concurrent program and tick the checkbox “Enable Trace” and save it.Ensure that the database parameter TIMED STATISTICS is enabled.Now if you run the interface program then it will generate a raw trace in the udump location in the server.and do not forget to disable the Tracing after the trace file is generated.Mostly the bottleneck will be missing index in the interface tables or due to improper coding standards.