ORA-04031 for java even with large java pool size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-04031 for java even with large java pool size

  1. #1
    Join Date
    Sep 2005
    Posts
    1

    ORA-04031 for java even with large java pool size

    Hi,
    As part of our continuous rebuild process we rebuild our oracle instance from scratch every 2 hours or so. As part of that build we compile a small number of java procedures and grant permissions on them. What I've noticed is that we need to continually expand the java_pool_size in the SGA to get the java stuff to rebuild. If we don't, we get things like

    ORA-04031: unable to allocate 4032 bytes of shared memory ("java
    pool","JAVA$POLICY$SHARED$0000853cSYS","joxlod exec hp","SROState")
    ORA-06512: at "SYS.DBMS_JAVA", line 313
    ORA-06512: at line 1
    When running
    BEGIN dbms_java.grant_permission() calls and the like.
    I have tried setting automatic shared memory management both on and off and flushing the shared pool. but to no avail.
    The current settings I'm trying is with ASM off, total SGA 397Mb,
    shared pool 136 Mb, Buffer cache 24Mb, Large pool 8Mb, java pool 228Mb. (As I said, we've been gradually increasing java pool size over time as this problem happened, but we're getting to the stage where the java pool size is eating up too much memory on the build machine as a whole).
    I apologize if there is something obvious I'm missing here, as I'm more of a developer than a DBA but the oracle instance is an integral part of our continuous integration process. I'm running Oracle 10 release 1 on Linux
    Thanks
    Denis

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    I think the problem is with buffer cache, 24MB.

    Increase this to 150 MB and try again.

    How much memory does the box have?

    Tamil

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