Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DBMS_PIPE Waits

DBMS_PIPE Waits

From: dbuckingham <member8912_at_dbforums.com>
Date: Wed, 05 Feb 2003 05:08:55 +0000
Message-ID: <2483945.1044421735@dbforums.com>

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.com
Received on Tue Feb 04 2003 - 23:08:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US