Re: Space Usage Question

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.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)