Oracle Database Discussions

Hi All,

I have an issue with the pipe get event, my job is waiting for the long time because of this.

There is a materialized to be refreshed with usually does in 120 sec max and min of 60 sec.

Now i can see the job is waiting for more than 2 hours.

Can any one help me out with this.

What is the solution for the PIPE GET. I tried to check in metalink and i did not find anything which sorts out my issue.

I hope any one of you would have come across this situation, so please share me your experience.

Db Version :- 10 g R 2 RAC
No. of Nodes :- 2
O/S :- Red Hat Enterprise Linux Server release 5.1 (Tikanga)


&gname> select inst_id,sid,wait_time,event,seconds_in_wait,state,p1,p2,p3 from gv$session_wait where sid=828
2 /

INST_ID SID WAIT_TIME EVENT SECONDS_IN_WAIT STATE P1 P2 P3
---------- ---------- ---------- ------------------------- --------------- ------------------- ---------- ---------- ----------
1 828 0 pipe get 3358 WAITING 9541037264 4096 600


Regards,
Siraj.