Re: Tablespaces and Datafiles

Hallo Ermina,

nice question, but I try to answer...

if it is a medium db, I suggest that 100 MB for Data is enough. If not, take double of it or the half. Do the following:

SYSTEM 100 MB
TEMP 50 MB

TB_DATA 100 MB
TB_INDEX 100 MB  -- different disk to DATA!
TB_ROLLBACK 50 MB -- different disk to the redologs if possible

if you create a user, do the following:

create user ERMINA identified by PASSWORD default tablespace DATA temporary tablespace TEMP

Create all tables useing the schema ERMINA

if you create an index, use

CREATE INDEX... TABLESPACE TB_INDEX !!! Do the rest I mentioned in

http://www.hoffmann-kiel.de/stdinst.html

to tune and optimize the installation.

Never use default autoextending cause the tablespaces could be fragmented and you have no control over space-growth.

If you use autoextend, put it to a limit, that your disk will allways have enough space to perform a reboot!

Hope that helps!

Bye
Uli

> I have the default database installed under NT, and via the Storage
> Manager, I saw the following, concerning tablespaces and datafiles:
>
> Default datafiles Tablespace Status Size Used
>
> rbs1orcl.ora ROLLBACK_DATA ONLINE 10M 5M
> sys1orcl.ora SYSTEM SYSTEM 60M 55,154M
> tmp1orcl.ora TEMPORARY_DATA ONLINE 2M -------
> usr1orcl.ora USER_DATA ONLINE 8M 6,8M
>
> All datafiles have autoextend option set to ON. So I don't have to
> worried about the size, do I?
>
> I want to create a second database (via Database Assistant). Can you
> suggest what size to input when asking about tablespaces (INDEX, USR,
> TEMP, etc). The database will be a medium one.
>
> Thanks,
>
> Ermina
>
>
Received on Fri Nov 12 1999 - 11:41:51 CST