Re: ASSM and tablespace fragmentation in a table that adds 140,140 partitions/subpartitions per year
From: Fergal Taheny <ftaheny_at_gmail.com>
Date: Tue, 7 May 2013 20:12:23 +0100
Message-ID: <CAOuMUT6Waj32yTrr4_X2JgOfStq3ApsKbpqbjMWSnjE+UNOiXg_at_mail.gmail.com>
I generally use uniform extents and not the autoallocate extents. Maybe when you observed the 8 meg partitions it was bacause you had 8 subpartitions?
Date: Tue, 7 May 2013 20:12:23 +0100
Message-ID: <CAOuMUT6Waj32yTrr4_X2JgOfStq3ApsKbpqbjMWSnjE+UNOiXg_at_mail.gmail.com>
I generally use uniform extents and not the autoallocate extents. Maybe when you observed the 8 meg partitions it was bacause you had 8 subpartitions?
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 07 2013 - 21:12:23 CEST