Re: ASSM vs. non-ASSM
From: ddf <oratune_at_msn.com>
Date: Wed, 25 Jan 2012 10:00:31 -0800 (PST)
Message-ID: <43ce3dca-4b6f-4930-8048-6780ea924bd3_at_o20g2000yqh.googlegroups.com>
On Jan 25, 9:41 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> I am engaged in a discussion about moving from 10g --> 11g. The
> tablespaces in this particular 10G are all created with the manual
> segment space management. I am reading the blogs and am aware of all the
> troubles that ASSM can cause, ranging from wasting space to problems with
> the free lists and even some spurious corruption issues.
> However, Oracle made ASSM default in version 10g, and this project is
> about upgrading a large production DB. What are the opinions here? Does
> it make sense to go with manual SSM or should I go with ASSM?
>
> --http://mgogala.byethost5.com
Date: Wed, 25 Jan 2012 10:00:31 -0800 (PST)
Message-ID: <43ce3dca-4b6f-4930-8048-6780ea924bd3_at_o20g2000yqh.googlegroups.com>
On Jan 25, 9:41 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> I am engaged in a discussion about moving from 10g --> 11g. The
> tablespaces in this particular 10G are all created with the manual
> segment space management. I am reading the blogs and am aware of all the
> troubles that ASSM can cause, ranging from wasting space to problems with
> the free lists and even some spurious corruption issues.
> However, Oracle made ASSM default in version 10g, and this project is
> about upgrading a large production DB. What are the opinions here? Does
> it make sense to go with manual SSM or should I go with ASSM?
>
> --http://mgogala.byethost5.com
We're running 11.2.0.2 with ASSM tablespaces and have found no issues in doing so. I will say that the client using this system (2-node RAC on Linux) has a pretty 'tame' system but it does tend to have heavy activity spurts during the year. Prior to that the system was on 10.2.0.4, again with ASSM, and no ill effects have been experienced. I've also read the blogs but, knock on wood, we're still unaffected by the reported issues.
David Fitzjarrell Received on Wed Jan 25 2012 - 12:00:31 CST