I'm using VB Script on a Windows 2003 Server against an Oracle 10g database to both query against a table and insert new rows of data against that same table but as it runs it starts eating up RAM and when it gets to about 1.5gb it causes the out of memory error. As far as the Select Statement query goes I have to read from about 30 of the 120 column names and I only specify the 30 columns instead of the generic Select * From table_name. The Insert statement I have to update about 10 of those 120 columns.
Are there any arguments or parameters that I can state to control the amount of data loaded into memory so that it doesn't create the error?
Software/Hardware used: Windows 2003 Server 32bit and Oracle 10g database