Re: Streams

if you are trusting of the auto memory management stuff, the streams pool is now self adjusting in 10gR2, so that you shouldn't see these kind of errors.  It *should* borrow memory from other pools to satisfy these moments of increased use during PQ operations.

Job


----- Original Message ----
From: Remigiusz Sokołowski <rems@wp-sa.pl>
To: cvsam@cox.net
Cc: oracle-l@freelists.org
Sent: Wednesday, December 13, 2006 4:28:42 AM
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@wp-sa.pl>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL  v.  4.x
Oracle v. 10.x
---------------------------------------

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


 
____________________________________________________________________________________
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers.yahoo.com

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