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
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?