Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Database Sizing doubts..
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
![]() |
![]() |