I need to be more specifc, In my case all of my partitioned tables have a degree of 1 ie. no parallel. If a query fires off on the table which doesn't use a global index or if the partitioned key is specified then the query will serialize. So if a user specifies where jack = 'NONE' and I don't have a bitmap index on jack then the query will serialize. If I put a local bitmap index on jack and the partitioned key is not specified in the query then a parallel index probe into each local index. Mike ----- Original Message ----- From: "Tanel Põder" <tanel.poder.003@xxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, August 03, 2004 12:10 PM Subject: Re: Oracle 9.2.0.5 "10046" Tracing Causes Server Crash on Windows 2000? > > Queries will automatically go in parallel if you have partitioned tables > and > > your queries don't use the partition key unless you use a global index. I > > Where does this information come from? When all tables/indexes *accessed* by > a query are NOPARALLEL, then the query is executed serially by default. (I > emphasized "accessed" since there are cases like table having parallel > degree, but an index on it doesn't then if the query can be satisfied by > reading only for index, table's degree is ignored and indexes one is used). > > Btw, alternatively you may want to "alter session disable parallel query" > (or parallel dml) for your sessions to set the default to noparallel. > > 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 -----------------------------------------------------------------