Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Partition questions

Re: Partition questions

From: Tom Pall <>
Date: Wed, 13 Sep 2000 17:44:27 -0500
Message-Id: <>

Though I'm late, I'll reply anyway.

We have Partitioning option. It is both a bane and a boon. A bane, because there are many ora-600 problems which revolve around partitioned tables with partitions. Of course they will be fixed in the next patch. I had and have the problems in Oracle 8.0.5 all the way through 8.1.6. The fix is promised in 8.1.7. But it seems everything is promised for 8.1.7.

We do range partitioning. They do speed up queries, if the key can be used to eliminate partitions. Many queries cannot.

If you have a global index, you have a problem when you split or drop partitions. Further, you can't have index partition elimination.

If you have local indexes, queries in which partition elimination can't be done, then Oracle has to touch each of your local partitions.

Space management of partitions can be a challange. It's a lot simpler with locally managed tablespaces or partitions nearly the same size or at least of predictable size.

We don't have a need, yet, for the more exotic types of partitions. ----- Original Message -----
From: Bill Becker <> To: Multiple recipients of list ORACLE-L <> Sent: Tuesday, September 12, 2000 4:17 PM Subject: Partition questions

> Hello,
> We are a small, but growing data warehouse using Oracle
> 8.1.6 on Solaris 2.7. We have several tables whose size
> exceeds 1 GB, and are considering purchasing the
> partitioning option from Oracle.
> Questions:
> 1) Which partitioning method do you most commonly use,
> range, hash or composite?
> 2) What happens when an existing row in partition A receives
> an update which changes a partition key field to make it
> a member of partition B?
> 3) Has the use of partitioning improved the performance of
> your applications?
> 4) Has the use of partitioning made the DBA's job simpler
> or more complex?
> 5) Bottom line: do you feel the benefits of partitioning
> were worth the extra cost?
> Any other comments, guidelines, advice, etc. is/are appreciated.
> Thanx to all who take the time to respond.
> Bill Becker
> Marshfield, Wisconsin USA
> --
> Author: Bill Becker
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: (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 13 2000 - 17:44:27 CDT

Original text of this message