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 gets full

DBMS_PIPE gets full

From: Saugato Mukerji <Mukerji.Saugato.S_at_bhp.com.au>
Date: Wed, 30 Sep 1998 17:35:15 +1000
Message-ID: <3611DF33.1FD1D5B0@bhp.com.au> 





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


Received on Wed Sep 30 1998 - 02:35:15 CDT












Original text of this message













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