Memory optimization, help!

Hi,

This question is from a newbie so please be patient. I'm using Oracle 7.3.3 and VB5 to run numerous PL/SQL procedures for a financial modeler. The SQL includes selects, inserts, updates and creates. I 'commit' after each proc. Here is the problem I'm having:

The full execution time of one of the models is 2 hrs. A scheduler has been setup in VB5 so that we can run many of these over night. I arrived in one morning to find my machine nearly smoking! The spec of the machine is:

Dual Pentium Pro 200Mhz
128MB
18 Gigs Disk Space
Windows NT 4.0 Workstation

The virtual memory warning was up saying I was low on resources. I looked at the mem usage on the task manager and it said 386MB. Looking at the amount of memory each process was taking up, Oracle took up nearly 200MB!

It seems the memory footprint of Oracle grows during execution. I tried disconnecting and reconnecting during model runs but this doesn't seem to work. When I exit the full VB app then memory is handed back.

Is there some command that can be used so that Oracle releases some of this memory, or is this a problem with VB?

Regards

Terry Maguire
tmaguire_at_nospam.tinet.ie Received on Tue Sep 15 1998 - 00:00:00 CEST