DBMS_PIPES delay problem

[jason6510]

Hi..
We're developing an app in delphi 6 using DOA components with oracle 9i.What we want to do is use DBMS_PIPES (osession.dbms_pipes.send_message) in conjunction with and oracle event component to create an internal messaging system.This seems to work fine in the beginning but then it begins to intermittendly have long delays before sending the message or closing the app.(note the delay occours BEFORE the sending of the message , not inbetween when the message send and recieve.)Has anyone else experienced this problem and how did you overcome it?

Thanks in advance
Jason.

[This message has been edited by jason6510 (edited 10 September 2002).]

 

[Marco Kalter]

The dbms_pipe is a queue mechanism. If the pipe is too "full" to be used when sending a message, it will wait until the pipe is read by some other session.

This can be affected by the timeout & maxpipesize parameters of the dbms_pipe.send_message function, and the maxpipesize parameter of the dbms_pipe.create_pipe function.

------------------
Marco Kalter
Allround Automations