Re: ASSM bug: slow INSERT after uncomitted DELETE

From: ca111026 <ca111026_at_gmail.com>
Date: Mon, 10 Aug 2009 00:02:33 -0700 (PDT)
Message-ID: <64a49566-6df4-40ce-beff-5139b3452af1_at_d9g2000prh.googlegroups.com>

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? Received on Mon Aug 10 2009 - 02:02:33 CDT

This message: [ Message body ]
Next message: pitufo: "Re: What is an Active Session from the EM console point of view ?"
Previous message: Jonathan Lewis: "Re: Tested 11g OLTP compression and found rather serious issue"
Maybe in reply to: ca111026: "ASSM bug: slow INSERT after uncomitted DELETE"
Next in thread: Helma: "Re: ASSM bug: slow INSERT after uncomitted DELETE"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message