Re: ASSM bug: slow INSERT after uncomitted DELETE
From: Helma <helma.vinke_at_hotmail.com>
Date: Mon, 10 Aug 2009 08:19:29 -0700 (PDT)
Message-ID: <2737cf04-1cea-4e38-b39d-d32a7cc0eb45_at_v2g2000vbb.googlegroups.com>
On Aug 10, 9:02 am, ca111026 <ca111..._at_gmail.com> wrote:
> Thanks for explanation.
>
> So how freelists work? Why we don't have this issue with non-ASSM
> tablespaces?
>
> Also, what are advantages of ASSM? I can see advantages of Locally
> Managed Tablespaces:
> - Less load on SYSTEM
> - DROP or TRUNCATE of tables/indexes with thousands extents is much
> faster
> - If locally managed tablespace is created with uniform extent size
> then there is no fragmentation - all free space is in chunks
> of "right" size.
>
> However what as advantages of ASSM?
Date: Mon, 10 Aug 2009 08:19:29 -0700 (PDT)
Message-ID: <2737cf04-1cea-4e38-b39d-d32a7cc0eb45_at_v2g2000vbb.googlegroups.com>
On Aug 10, 9:02 am, ca111026 <ca111..._at_gmail.com> wrote:
> Thanks for explanation.
>
> So how freelists work? Why we don't have this issue with non-ASSM
> tablespaces?
>
> Also, what are advantages of ASSM? I can see advantages of Locally
> Managed Tablespaces:
> - Less load on SYSTEM
> - DROP or TRUNCATE of tables/indexes with thousands extents is much
> faster
> - If locally managed tablespace is created with uniform extent size
> then there is no fragmentation - all free space is in chunks
> of "right" size.
>
> However what as advantages of ASSM?
You may have a look at the book by Tom Kyte : " Effective oracle By Design". He explains with statspack reports the impact of several oracle features. Page 232 - 234 are called : The Case for ASSM. Received on Mon Aug 10 2009 - 10:19:29 CDT