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 -> Single, Locally Managed system managed tablespace

Single, Locally Managed system managed tablespace

From: <Number.One.Mike_at_gmail.com>
Date: 19 Jan 2007 08:42:15 -0800
Message-ID: <1169224935.015655.323870@v45g2000cwv.googlegroups.com>


For the evoloution of our product we are considering moving to a single system managed tablespace. The application is a very straight forward OLTP system, while it has a lot of tables none of them are big (half a million on a couple). There are two notable exceptions to this, where Documents and notes are stored, these (especially the document one) can get very big (but not always). At the moment we are going to go for a single Tablespace but advise that if they plan to hold lots of documents or lots of adhoc notes then they may wish to move these tables to a seperate tablespace.

Can anyone give reasons why this would not be a sensible thing to do? Would you bulk if given this advice when implementing a new OLTP system? Do people still like Data / Index / LOB on seperate TS's for administration reasons?

Thanks in advance,

Mike. Received on Fri Jan 19 2007 - 10:42:15 CST

Original text of this message

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