Re: Partitioning vs. Disk striping

Ron Boggs wrote:

> My question is, in 'general', is striping the data and indexes across
> a 6 disk array enough to prevent bottlenecks at the disk or is it
> better to use Oracle partitioning to address this? Is one solution
> better at mixed read/write vs. 'nearly' all writes?

There are a number of secondary reasons for Oracle Partitioning >Option<

1. If partitioning can be done by time, you can archive old info with minimum maintenance impact
2. You generally store different partitions in different tablespaces and therefore backup/restore/tablespace maintenance -
3. can be done on a partition without shutting down entire table.
4. can be done on a smaller data set, shutting table down for shorter time
5. If DML can identify a partition, data manipulation will be faster
6. While partitioning & parallel opes are somewhat independent, partitioning can leverage parallel ops for performance boost.

There are other reasons, but IMHO, if all you want is faster disk operations then go with the striping, whereas if you want faster data operations you may benefit from partitioning - or both.

/Hans Received on Tue Apr 08 2003 - 16:36:47 CDT