Re: PL/SQL memory usage?

memory allocation for pl/sql tables is unbounced. you can make your arrays so big that you use up so much memory on a server that you cannot make a SSH connection to the server and cannot connect to sqlplus.

A guy on a previous project of mine did a large unbounced bulk collect and we had to hard kill oracle(we already had connections the server) from the OS level.

not sure where it gets stored, but it will keep taking free memory from your system.

i dont think storing all this in an array would make that much of a difference. The best way to i mprove performance of this kind of thing is to look at the algorithm and see if there is a better way to do it and to see if you can parallelize your steps. For example, can you open up some oracle jobs and run 3 things at the same time.

--
http://www.freelists.org/webpage/oracle-l