My Oracle Support Banner

Cursor Pin S Wait On X High During Select With Parallel (Doc ID 1915053.1)

Last updated on AUGUST 14, 2020

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.1]
Information in this document applies to any platform.


After upgrade to bad peformance along with high "Cursor pin s wait on x " are seen during select with parallel executed from within pl/sql.

The execution plan is serial.

Top 10 Foreground Events by Total Wait Time

Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
cursor: pin S wait on X 1,559 31.1K 19975 82.6 Concurrency
library cache lock 298 5496.7 18445 14.6 Concurrency
DB CPU 1110.8 2.9
name-service call wait 40 3 75 .0 Other
os thread startup 16 1.6 100 .0 Concurrency
kksfbc child completion 17 .9 52 .0 Other
DFS lock handle 2,578 .3 0 .0 Other
enq: PS - contention 1,057 .3 0 .0 Other
ADR block file read 36 .2 6 .0 Other
cell single block physical read 381 .2 1 .0 User I/O


 Upgrade to


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.