Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Streams
you'll notice the disclaimer i put in my message.. "if you are trusting". I didn't suggest you should or shouldn't be trusting, I just mentioned that it did in fact require some trust in the algorithm developers at Oracle. I did notice that there was no reference to ASMM or automatic shared memory management in the 10.2.0.3 patch list. there was a single fix related to problems from setting sga_target = sga_max_size though. that must mean it functions quite well or none of the folks having problems with it successfully got a bug filed. Subject: 10.2.0.3 Patch Set - List of Bug Fixes by Problem Type Doc ID: Note:391116.1 ----- Original Message ---- From: Charles Schultz <sacrophyte@gmail.com> To: rems@wp-sa.pl Cc: jobmiller@yahoo.com; cvsam@cox.net; oracle-l@freelists.org Sent: Wednesday, December 13, 2006 10:34:10 AM Subject: Re: Streams Not controversial at all! =) No worries, we already beat Job up over this issue earlier this year. I think memory management, as with some other new features, are great concepts but they need time to mature before they are unleashed to the public, especially with the carte blanch expectation that they will work great. I look forward to see how 10gR3 (aka 11g??) will improve upon these features. On 12/13/06, Remigiusz Soko³owski < rems@wp-sa.pl> wrote: 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@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 -- Charles Schultz ____________________________________________________________________________________ Want to start your own business? Learn how on Yahoo! Small Business. http://smallbusiness.yahoo.com/r-index
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 13 2006 - 14:43:59 CST
![]() |
![]() |