3 Replies Latest reply: May 14, 2014 3:08 AM by Moonlight RSS

    Error ORA-04030 in Oracle RAC11GR2

    Moonlight

      Hello,

      I'm working with oracle RAC 11GR2.

      I replace cursor by collection and using bulk collect to optimise pl/sql application code.

      But, in run I have received this error:

       

      ORA-06500: PL/SQL : storage error

      ORA-04030: out of process memory when trying to allocate 48 bytes 16328 bytes

      (koh-kghu call ,pmuccst: adt/record).

       

      I check memory

      memory_target             = 1.2Go

      memory_max_target    = 1.5Go

      sga_target                    = 625Mo    (I'm setting these values to controle and use advisory for sga and pga)

      pga_aggregate_target = 600Mo

      sga_max_size             = 1.5Go

       

      when I check sga advisory and pga advisory :

      SGA should be 1Go

      PGA should be (at least) 3.5Go

       

      I want to understand, if sga_max_size fixed to 1.5Go (the same of memory_max_target), PGA can't take from this memory ?

       

      According to Oracle Error, Are-you think that's I should add more memory and fixed SGA and PGA in values given in advisories?

       

      Thank in advance

        • 1. Re: Error ORA-04030 in Oracle RAC11GR2
          Moonlight

          Hi,

          An other point, I think It's important :

          mesures display above are for instance number 2, I don't have any problem with instance number 1.

          So, why Oracle RAC don't balancing workload between memories of tow instances?

          I explain more: if it not exist much memory in instance 2 so it should be work in instance 1, but advisories of PGA and SGA for instance number 1 are very good!

           

          Any one have encounter same problem, thank you to help me!

          • 2. Re: Error ORA-04030 in Oracle RAC11GR2
            Moonlight

            Measures below are from my server:

             

              root@PROD_SERV:~# ulimit -a

              core file size                          (blocks, -c) 0

              data seg size                         (kbytes, -d) unlimited

              scheduling priority                 (-e) 0

              file size                                  (blocks, -f) unlimited

              pending signals                     (-i) 191772

              max locked memory             (kbytes, -l) 64

            max memory size                  (kbytes,-m) unlimited

              open files                              (-n) 1024

              pipe size                               (512 bytes, -p) 8

              POSIX message queues     (bytes, -q) 819200

              real-time priority                   (-r) 0

              stack size                             (kbytes, -s) 10240

              cpu time                               (seconds, -t) unlimited

              max user processes            (-u) 1024

              virtual memory                     (kbytes, -v) unlimited

              file locks                              (-x) unlimited

             

            So, any relation between ORA-04030 and this configuration for server?

             

            • 3. Re: Error ORA-04030 in Oracle RAC11GR2
              Moonlight

              Hi,

              the cause of problem is deficiency of PGA memory, we need more than 600Mo according to oracle advisory (we need 3.5Go)

              I keep cursor for application, to wait to add RAM memory for our server.

               

              Have a nice day