Is This Content Helpful?
We're glad to know this article was helpful.
Oracle may run out of shared memory with an ORA-04031 error. This is often a problem with the Oracle database memory configuration where the server has not been allocated enough memory for the task it is being asked to perform. Consult your Oracle documentation for information on tuning the database.
ESRI has observed another possible cause of this issue, discussed below.
Refer to Oracle's metalink; bug #2793038. Users need an Oracle metalink account to observe metalink information. Information below is from the Oracle metalink.
Set STATISTICS_LEVEL=basic or increase the shared pool sufficiently not to be short of space.