| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Best Practice - Partitioned object, one partition per tablesp
What if working on limited I/O so that striping is done at the OS level mostly. In this case there is no advantage to one partition - one tablespace and if there are many partitions it just gets hard to maintain. Partition elimination without separate I/O is the advantage of partitioning along with local indexes which is not dependent on the partitions tablespace. Therefore, I have grouped historical partitions into one tablespace then created separated tablespace on the most accessed partitions - say last 10 years. I find this easier to manage.
-----Original Message-----
From: Freeman, Robert [mailto:Robert_Freeman@csx.com]
Sent: Wednesday, September 25, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Best Practice - Partitioned object, one partition per
tablespace,
We currently are creating partitions of a given table in individual
tablespaces (1 partition = one tablespace). To me, this seems like a
reasonable practice. Anyone have any thoughts about this they would like the
share?
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
The avalanche has begun, It is too late for the pebbles to vote.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: Robert_Freeman@csx.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Paula_Stankus_at_doh.state.fl.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Sep 25 2002 - 14:38:33 CDT
 |
 |