How to diagnose the long time running HOST concurrent program?

Hi Gurus

My customer has one customized HOST concurrent programs runs a long time to completed, and i am asked how to diagnose it.

I have provide him the following SQL for how to check the Oracle Process ID of the program.

SQL> column process heading "FNDLIBR PID"
SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid