You have parallel_max_servers set to a value greater than zero. Probably you have some tables that have degree set to default. Waleed -----Original Message----- From: Jeroen van Sluisdam [mailto:jeroen.van.sluisdam@xxxxxxxxxx] Sent: Fri 4/9/2004 10:24 AM To: 'oracle-l@xxxxxxxxxxxxx' Cc: Subject: RE: parallel query waitevents SQL> show parameter parall NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ fast_start_parallel_rollback string LOW log_parallelism integer 1 parallel_adaptive_multi_user boolean FALSE parallel_automatic_tuning boolean FALSE parallel_execution_message_size integer 2152 parallel_instance_group string parallel_max_servers integer 5 parallel_min_percent integer 0 parallel_min_servers integer 0 parallel_server boolean FALSE parallel_server_instances integer 1 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ parallel_threads_per_cpu integer 2 recovery_parallelism integer 0 But see my own repy also problem was due to create table with parallel option enabled and degree was specified on default. Didn't check everything developers did, I know should do that !! Tnx, Jeroen ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com <https://access0.fidelity.com/,DanaInfo=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/ <https://access0.fidelity.com/archives/oracle-l/,DanaInfo=www.freelists.org+> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html <https://access0.fidelity.com/help/fom-serve/cache/1.html,DanaInfo=www.freelists.org+> ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis -- -- Type: application/ms-tnef -- File: winmail.dat ---------------------------------------------------------------- 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 -----------------------------------------------------------------