Title: RE: Degree of Parallelism: 0?
Hi Brian, thanks for your response.
parallel_min_servers isn't set.
Well I'm just not going to worry about it then, as long as it's not pinning my CPU's.
Thanks
Lisa
-Original Message-
From: Brian Wisniewski [mai
Lisa, are the servers actually running or are the idle? If you have
parallel_min_servers set to something other than 0 then you will still
see the servers in v$pq_sysstat they will just remain idle.
I'm not sure about the degree 0, I was thinking it was the same as 1
(no parallelism) but I tried
Title: Degree of Parallelism: 0?
Hello all,
I've purposely got PQO off. But I was shocked to see I've got some parallel query slaves out there. I checked to see which objects they are, listed below. I'm not concerned about the sys/system stuff, I"m worried about CTX