Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple or Single tablespace

Re: Multiple or Single tablespace

From: James Hanway <hanwayj_at_dfo-mpo.gc.ca>
Date: Fri, 12 Nov 1999 12:56:44 GMT
Message-ID: <382C0EA0.8672DA28@dfo-mpo.gc.ca>


Having multiple tablespaces lets you spread your I/O load over more disk spindles.

Parker Sorenson wrote:

> What are the benefits/pitfalls for using multiple or single tablespaces
> in a db system design?
>
> i.e. have 1 huge tablespace with several tables, OR have a few smaller
> tablespaces each with related tables...
>
> help is much thanked
> -p
Received on Fri Nov 12 1999 - 06:56:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US