Re: Concurrency - Cursor Pin:S

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

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