ORA-04031:
-
ORA-04031 in Production — It’s Almost Never Just About Memory Size
I’ve been called in on ORA-04031 emergencies more times than I can count. The call always sounds the same: “The database is throwing ORA-04031, we can’t allocate shared memory, users are getting errors, what do we do?” And the first response from most DBAs — including experienced ones — is to increase the shared pool… Continue reading
-
ORA-04031: unable to allocate 976 bytes of shared memory (“shared pool”,”MGMT_JOB_ENGINESYSMAN”,”sga heap(1,1)”,”library cache”)
I hit this error while running the catupgrd.sql script during 10gR2 32 bit to 10G 64 bit on Windows Operating System. I was moving my 10.2.0.2 database from windows 2003-32 bit to windows2008-64 bit. As a mention, My source DB version is 10.2.0.2 and my target server database version is 10.2.0.4 which is certified with… Continue reading
HELIOS BLOG 