Re: experience with dbms_pipes ?!

In article <SRICHTER.6.2FAE35A3_at_Materna.DE>, SRICHTER_at_Materna.DE says..

>I'm interesting in reading some opinions about ORACLE dbms_pipes:
 

> - possible problems with performance
> - " bugs
> - difficult/easy to implement
> - ...

We use pipes quite a bit in our system. The people who developed our system said they used pipes because you can be sure that the messages WILL get from A to B. Here are a couple of my comments:

1. Be sure you understand the use of the parameters 'timewait' and 'maxbuffersize' if your not going to use the default values.
2. Another is if you are packing the pipe at one end, make sure you've got something unpacking it at the other end. If the pipe gets full and your program tries to send another message on the pipe . . .you guessed it, the database will hang until it can complete the send. (Try to track that one down with limited knowledge of pipes.)

Look at Oracle7 Server Application Developers Guide page A-20 for documentation that is slightly better than what is in the dbmspipe.sql scripts.

Doris Jetz
yeer_at_cadvision.com Received on Wed May 10 1995 - 00:00:00 CEST