RE: Session With oper EXCL is also waiting - where to now? (systemstate dump)

  • From: <Christopher.Taylor2@xxxxxxxxxxxx>
  • To: <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 19 Sep 2012 17:38:21 -0500

Thanks Rich.

A large quantity of our sql does use binds - however we have a very large 
population of SQL that does not use binds.
I'll definitely keep that in mind.

Chris


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Rich Jesse
Sent: Wednesday, September 19, 2012 4:22 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Session With oper EXCL is also waiting - where to now? 
(systemstate dump)

Hey Chris,

> Ah hah (see what it's waiting on...also any additional guidance from 
> here?) Here's the HOLDER

I apologize for not analyzing the dump you provided, but do you have binds in 
use on your instance?  I had a somewhat similar situation where AMM caused the 
shared pool size to balloon to 11GB due to no binds.  Since the stats 
collection by default invalidates cursors, the 250K non-bind-variable-using 
cursors dependent on one table caused a 10-15 minute library latch havoc when 
that table had its stats collected.

Your case sounds like it could be a little different, with the AMM adjustment 
being the culprit, but I wonder if the underlying cause of bindlessness could 
be at work here.

I ended up dumping AMM, which did wonders in lieu of not being able to use 
binds from one vendor's app.  Having been able to chew Tom Kyte's ear in person 
for a few minutes about my plan helped.  :)

Just a thought...

Rich

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


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


Other related posts: