Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> DBMS_PIPE Waits
Having an issue where the performance of our system appears to be affected from the number of waits that are being experienced from the DBMS_PIPE. We are finding that when the system performance is being affected, the "pipe put" waits were very high.
Our procedure is making a direct call the "sys.dbms_pipe" and passing in a pipe name and using the default Timeout and Maxpipesize. I believe this to be 1000days and 8k.
The performance is being affected when we execute a procedure that processes a lot of data very quickly. As a result, I am curious as to whether we might be filling up the pipe to quickly.
Has anyone got any ideas as to what tests I might be able to perform in order to determine if the actual is filling up to quickly?
Thanks.
Dan.
-- Posted via http://dbforums.comReceived on Tue Feb 04 2003 - 23:08:55 CST