Database Memory & 4030/4031 (MOSC)

MOSC Banner

ora-4031 error

edited Dec 9, 2009 3:20AM in Database Memory & 4030/4031 (MOSC) 6 commentsAnswered
 Hi All,   We do have few Ora-04031 errors in alert logfile. I do understand that if we had bigger shared pool, most likely we would not see this error. Pinning large objects could have helped us as well.

Do we know anything else could have caused other than shared pool? What is the word 'tmp' at the end of the message? Is it refering to /tmp partition (of unix) or temporary tablespace? Can not relate this error to /tmp partition, do not think Oracle is using /tmp partition for any of its operations.

Error is:
<!-- /* Font Definitions */ @font-face

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