ORA-04030

[nadori]

Hello,


We are geting this error message, could you please help us ?

OS Model : HP 11 9000/800/L2000-44
with Oracle 8.1.7.4

ksedmp: internal or fatal error
ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 8528 bytes (pga heap,ksm stack)
ORA-00604: error occurred at recursive SQL level 2
ORA-04030: out of process memory when trying to allocate 8528 bytes (pga heap,ksm stack)


thanking you in advance.

[Steve Steel]

Hi

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:

You need swap or to raise maxdsiz maxssiz kernel parameters

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=187383

Is a good explain

Steve Steel

[nadori]

here's the value of kernel parameters. For us, it seems to be enough ?

Parameter: maxdsiz_64bit
Value: 0x0000000040000000
Default: 0x0000000040000000

Parameter: maxssiz_64bit
Value: 0X02000000
Default: 0x00800000

what's your point of view ?
do i have to double this values ?

[Yogeeraj_1]

hi,

at the Oracle Database level, you will have to look at the following initialisation parameters:
- pga_aggregate_target (the target amount of ram across all processes)
- sort area size/hash area size

at the OS level, you may wish to review your ulimit

hope this helps too!

regards
Yogeeraj

[nadori]

time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 1048576
stack(kbytes) 81920
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 512

Which value do i have to modify ?