Re: Predicting physical disk space.

Thanks Sybrand..

I have a better picture of things now.

Thiko!

In article <961962937.22155.2.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jun 25 2000 - 00:00:00 CDT