Huge time in 'SQL*Net message from client' while running EBS request
Hi
In EBSR12.1.3 environment, requests keep in Running Normal status,by run the following SQL,
seems huge time cost on event “SQL*Net message from client”,it could happens on all programs randomly.
Run the following SQL
select s.INST_ID,
r.request_id “Request ID”,
s.sid “Session ID”,
g.concurrent_program_name “Concurrent Program”,
s.EVENT,
s.SECONDS_IN_WAIT
from applsys.fnd_concurrent_requests r,
applsys.fnd_concurrent_queues_tl qt,
applsys.fnd_concurrent_queues q,
applsys.fnd_concurrent_processed p,
applsys.fnd_concurrent_programs g,
gv$session s
where r.controlling_manager=p.concurrent_process_id