Home » Server Options » RAC & Failsafe » Reg-Oracle Parallel Query
Reg-Oracle Parallel Query [message #74908] Thu, 12 August 2004 23:19
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: urgent creating db on solaris out of memory
Next Topic: RAC OCFS LINUX PROBLEM VERY URGENT
Goto Forum:
  


Current Time: Mon Dec 06 12:32:18 CST 2021