cursor: pin S wait on X after upgrade to 19.12

Rdbms 19.12

Windows 2019

large pages enabled

multitenant

Hi,

This is part of a statspack report from today:

Instance Efficiency Indicators

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

      Buffer Nowait %:  99.99    Redo NoWait %: 100.00

      Buffer Hit  %: 100.00 Optimal W/A Exec %:  99.98

      Library Hit  %:  99.93    Soft Parse %:  99.68

     Execute to Parse %:  96.84     Latch Hit %:  99.65

Parse CPU to Parse Elapsd %:  1.61   % Non-Parse CPU:  96.75

 Shared Pool Statistics    Begin  End

                ------ ------

       Memory Usage %:  85.96  86.15

  % SQL with executions>1:  78.99  81.11

 % Memory for SQL w/exec>1:  70.55  74.54

Top 5 Timed Events                          Avg %Total

~~~~~~~~~~~~~~~~~~                          wait  Call

Event                      Waits  Time (s)  (ms)  Time

----------------------------------------- ------------ ----------- ------ ------

cursor: pin S wait on X             26,479   21,549  814  60.7

CPU time                          11,698     32.9

library cache lock                6,305    1,153  183  3.2

row cache mutex                 63,032     385   6  1.1

kksfbc child completion             3,367     162   48   .5

As you can see Parse CPU to Parse Elapsd % is awful, most likely due to cursor: pin S wait on X.