parsing of child cursor leading to blocking sessions
Hello,
This is unfortunately a somewhat common occurrence due to the parsing of child cursors. We often have to bounce the instance to clear the blocking condition.Any thought on this please?
BLOCKING_SESSION SID SERIAL# WAIT_CLASS SECONDS_IN_WAIT INST_ID
---------------- ---------- ---------- ------------------------------ --------------- ----------
2579 4 369 Concurrency 545 2
2579 10 11077 Concurrency 543 2
2579 13 16899 Concurrency 352 2
2579 20 10185 Concurrency 387 2
2579 22 31525 Concurrency 1 2
2579 26 32925 Concurrency 12261 2
2579 27 5595 Concurrency 527 2
2579 28 16883 Concurrency 1 2
2579 33 7515 Concurrency 533 2
2579 34 36589 Concurrency 403 2
2579 36 56687 Concurrency 360 2
2579 38 41561 Concurrency
Best regards,
Vishal