Database Tuning (MOSC)

MOSC Banner

PLAN_TABLE row lock contention

edited Mar 28, 2017 5:02AM in Database Tuning (MOSC) 6 commentsAnswered

In a third party application, comprised of several processes accessing our Oracle database, we see process threads stuck waiting to acquire an Oracle PLAN_TABLE row lock. All are waiting to lock the same row. Meanwhile another process within the application holds a TX lock on that row for hours and hours. This PLAN_TABLE is in the application user schema, whereas PLAN_TABLE in the SYSTEM schema seems to be quite unused. SQL tracing must be enabled with DBMS_SESSION.SET_SQL_TRACE() or the equivalent within the application itself. If manually initiated, it would not persist across restarts (I believe), and there have been both

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