I'm assuming that you're running Oracle 8i;
Do not loose your time in sizing tables and indexes
using complex formulas.
Create the table, fill it with around 1000
representative rows. Check the space used by these
and extrapolate for the planned number of rows.
For the tablespaces, use them to split IO then use
them to hold objects of the same nature and size.
If you want, you can put only one table in a
tablespace if the table is big. You can also partition
a table and have each partition in its own tablespace.
Manage the storage parameters at the tablespace level,
not at the object level. Do you want to spend days
adjusting storage for each objects in each environment
? I don't.
Having objects with more than one extent will not put
the system on its knees .
Regards
- "Manivannan.M" <manivannan.m_at_tatainfotech.com> a
écrit : > Hi list
>
> We are in a dilemma over a database creation for an
> application
>
> We have created a database (having 8 tablespaces --
> application related
> only) .When we are actually sizing and creating the
> tables and indexes in
> these tablespaces, we are confused as to how these
> should be created.
>
> We were told by some people that Oracle does not
> recommend creation of
> INITIAL and NEXT segments for the database objects
> and it should take the
> default size of the tablespace as the segments
> should be uniform size.
> We were told by some others that specifying
> INITIAL and NEXT is very
> important for all the tables and indexes , esp for
> the tables growing
> rapidly growing in size(say at the rate of 7000
> records/day with row size
> around 700 bytes/record).In the case of large tables
> like these, can we
> do away with INITIAL and NEXT extents and instead
> specify MINEXTENTS
> value as 40 or 50?
>
> Waiting for your valuable inputs!!
>
> Thanks in Advance..
>
>
> Manivannan
> Muthukrishnan.
>
>
> ADDRESS: E-MAIL:
> 68/4, Site no:3,
> manivannan.m_at_tatainfotech.com
> 80 Feet road,
> (opp) Deccan Studio,
> Indiranagar, PHONE:
> Bangalore - 560038. 5284681
> Ext: 464
>
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Manivannan.M
> INET: manivannan.m_at_tatainfotech.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Received on Thu Jan 25 2001 - 09:04:58 CST
