Re: TABLESPACES

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Thu, 4 Nov 1999 13:57:11 GMT
Message-ID: <382190B7.C4061746@edcmail.cr.usgs.gov>

Pinne wrote:
>
> Hi,
> Running Oracle 8.0.5 on Linux and Sun Solaris,
> and need some advice on space allocation.
>
> Is it better to use one single TABLESPACE for an application,
> or to create separate ones for data, index and temporary storage ?

It is better to create separate tablespaces for your data, indexes, and temp storage. By doing so, you can put each datafile on different disk devices for better performance.

> Now, if i keep it in a single space, should i use that same space for
> temporary storage too,
> or let it default to the SYSTEM space ?.

You should never use the SYSTEM tablespace for temp storage. Create a TEMP tablespace and make sure all users default their temporary tablespace to this one (ALTER USER username TEMPORARY TABLESPACE temp;). The SYSTEM tablespace should only be used for data dictionary tables (and any other tables owned by SYS and SYSTEM).

HTH,
Brian Received on Thu Nov 04 1999 - 07:57:11 CST