Re: Altering Freelist Groups in 10gR2 ?

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Wed, 27 Sep 2006 08:41:10 -0400
Message-id: <1159360870l.5902l.0l@medo.noip.com>

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
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 27 2006 - 07:41:10 CDT