RE: Streams

Remigiusz,

The parallel query error is related to specific OS pre-req patch for
10.1.0.3 and up.(I don't remember the patch number off my head).
I guess this is now included in 10.2.0.2. 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)
sessions
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
streams_pool_size)

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...

There may be also other dependencies to the schema/tables that you need to
dig in.

Hope this helps.

Thank You,
 
Sam Chakkanat
America's C-Bench
http://www.cbenchusa.com





-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Remigiusz Sokolowski
Sent: Wednesday, December 13, 2006 1:29 AM
To: cvsam@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Streams

Sam Chakkanat wrote:
> If you have any Oracle Streams questions please let me know.  I would be
more than happy to share my experience.
>   

Hi!
we introduce it in our technology arsenal with 10g version Actually we're
quite happy with it, but sometimes we experience such error as:

ORA-10388: parallel query server interrupt (failure)
ORA-12801: error signaled in parallel query server P000
ORA-04031: unable to allocate 312 bytes of shared memory ("streams
pool","unknown object","apply shared t","knalf:KGGHSTCLN")

Previously we simply resize streams pool to 260M, but is it the only
solution to this problem?

Regards
Remigiusz


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

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: