Re: Client crash when query is big

From: Ed Prochak <prochak_at_my-dejanews.com>
Date: Mon, 22 Mar 1999 18:32:35 GMT
Message-ID: <7d62c3$12n$1@nnrp1.dejanews.com>

In article <36F61AF7.497F20FE_at_telaviv.ndsoft.com>, ariel <ariels_at_telaviv.ndsoft.com> wrote:
> Hi,
>
> I'm working with Oracle8 OCI at NT machine.
>
> I'm trying to execute 1 Million inserts into a single table.
>
> I want to keep 25,000 rows in an array and insert them together until i
> reach the 1 million inserts.
>
> The problem is that i can do it with 10,000 rows but if i try more than
> that the client will crash. I try to debug it, and i saw that the
> problem is "stack overflow".
>
> Which parameter should be change or what should i do ?
>
> Thanks

Check in the NT newsgroups. It is an NT process problem, and nothing to do with Oracle. Stack is an Operating system resource.

As cheap as it is, real memory is still limited.

Good luck.

Ed Prochak
Magic Interface, Ltd.
ORACLE services
440-498-3702

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 22 1999 - 12:32:35 CST