PL/SQL (MOSC)

MOSC Banner

ORA-08177 at SELECT in sqlobj$plan

in PL/SQL (MOSC) 3 commentsAnswered ✓

This would be first posting in the Oracle communities, so please pardon if this is not the right category or the right place.

We have an Java based application that works with the database using OJDBC. We are ORA-08177 error while trying to run (what I believe is a) SELECT query on the sqlobj$plan table. I am not familiar with this table, but appears to be maintain the statistics to evaluate the query plan?

I realize ORA-08177 is seen when the isolation level is set to SERIALIZABLE and one session is trying to modify a data that the other session has modified since the transaction started. However, I do not see any modifications being done any of the user tables (all SELECT queries being fired).

Tagged:

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