Re: High Version Count with usage of Parallel Query
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Tue, 6 Jul 2010 12:39:08 -0700
It's not a good idea to mix PX/PQ with binds. That is a recipe for problems.
On Tue, Jul 6, 2010 at 8:27 AM, Hemant K Chitale
<hkchital@xxxxxxxxxxxxxx> wrote:
>
> I 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.
>
> These queries use Binds and not Literals. The statements are exactly the
> same. These are not Bind - mismatches (whether being mismatched datatype or
> varying lengths of actual bind values) and are not different accounts and
> schemas. These are not created by the usage of Explain Plan.
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
