Re: Streams

  • From: Remigiusz Soko?owski <rems@xxxxxxxx>
  • To: Sam Chakkanat <cvsam@xxxxxxx>
  • Date: Wed, 13 Dec 2006 16:40:38 +0100

Sam Chakkanat wrote:

The parallel query error is related to specific OS pre-req patch for and up.(I don't remember the patch number off my head).
I guess this is now included in This error has also dependency on
these parameters.

parallel_max_servers (min 6 or above), open_links (4 or above) processes (adjust accordingly to OS needs)
sga_target (From 10gR2 streams_pool_size is auto allocated from this, but
general rule is a minimum 200 MB, usually I allocate 500MB for

From your parameters looks like you have only 260MB of streams_pool_size,
and it may well on the edge. Try turning off parallelism, increase sga_target or set streams_pool_size to
500MB.  If that works, then turn on parallelism and see if that breaks.

Other question (s) : Is this on production? or Development?  Is this streams
environment is built new or built, then cleaned and rebuilt ...? In that
case chances are cleansing may be not really clean...

this is production on
streams are built new, and all works great - just sometimes it is too less memory - we suppose it is due to temporal traffic increase and I don't know - more parallel processes processing queue taking whole memory? It would be fine to limit somehow this parallelism degree (but only for queues) - queue can grow, it would be emptied later in time of lower traffic.


Remigiusz Sokolowski <rems@xxxxxxxx>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL  v.  4.x
Oracle v. 10.x


Other related posts: