Hi All,

My session is taking more CPU Usage. It calls AFS for Production Reporting, Maintain & Release Outbound. Can anybody tell how to reduce the CPU Usage.

Thanks in advance

Try compiling with profiling option the session. The report at the end of session could help you to identify function calls what take more time to run.

Depends on what you mean. Is it a case of you launch the session and while it is processing the records it consumes more CPU than you like - kind of like a run away process where the users do not get any cpu time. Is this the case?

Or is it a case of the longer it runs the more CPU time(and resources)it requires to complete one transaction? How exactly are you funtion servers written - open once, process records, then close; or is it open once, process 1 record, close and repeat.

More information on exactly what is happening is needed.