Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: points to be noted while creating a database,
In article <LX_W3.34$R14.1703_at_client>,
"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
>
>
Hi
Doing all U've asked for is a lot of time, so I'll write only the
highlights.
Tablespace are logical 'get together' of tables with similar
functionality, it's an applicative grouping. Example : all the
referential codes (small tables of codes) , are usually grouped into
ref_codes_tbs. In tablespaces U also use to diffrentiate indexes from
data. So, there is the data_tbs and data_indexes_tbs on diffrent disk
devices.
Initial, next usually contain the same value, example : initial 10M,
next 10M. Usually U keep the same value of segment (10M, exmaple) in the
tablesapce in order to use the tablesapce more efficiantly.
pctused+pctfree=95, a general role (it's in percent).
For tables which rows are usually not enlarged use: used 85, free 10.
For tables with streched rows use : user 70, free 10.
Streched rows are those with long varchar2 and such.
To know all U've asked for take a lot of reading and experiance, so take
your time and meanwhile learn from your mistakes.
Recomended books : Oracle8 DBA handbook, Oracle8 the complete reference,
Oracle database administration.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sun Nov 14 1999 - 03:11:53 CST