Re: points to be noted while creating a database,

[Quoted] Initial extent should be as large as you expect the table to be initially. [Quoted] The more extents the more job is needed by the database to search information.

[Quoted] Next extent should be a nice chunk of the initial extent. But if you know [Quoted] your data well, you might be low on this parameter on those table known not [Quoted] to grow so much, or not at all. Other tables could need large next extents.

[Quoted] I usually don't think about anything else in these cases.

Lars

Gerd Kock skrev i meddelandet <382c8cc2.22401345_at_news.btx.dtag.de>...
>Hi Antony,
>
>an Oracle database is no toy, you have learn something about the
>concept of Oracle:
>
>physical structure:
>- a tablespace consists of one or more data files
>
>logical structure:
>- data is always in an extent
>- contigous extents are called a segment
>- extents reside in an tablespace
>- space for storing data (rows) in a table is allocated in extents
>- at creation time of a tablespace you say what is the default extent
>size for data allocated
>- you can specify initial extent size, next extent size and optionally
>the percentage, how the extent size is increased every time an extent
>has to be allocated
>- if you don't specify storage parameters for a table, the defaults
>from tablespace are used
>- if no tablespace for table is specified, the default tablespace for
>the user creating the table is used
>- at creation time of database you have to specify system tablespace,
>- later you can (and should) create some tablespaces for data, index,
>rollback segments ans os on.
>
>there's much more, I don't know where to stop
>
>Gerd Kock
>info_at_no-spam.gerd-kock.de
>
>On Fri, 12 Nov 1999 15:40:50 -0500, "PSINet News Service"
><Antony.Amalraj_at_tpg.com> wrote:
>
>>Hi every body,
>>
>> I am new to oracle 8i. I have to create a database with 200 tables,
>>of Object-Model, Not a data-model. for development environement
>>I am just wodering what are all the points to be noted while creating
table
>>space & table. could you please, summerise some plan with
>>what could be the value for below parameters for transaction, temp,&
>>master tables & tbspace.
>>
>> Initial extent, next extent, pctincrease, pctused,
>>
>>thanks in advance
>>tony
>>
>>
>
Received on Sat Nov 13 1999 - 13:42:16 CET