ora -04031 with shared pool
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.
0