Loading...
Sunday, May 11, 2008

ORA-04030

ORA-04030
ORA-04030: out of process memory when trying to allocate string bytes (string,string)
Cause: Operating system process private memory has been exhausted, if you are running out of memorydue to runiing oracle on windows 32 bit then you could not assign memeory for oracle more than 2GB.
Action: There are 3 ways of dealing with that limitation if "2GB limit of memory for Oracle on WIndows 32 bit" is the cause:



  1. Use 64-Bit windows

  2. Apply the /3GB switch in boot.ini to allow 3GB to be made available to
    oracle, with the kernel taking 1GB

  3. Apply the /PAE switch in boot.ini to allow the use of upper memory
    (anything above 4GB). Oracle needs to be configured to use this
    memory, and this memory can only be used for the buffer cache. Shared
    Pool, PGA, all the rest needs to sit in 'base' memory no matter what.



    The /3GB and /PAE switches can be used together, but if they are, you
    will never see more than 16GB on the box, even if there's 64GB of
    physical memory installed.


for more information take a look at
How to configure Windows 32 bit to let Oracle use more than 2 GB of memory




Tags: ,,,,

0 comments:

 
TOP