I have found the CBO makes very poor choices when partitioned tables have parallel set as a default. It really favours full tablescans. Mike ----- Original Message ----- From: "Tanel Põder" <tanel.poder.003@xxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, August 03, 2004 11:36 AM Subject: Re: Oracle 9.2.0.5 "10046" Tracing Causes Server Crash on Windows 2000? > > Have you good advace how to disable parallel operations usage by CBO if > > input conditions are: > > Alter all your tables (and indexes) 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 -----------------------------------------------------------------