Ora-04030 error on AIX4.3.3

[NavinB]

Hi everyone,

I'm getting the following error on running reports thru report server on IBM AIX4.3.3

ORA-04030: out of process memory when trying to allocate 16208 bytes (call heap)

The oracle documentation gives this explanation

$ oerr ora 4030
04030, 00000, "out of process memory when trying to allocate %s bytes (%s,%s)"
// *Cause: Operating system process private memory has been exhausted
// *Action:

I have tried to increase the data segment field(data area)with ulimit command but this also doesn't help.


Does anybody have any idea what to do in this case??

Any help would be appreciated...
Thanks in advance.

 

[bi]

How much memory do you have on the system and how much paging space?

 

[Yegolev]

You need more virtual memory. I believe a single process in AIX 4.3 (32-bit) can address 265MB of memory, and I know that Oracle processes (in 8.1.6 and maybe 8.1.7) don't like to release their memory. I would add RAM if possible, otherwise increase paging. For performance goodness you should verify your SGA is smaller than real RAM, otherwise you will defeat the purpose of having a SGA.

Good luck.

 

[NavinB]

Hi,

Thanks for the reply.
The system has 4GB RAM as well as paging space.
And there are 6 processors in the system.
To add to it,normally system takes 44% of paging space on an average and at the time of running reports, system was 75% idle.

 

[Yegolev]

If your DB is big enough, 4GB can be small. Our bigger machines have 16GB of RAM, or maybe more if we decked out our 7017-S80s, but we run SAP on top of Oracle. It's all relative. CPU != memory, though. Perhaps you should try to limit usage: check to see if some users are kicking off lots of batch jobs... try to get them to spread the load. Sometimes they don't understand why that's a bad thing.

Not being a performance guy, do not listen to me as if I were a genius.

 

[bi]

NavinB, It does sound as if you need more memory. How large is your SGA on this database? Are there any more databases running on this system? If so, what are their SGAs?