Re: Space Usage Question

From: <rc_at_die@you@!spammers.sandworm.demon.co.uk>
Date: Wed, 28 Jan 2004 19:47:49 +0000
Message-ID: <nd4g10tge9pcan6fsp5rsiv4in879kha8j@4ax.com>

On Wed, 28 Jan 2004 10:18:57 -0800, Daniel Morgan <damorgan_at_x.washington.edu> wrote:

>spam_at_no-spam.com wrote:
>>
>> The table defination is
>> TABLESPACE BHF
>> PCTFREE 10
>> PCTUSED 40
>> INITRANS 1
>> MAXTRANS 255
>> STORAGE (
>> INITIAL 65536
>> MINEXTENTS 1
>> MAXEXTENTS 2147483645
>> FREELISTS 1 FREELIST GROUPS 1 )
>>
>> According to our stats the table span 223 extents, But that does not
>> make sense to me, because that mean each exten size is approx 11MB ?
>>
>> Can any one in the know please explain. I am new to oracle, so please
>> do not flame me if the answer is ovious
>
>Go with Brian's response to your inquiry but I take a serious look at
>your PCTFREE and PCTUSED. These are default values that likely have
>absolutely nothing to do with your data.
>
>Seriously reconsider these values ... you are likley wasting a lot of disk.

For performance would I be better off with UNIFORM exten of 64M ? Received on Wed Jan 28 2004 - 13:47:49 CST