Re: cursor: pin S wait on X querying data dictionary

  • From: GG <grzegorzof@xxxxxxxxxx>
  • To: cstephens16@xxxxxxxxx, oracle-l <Oracle-L@xxxxxxxxxxxxx>
  • Date: Sat, 30 Jun 2018 09:36:33 +0200

W dniu 2018-06-29 o 16:26, Chris Stephens pisze:

3-node RAC 12.2 database on Centos7

We have an application which makes use of SQLAlchemy that is suffering mightily from "cursor: pin S wait on X" executing the following SQL:

 as a general source of information I'd recommend
especially 'Divide and Conquer the Mutex Contention paragraph'.
Having said that keep in mind it is a fixing from wrong side.

Other related posts: