Home » RDBMS Server » Performance Tuning » reg parallel processes in oracle
reg parallel processes in oracle [message #65369] Wed, 25 August 2004 21:08
Victoria
Messages: 152
Registered: July 2002
Senior Member
Hi,

  We have an oracle instance with

parallel_max_servers=8

parallel_min_servers=4

I want to know is this the right place(or parameter) to decide the number of parallel slave processes allowed for this instance,so that i can set the degree to 4 in my queries.

Moreover if i use degree as 4 in my parallel hint will the query execute parallely with 4 parallel slave processes.Please guide me.

Note:my table which is queried is a partitioned table
Previous Topic: Hardware purchase decision
Next Topic: wait event "SQL*Net message from dblink" for a Siebel7 Oracle 9.2.0.4
Goto Forum:
  


Current Time: Tue Apr 16 07:55:03 CDT 2024