Re: Database Sizing doubts..

From: Tim Sawmiller <sawmillert_at_state.mi.us>
Date: Thu, 25 Jan 2001 07:25:46 -0500
Message-Id: <10752.127464@fatcity.com>

Ideally, you should segregate the small, static tables from the large, = growing tables into different tablespaces. Then you could have a standard = tspace initial/next value to correspond to the type of items found in the = tspace. So, for instance, in your type_and_code_tables tablespace, = initial/next could be something like 32k/32k. In your large_and_growing_ta= bles tablespace, initial/next could be something like 10m/10m.

>>> manivannan.m_at_tatainfotech.com 01/25/01 04:51AM >>>
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.. =20

                                        Manivannan Muthukrishnan.

---------------------------------------------------------------------------=
--
    ADDRESS:                             E-MAIL:
    68/4, Site no:3,                     manivannan.m_at_tatainfotech.com=20
    80 Feet road,                       =20
    (opp) Deccan Studio,
    Indiranagar,                         PHONE:
    Bangalore - 560038.                  5284681  Ext: 464
---------------------------------------------------------------------------=

---=20

=20

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Manivannan.M
INET: manivannan.m_at_tatainfotech.com=20

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). Received on Thu Jan 25 2001 - 06:25:46 CST