Re: Concurrency - Cursor Pin:S

  • From: GG <grzegorzof@xxxxxxxxxx>
  • To: raviteja.bellamkonda7@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 18 Jun 2017 17:52:52 +0200

W dniu 2017-06-18 o 17:41, Ravi Teja Bellamkonda pisze:

Hi All,

We have a 11.2.0.4 database and recently we are facing a performance issue. Wait event is cursor pin:s. A particular sql query is executed multiple times

Executions - 31,173,028
Total Elapsed Time - 2033.64 s


Can some provide some input a way to diagnose the root issue. I see that the no of executions are very high.

--
Thanks & Regards,
Ravi Teja Bellamkonda


Hi,

 start here :

https://andreynikolaev.wordpress.com/2011/04/22/cursor-pin-s-mutex-contention-testcase-and-diagnostics-tools/


Regards .

G


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2017