Database Memory & 4030/4031 (MOSC)

MOSC Banner

ora -04031 with shared pool

edited Oct 10, 2018 10:06AM in Database Memory & 4030/4031 (MOSC) 17 commentsAnswered
 The database was running fine, but then all of sudden all  of the query issued, we are getting ora-04031 error. I have searched on the site and seems like it is either the shared pool is set too small, or there are too many distince sql statement in the library cache. Is there a way that I can find out whether my sql statements are using bind variables or literals?

I increase the shared pool size at the moment for the database to continue to work. But I do want to find out about the root cause of it so we won't run into the same issue next time. Please advice. Thanks.

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