topic Re: perl - Oracle error in Operating System - HP-UX

perl - Oracle error

bharat_7 — Fri, 01 Oct 2004 04:40:55 GMT

Any idea how to avoid it ? The below cursor is tring to get as many records as it can.After processing few records,below was the error message I am getting

Unable to execute st_getEventSummaryId ( cursor )
ORA-04030: out of process memory when trying to allocate 16384 bytes (sort subheap,sort key) (DBD ERROR: OCIStmtExecute)

Re: perl - Oracle error

Steve Steel — Fri, 01 Oct 2004 04:50:18 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

The forum thread
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=185982

Explains it

Steve Steel

Re: perl - Oracle error

Eric Antunes — Fri, 01 Oct 2004 06:39:36 GMT

Hi,

You have basically, two things to do in $ORACLE_HOME/dbs/init.ora:

1 - decrease sort_area_size (this value can be used for each session, so be carefull with high values!)
2 - Increase shared_pool_size

As an exemple, you can have something like this:

shared_pool_size = 128M
sort_area_size = 256000

Best Regards,

Eric Antunes