Re: Streams
- From: Job Miller <jobmiller@xxxxxxxxx>
- To: rems@xxxxxxxx, cvsam@xxxxxxx
- Date: Wed, 13 Dec 2006 06:17:32 -0800 (PST)
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@xxxxxxxx>
To: cvsam@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxx>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL v. 4.x
Oracle v. 10.x
---------------------------------------
--
//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
Other related posts:
