Re: Streams
- From: Remigiusz Sokołowski <rems@xxxxxxxx>
- To: jobmiller@xxxxxxxxx
- Date: Wed, 13 Dec 2006 16:29:51 +0100
Job Miller wrote:
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
Well, I suppose this may be a little controversial, but
we used auto memory management and came to conclusion it is a major
source of some of our problems.
The idea is fine and we suppose it works great for instances with less
turbulent memory structure changes
However since we started with ASMM, we experienced several major server
failures, while working with static settings it was not the case.
Of course now we have to bounce server to change settings, but still it
is better to have a control over shutdown process.
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
Other related posts:
