Re: Help with Data File Size

PCTincrease of 50%. looks like your culprit to me. This means every time a new extent is allocated it will be 50% larger than the previous one. This would be compounded if the table suffered frequent deletes and batch loads using sqlloader direct path.

I'd be quite tempted to export the db, drop the tablespace and recreate as a locally managed tablespace with uniform extent sizes and reimport.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Howard Carr" <hcarr_at_cb.kruger.com> wrote in message
news:a4Pg7.25844$Nc3.2653989_at_news20.bellglobal.com...


> This is for the largest table that has 15500 records with an average row

> length of 59.

> It uses 139 data blocks out of 710400.

>

>   TABLESPACE QDATA

>   PCTFREE 10

>   PCTUSED 40

>   INITRANS 1

>   MAXTRANS 255

>   STORAGE (INITIAL 40960

>     NEXT 761856

>     MINEXTENTS 1

>     MAXEXTENTS 505

>     PCTINCREASE 50

>     FREELISTS 1

>     FREELIST GROUPS 1)

>

>

> "Chuck Hamilton" <chuck_hamilton_at_yahoo.com> wrote in message

> news:9m0dtu$blsk4$1_at_ID-85580.news.dfncis.de...

> > "Howard Carr" <hcarr_at_cb.kruger.com> wrote in message

> > news:%EOg7.25444$Nc3.2640738_at_news20.bellglobal.com...

> > > I have a new database created on a new Oracle installation (8i on

> Win2000)

> > > on 8GB hard drives. The database has several tables which have only

just


> > > started to be used.

> > > The biggest table has  15,550 rows at an @ row size of 60.

> > > The problem is that the data file is showing 5.5GB, and can't create

any


> > > more extents because the disk is full.

> > > What has caused the database to reflect this much storage requirement?

> > > How do I fix the problem?

> > > I estimate that I have no more than 10MB of info in all the tables.

> > >

> > > Thanks for your help.

> >

> >

> > Can you extract the DDL for the table(s) in question and post it? There

> may

> > be a problem with pctfree/pctused, but it's unlikely that it would cause

> > this much wasted space on a table that's "just started to be used".

> >

> >

> >

>

>