Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Estimating the size of an istance

Re: Estimating the size of an istance

From: Nicky <fuffaspam_at_quipo.it>
Date: Tue, 3 Aug 2004 09:33:56 +0200
Message-ID: <cenf2o$8tb$1@newsserver.cilea.it>


thank you !

"Paul Drake" <bdbafh_at_gmail.com> wrote in message news:910046b4.0408022212.60036aa9_at_posting.google.com...
> "Nicky" <fuffaspam_at_quipo.it> wrote in message
news:<celnk6$48$1_at_newsserver.cilea.it>...
> > Hello !
> >
> > Do you know if there is a formula (or something similar) to estimate the
> > size that an instance^H^H^H^H^H^H^H^H database 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
>
> Load some data and find out:
>
> pre-requisite pre-install tasks
> install the oracle database server software
> patch
> create a listener
> create database
> create the schema
> grant some roles, privs to it
> create some tables, say pctfree 1
> load some test data into tables (sqlldr, imp, ctas)
> create the appropriate indexes
> gather schema stats
> (exec dbms_stats.gather_schema_stats(ownname=><schema_name>,
> cascade=>true);
> examine user_tables, user_indexes
>
> adhoc untested, but this should give you the general idea:
> select table_name, rpad('1TABLE',30), blocks,
> round(num_rows/(blocks-empty_blocks),1) avg_rows_per_block
> from user_tables
> union all
> select table_name, index_name, leaf_blocks,
> round(num_rows/leaf_blocks,1) avg_rows_per_block
> from user_indexes
> order by table_name, index_name;
>
> document it.
> burger and beer time.
>
> If you want to go into more detail, check out the vsize function.
>
> -bdbafh
Received on Tue Aug 03 2004 - 02:33:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US