| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
