Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: parallel query waitevents

RE: parallel query waitevents

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Fri, 9 Apr 2004 13:38:09 -0400
Message-ID: <D91D9D5A73FC694BBC52F1EB26AD410F02780CF3@MSGBOSCLD2WIN.DMN1.FMR.COM>


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_at_vrijuit.nl] 
	Sent: Fri 4/9/2004 10:24 AM 
	To: 'oracle-l_at_freelists.org' 
	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_at_freelists.org 
	put 'unsubscribe' in the subject line. 
	-- 
	Archives are at http://www.freelists.org/archives/oracle-l/ <https://access0.fidelity.com/archives/oracle-l/,DanaInfo=www.freelists.org+>  
	FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html <https://access0.fidelity.com/help/fom-serve/cache/1.html,DanaInfo=www.freelists.org+>  
	----------------------------------------------------------------- 


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org 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
-----------------------------------------------------------------
Received on Fri Apr 09 2004 - 12:34:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US