Re: Database Size?

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:45:20 CDT