Database Tuning (MOSC)

MOSC Banner

parsing of child cursor leading to blocking sessions

edited Jan 25, 2016 10:31PM in Database Tuning (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center