Nonstop ORA-04031 ORA-04031: unable to allocate 32 bytes of shared memory ("streams p
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

  1. #1
    Join Date
    Oct 2006
    Posts
    17

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    why not fix your streams pool error?

  3. #3
    Join Date
    Oct 2006
    Posts
    17
    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>

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    perhaps you should allocate some to it then?

  5. #5
    Join Date
    Dec 2001
    Posts
    320
    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.
    Anyone can hold the helm when the sea is calm.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width