topic Re: ORA-04030 in Operating System - HP-UX

ORA-04030

nadori — Mon, 06 Dec 2004 10:31:08 GMT

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.

Re: ORA-04030

Steve Steel — Tue, 28 Mar 2017 10:41:14 GMT

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

Re: ORA-04030

nadori — Mon, 06 Dec 2004 10:54:54 GMT

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 ?

Re: ORA-04030

Yogeeraj_1 — Mon, 06 Dec 2004 22:59:19 GMT

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

Re: ORA-04030

nadori — Tue, 07 Dec 2004 06:20:26 GMT

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 ?