Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with Data File Size
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".
>
>
>
Received on Wed Aug 22 2001 - 09:10:50 CDT