Re: kkslce [KKSCHLPIN2] mutex contention on hard parse of PQ with binds

SELECT /*+ parallel(AV,4) full(AV) */ AV.ATTRIB_VALUE   from retven_attrib_value av
 where av.retailer_vendor_key = :B2
/

And we're still seeing huge waits:

POC2CC1_p021_20398_MAN3.trc:WAIT #47097645114664: nam='cursor: pin S wait on X' ela= 146685 idn=1536799127 value=25769803776 where=21474836480 obj#=-1 tim=1442317596770271
POC2CC1_p022_20400_MAN3.trc:WAIT #47408974734632: nam='cursor: pin S wait on X' ela= 146505 idn=1536799127 value=25769803776 where=21474836480 obj#=-1 tim=1442317596770254
POC2CC1_p023_20402_MAN3.trc:WAIT #47208074585384: nam='cursor: pin S wait on X' ela= 146383 idn=1536799127 value=25769803776 where=21474836480 obj#=-1 tim=1442317596770255

Stefan

On Tue, Sep 15, 2015 at 6:32 PM, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk
> wrote:

>
> Herald,
>
> Interesting that if you search MoS on that bug number the first bug that
> appeared on my listing referencing that as the base bug was:
>
>
> Bug 17950283: HIGH PARSE TIME ELAPSED AND HIGH CURSOR : PIN S WAIT ON X
> WAIT EVENT WITH PARALL
>
> Sounds exactly like Stefan's problem - though the example he's just posted
> doesn't look like it's got the temp table problem that explains this one.
>
>
> Regards
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
> _at_jloracle
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on
> behalf of Herald ten Dam [Herald.ten.Dam_at_superconsult.nl]
> Sent: 15 September 2015 12:14
> To: oracle-l-freelists
> Subject: RE: kkslce [KKSCHLPIN2] mutex contention on hard parse of PQ with
> binds
>
> Hi,
>
> maybe is it this bug/improvement: Bug 17805316 : IMPROVE CURSOR SHARING
> FOR PX SLAVES FOR STATEMENTS WITH CDT. There are some related bugs but they
> should already been included in 12c
>
> Herald ten Dam
> Superconsult
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l