Pick Release Process Executes Extremely Slowly (Doc ID 262068.1)

Symptoms

You are running in a 3-Node Real Application Cluster (RAC) Environment. You execute an Oracle Applications
Concurrent Program and notice that certain executions of the program run extremely slow. You encounter a 'pipe put' wait event.

The following is an example of the query being run:

select w.sid, w.event,s.module,s.username,w.p1,w.p2,w.p3
from v$session_wait w, v$session s
where w.sid=s.sid and w.state='WAITING' and
w.event not in ('pmon timer',
'smon timer',
'rdbms ipc message',
'pipe get',
'SQL*Net message from client',
'SQL*Net message to client',
'SQL*Net break/reset to client',
'SQL*Net more data from client',
'wakeup time manager',
'slave wait',
'SQL*Net more data to client') and w.event not like '%slave wait'
group by w.sid,w.event,s.module,s.username,w.p1,w.p2,w.p3 order by 2 desc

Changes

You have upgraded to Discrete Manufacturing 11.5.9 Patchset I.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.