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

Last updated on AUGUST 31, 2017

Applies to:

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

Symptoms

After upgrade to 11.2.0.4 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

Changes

 Upgrade to 11.2.0.4.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms