Re: Memory optimization, help!

From: Reid Lai <reidlai_at_hk.super.net>
Date: 1998/09/17
Message-ID: <35FFE929.A951DABC_at_hk.super.net>#1/1


Your problem mainly caused by network traffic. You can try to implement your code in VB5 to Oracle stored procedure. I think it may be faster.

Terry Maguire wrote:

> 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 Thu Sep 17 1998 - 00:00:00 CEST

Original text of this message