Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Huge time in 'SQL*Net message from client' while running EBS request

edited Apr 5, 2016 3:53PM in Core Concurrent Processing - EBS (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center