An update on this :Setting DEGREE 1 and/or creating the right index so as to have the optimizer use an Index Range Scan instead of Parallel FullTableScan has "resolved" the high version count.
Date: Tue, 06 Jul 2010 23:27:33 +0800 To: oracle-l@xxxxxxxxxxxxx From: Hemant K Chitale Subject: High Version Count with usage of Parallel QueryI have a few queries that are wrongly using PQ (by having a Parallel DEGREE set on the Tables). Unfortunately, they run very frequently, from multiple sessions.Not always do they get the requisite number of PQ slaves. I will be getting these change to No-Parallel operations.
<deleted> Hemant K Chitale http://hemantoracledba.blogspot.com -- http://www.freelists.org/webpage/oracle-l