Re: Predicting physical disk space.

To get the complete picture
A tablespace consists on the physical size of datafiles. The size of the datafiles is stored in the dba_data_files view. A tablespace also consists of segments. The dba_segments view will show you how much space has been *allocated* to an object. The unused extents of a tablespace are reported in the dba_free_space view. Never tried it, but the sum of allocated bytes per tablespace in dba_segments plus the sum of free bytes per tablespace in dba_free_space should always equal the number of bytes per tablespace in dba_data_files minus 1 Oracle block.
So, yes, knowing the size of the data_files is sufficient.

Hth,

Sybrand Bakker, Oracle DBA

<thiko_at_my-deja.com> wrote in message news:8j5it0$s87$1_at_nnrp1.deja.com...
> Thanks to those who helped before....
>
> I'm in a situation where the new predicted growth in database storage
> is going to be approx.5MB per week for this particular project. To
> check that we have enough disk space I would do this by what means?
>
> In general do the total sizes of tablespace files correspond
> to/represent the SAME size on the databases physical disks? In which
> case is it something simple like getting the size of the physical disks
> and taking away the sizes of the tablespace datafiles and that will
> give the amount of disk space one has free? Or does it have to do with
> all the blocks, extents, segments etc involving some calculation to
> work out disk space? And to get the size of tablespaces do you add up
> all the sizes of the objetcs within the tablespaces such as tables,
> indexes etc..???
>
> I know how to get this data I've mentioned if it is the right way to go
> about things.
>
> Basically I need to know the method for finding out if we are going to
> need more physiacl disks before I implement the new projects database
> objects.
>
> Thanks in advance.
>
> I'll get it one day :) .
>
> Thiko!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Jun 25 2000 - 00:00:00 CDT