Re: DBMS_PIPE gets full

On Wed, 30 Sep 1998 17:35:15 +1000, Saugato Mukerji <Mukerji.Saugato.S_at_bhp.com.au> wrote:

>hi
>if i pack more than 150 messages the DBMS_PIPE package gets full.
>I read the DBMS_PIPE messages are buffered in the SGA.
>
>How do I increase the amount of SGA buffers available for the DBMS_PIPE
>messages.
>
>has anybody got done any benchmarks about the thruput which can be
>achieved
>using DBMS_PIPE.
>
>thanks
>
>Saugato
>
>

Increase the maxpipesize parameter when creating the pipe (the default is 8192 bytes).

Good luck,

Nuno Guerreiro

As I don't normally appreciate unsolicited commercial e-mail (widely known as SPAM), I encoded my e-mail address. If you want to reply by e-mail, please remove the text added to fool spam software

"The art of arts, the glory of expression and the sunshine that lights the light of letters  is simplicity"

                                                        Walt Whitman Received on Wed Sep 30 1998 - 04:13:44 CDT