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
@jloracle
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Herald ten Dam [Herald.ten.Dam@xxxxxxxxxxxxxxx]
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
--
//www.freelists.org/webpage/oracle-l
