Re: Out of Memory error with large Oracle DB extraction

2009-11-25 Thread Rene Schickbauer
Hi! I've done a lot of DBD::Oracle programming for over 10 years and never met a situation where I needed to do that. I can safely say that your program will be better off for using some sort of while ( ...->fetch ) loop. I also use DBD::Oracle in one of my projects (ActivePerl 5.10). I get

Re: Out of Memory error with large Oracle DB extraction

2009-11-19 Thread Peter Scott
On Thu, 19 Nov 2009 01:07:25 -0700, Dan Fish wrote: > I'm working on a project that requires some rather large extractions > from an Oracle DB (about 2 million rows) and while monitoring the task > manager, I get an "Out of memory error" at about 2GB of mem usage. [...] > Is there a built-in way to

Re: Out of Memory error with large Oracle DB extraction

2009-11-19 Thread Rob Coops
On Thu, Nov 19, 2009 at 9:07 AM, Dan Fish wrote: > I'm working on a project that requires some rather large extractions from > an > Oracle DB (about 2 million rows) and while monitoring the task manager, I > get an "Out of memory error" at about 2GB of mem usage. > > > > Client System Specifics:

Out of Memory error with large Oracle DB extraction

2009-11-19 Thread Dan Fish
I'm working on a project that requires some rather large extractions from an Oracle DB (about 2 million rows) and while monitoring the task manager, I get an "Out of memory error" at about 2GB of mem usage. Client System Specifics: Win 2K3 Server 32-Bit SP2 Intel Xeon 2.5Ghz 8 CPU w/4GB