RE: Streams
- From: "Kerber, Andrew" <Andrew.Kerber@xxxxxxx>
- To: rems@xxxxxxxx, jobmiller@xxxxxxxxx
- Date: Wed, 13 Dec 2006 09:42:21 -0600
My experience with the automatic memory management is that it works fine
if you have plenty of memory available. However, if you are limited in
memory for whatever reason it will actually cause major performance
problems. I didn't get into the details (these were production
instances), but I suspect Oracle gets to a point where it is too busy
trying to juggle too little memory among the various pools, and cant
execute its everyday business.
Andrew W. Kerber
Oracle DBA
UMB
816-860-3921
andrew.kerber@xxxxxxx
"If at first you dont succeed, dont take up skydiving"
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Remigiusz Sokolowski
Sent: Wednesday, December 13, 2006 9:30 AM
To: jobmiller@xxxxxxxxx
Cc: cvsam@xxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Streams
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
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential.
The information is exclusively for the use of the individual or entity intended
as the recipient. If you are not the intended recipient, any use, copying,
printing, reviewing, retention, disclosure, distribution or forwarding of the
message or any attached file is not authorized and is strictly prohibited. If
you have received this electronic mail message in error, please advise the
sender by reply electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your computer
system. Thank you.
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
