SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

session heap going high (never released)

757853Mar 4 2010 — edited Mar 4 2010

Hi all,
I'm developing some procedures to do spatial data processing. I write here because I'm not sure my problem being related to spatial analysis.
During processing about 100.000 rows a ORA:04030 is raised. If I look into v$process I see that PGA memory is always increasing, never released. I don't do any recursion, nor keep open coursors. I've even tried to release memeory manually thorugh DBMS_SESSION utilities... but the memory keep going high.

I've altered my session to generate a heap dump fon event 4030, and analyzed it with the heapdump_analyzer script. Here is the result I obtain from the heap dump when crash happens: http://pastebin.com/HS7z7XjJ

I can't understand if it depends on my procedure, on an Oracle bug, or the OS.
I'm working with Oracle 10.2.1. , on Windows XP (for testing). I have only one session and one user.

thanks,
giovanni

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2010

Added on Mar 4 2010

#error, #memory, #performance

3 comments

657 views