1 2 Previous Next 16 Replies Latest reply: Aug 18, 2013 9:24 PM by sb92075 RSS

    ORA 4030, 6512

    yxes2013

      Hi All,

       

      11.2.0.1

      Aix 6.1

       

      Our apps is hitting error lately with :

       

       

      SQL> exec loadvgo_web_dli(0);
      BEGIN loadvgo_web_dli(0); END;

       

      *
      ERROR at line 1:
      ORA-04030: out of process memory when trying to allocate 8176 bytes
      (kxs-heap-w,qesaQBInit:buffer)
      ORA-06512: at "DLIMGR.LOADVGO_WEB_DLI", line 222
      ORA-06512: at "DLIMGR.LOADVGO_WEB_DLI", line 348
      ORA-06512: at line 1

       

      AND

       

      SQL> exec step_five;
      BEGIN step_five; END;

       

      *
      ERROR at line 1:
      ORA-04030: out of process memory when trying to allocate 8224 bytes (qesca subheap,qerjo hash table)
      ORA-06512: at "DLIMGR.PKGPARCELCONVERTER_DLI", line 1289
      ORA-06512: at "DLIMGR.STEP_FIVE", line 9
      ORA-06512: at line 1

       

      Is there a way to tune memory settings in Aix? or Oracle?

       

      Thanks,

       

      zxy

        1 2 Previous Next