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

Home -> Community -> Mailing Lists -> Oracle-L -> Database Sizing doubts..

Database Sizing doubts..

From: Manivannan.M <manivannan.m_at_tatainfotech.com>
Date: Thu, 25 Jan 2001 15:32:18 +0530 (IST)
Message-Id: <10752.127449@fatcity.com>


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
------------------------------------------------------------------------------ 
Received on Thu Jan 25 2001 - 04:02:18 CST

Original text of this message

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