Re: ASSM worth it?

From: Geomancer <pharfromhome_at_hotmail.com>
Date: 17 Dec 2003 16:18:36 -0800
Message-ID: <cf90fb89.0312171618.8beae06@posting.google.com>

"TomT" <dontspam_at_spam.com> wrote in message news:<7P0Eb.24$Nk4.25847_at_news.uswest.net>...
> We are getting ready to upgrade from 8i to 9i. Since we have over 300GB,
> there may be no time to do an export/import; therefore, we are considering
> using the migration tool to upgrade in place. If we do the upgrade in
> place, we will not get the 9i enhancement ASSM (auto segment space
> management). Any thoughts on the downside of this? Thanks.

Do you have segment header contention?

Do you have multiple freelists of freelist_groups defined?

This article might help:

http://builder.com.com/5102-6388-5031994.html Received on Wed Dec 17 2003 - 18:18:36 CST