Re: storage problem

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 11 Apr 2003 00:10:21 +1000
Message-ID: <BLela.11305$1s1.176848@newsfeeds.bigpond.com>

"Yun Guan" <yguan_at_houston.rr.com> wrote in message news:KaMka.46909$rd4.1480568_at_twister.austin.rr.com...
> I have one table anaylyzed using "compute statistics". It has 2774
Blocks,
> which spans over 3 extents, chain_cnt=0, block_size 8192, ave_row_len=47.
I
> decided to move all data into one larger extent. So I dropped the table,
> recreate the table with initial extent = 22M (> 2774 x 8/1024) with all
> other storage parameters unchanged. After re-analyzing it, the table has
> 3015 blocks and spans over 2 extents. I could not figure out why the block
> number increases with chain_cnt =0. It spans over 2 extents, not 1 extent
> as I expected.
>

Hi Yun,

This is one of those "but why" questions.

Why do you want to recreate your table to use 1 extent rather than 3 ?

Why do you want to create oddly sized extents ?

Why aren't you using locally managed tablespaces ?

OK, it's actually three of those "but why" questions ;)

Cheers

Richard Received on Thu Apr 10 2003 - 09:10:21 CDT