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 --------------------------------------- -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l