perl - Oracle error

[bharat_7]

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)

[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

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

Explains it

Steve Steel

[Eric Antunes]

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