Nonstop ORA-04031 ORA-04031: unable to allocate 32 bytes of shared memory ("streams p

Nonstop errors

ORA-04031: unable to allocate 32 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")

I went into OEM yesterday and was going through an export just so I could use the job that estimates the export size because I wanted to set up a weekly job and during the size estimate it died with a memory error. I didnt write it down at the time. But now I noticed this error ever since this ran. Is there a way to stop this estimate job that seems to be running somehow in the background?


--SMD

why not fix your streams pool error?

Streams is not being used or configured from what I can tell. This is a 3rd party app.

SQL> show parameter streams

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size big integer 0
SQL>

perhaps you should allocate some to it then?

Apparently, a process is trying to allocate some memory from the stream pool. You can start by:

1. Checking the trace file generated
2. Identify the offensive statement
3. Check why this statement is trying to allocate memory from stream pool.


Regards,
Hany.