Re: Estimating the size of an istance

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 3 Aug 2004 12:54:48 +1000
Message-ID: <410efe4c$0$4754$afc38c87@news.optusnet.com.au>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1091499137.211469_at_yasure...
> Nicky wrote:
>
> > Hello !
> >
> > Do you know if there is a formula (or something similar) to estimate the
> > size that an instance of oracle could growth ?
> >
> > I can calculate the size of the data I insert in the database, but I
don't
> > know how oracle stores it in the file system
> >
> > Thanks a lot
>
> An Oracle instance has zero size.

Now, I know you don't mean that, since an instance must comprise at least three granules.

HJR
>
> Would you by chance mean a database? And if you do mean a database do
> you mean just the datafiles or also the system datafiles, undo
> datafiles, tempfiles, control files and log files or just those files
> holding schema data?
>
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
>
Received on Mon Aug 02 2004 - 21:54:48 CDT