RE: anyone ever use sub-partitioning?

So you have average row size =3D 1 ?

Waleed

-----Original Message-----
From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx]
Sent: Friday, April 30, 2004 10:27 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: anyone ever use sub-partitioning?


We have a table which is about 8GB with about 8 billion records. We add =
deltas to the file daily(inserts,updates,deletes).

We are considering paritioning this table so we can use parallel DML. We =
are considering partitioning on the primary key to about 10-20 =
partitions.=20

Has anyone used hash sub-partitioning? What are your experiences with =
that? I'd like to have granularity smaller than 400-800 MB per =
partition.=20

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: