Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Size?
We have very large roll-back segments setup - I dont know how Oracle treats
Rollback, but we have the segments R01, R02, R03 etc and SYSTEM - The R*
segments have been allocated over 1gig each - Does Oracle actually TAKE up
that 1gig, or does it only fill when data is in it? Thanks,
-Nick
"Maurice E. Jarrell" wrote:
> Nick <nick_j_at_mailcity.com> writes:
> > We have an Oracle server, with OAS, Oracle RDBMS 8.0.5 and around 1gig
> > worth of data loaded, yet all of this is taking up in excess of 5gig on
> > the server. Any ideas as to why or what could be taking up all this
> > space? Thanks,
>
> This sounds like mis-allocation of space. Tons of things could be
> at fault, not the least of which is that you could create a
> tablespace with hundreds of Gig. of allocated space in it,
> and not have any data at all. Oracle isolates physical
> disk allocation from logical data storage *sort of*.
>
> Beyond that, things like mis-sized clusters can add lots
> of wasted space. Oracle pre-allocates space for each
> cluster key. If you pre-allocate too much, then you
> get lots of allocated space for an object which is really
> just taking up disk.
>
> Similarly, the storage parameters ( initial extent, next
> extent, pctincrease ) for any object could be
> too high. Again, allocated space for no data.
>
> Are there indexes for this 1 gig of data? A lot of indexes =
> a lot of index space and another chance for
> mis-allocation.
>
> dba_data_files tells you how big each datafile is.
> dba_segments tells you how much space is allocated to each object.
>
> > P.S It seems no one answers questions on this newsgroup - where is
> > everyone :)
>
> signal/noise approaching zero.
Received on Mon Oct 25 1999 - 00:52:18 CDT