> The tables are not partitioned but we are using RAID 10 striped and = > mirrored. Are parallel and partitioning 'locked' together? Is their no = > value to parallel unless the tables are partitioned? We are moving = > toward it but haven't done it yet.=20 No, parallel and partitioning are NOT locked together. However, in some cases, using parallel operations on partitioned objects can give additional benefit (partition-wise joins etc..) Tanel. ---------------------------------------------------------------- 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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------