Re: Altering Freelist Groups in 10gR2 ?

  • From: Mladen Gogala <mgogala@xxxxxxxxxxx>
  • To: jonathan@xxxxxxxxxxxxxxxxxx
  • Date: Wed, 27 Sep 2006 08:41:10 -0400

On 09/27/2006 05:47:14 AM, Jonathan Lewis wrote:
> The only option is to do the CTAS, as the freelist group
> blocks are located immediately after the segment header
> block in the first extent.
> The only other option to consider is 'alter table move' to
> move the table into a tablespace defined to use ASSM
> and forget about freelist groups - but I'm not very keen
> on ASSM for high-performance, high-concurrency systems
> myself.

Jonathan ASS managed tablespaces are the default with Oracle 10.2. Except for 
the much
more scattered blocks and slowdowns with full table scans, what other problems 
did you
observe with ASS managed tablespaces? Why did you say "high concurrency"?

Mladen Gogala


Other related posts: