It's probably not a problem with your Perl installation. I'd wager that what's going on is that you're pulling all of the data into a big Perl data structure, like an array of array references. That would be the case if you're using fetchall_arrayref to get your data. But this cannot be determined unless you post your code.
Going with my guess: the problem is probably that Perl takes relatively more memory to store a given amount of data than SQL*Plus, but that's in the nature of the Perl beast => throw memory at a problem to increase efficiency.
A possble solution is to change your code to work with fetchrow_arrayref (note: "row", not "all") which gets the data from the result set one row at a time, instead of snarfing the whole thing into memory at once. That may reduce the program's memory needs. It might slow down your program's execution -- but having it finish in 10 minutes is faster than never, I suppose =)
Philosophy can be made out of anything. Or less -- Jerry A. Fodor
In reply to Re: Out of memory! message
by arturo
in thread Out of memory! message
by Dude
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |