Re: Oracle eats up memory

It is possible that the connections at the client were not closed. Please forgive my ignorance as I a newbie to programming with ADO and Oracle. I am taking over as the administrator and programmer have both left. Does ADO releases the connection only by closing the connection? I see that one of my clients have the connections that are closed
only when the threads exit.

I am not upgrading to 8.1.7 as I has just took over the system and I am not sure
what are the implications of upgrading to 8.1.7. Are there any new bugs in 8.1.7 that does not exist in 8.1.5.? Can I use the current odbc driver for my client
after the upgrade? Is there any site that I can find answers to all these? Thanks.

Poh

• Original Message ----- From: "Hans Forbrich" <forbrich_at_yahoo.net> Newsgroups: comp.databases.oracle.server Sent: Thursday, November 06, 2003 12:44 AM Subject: Re: Oracle eats up memory

> Poh wrote:
> >
> > My Oracle 8.1.5 running on Windows NT 4.0 is consuming a lot
> > of memory and does not release the memory untill the client that is
> > accessing the database is terminated. My client is also running on
> > Windows NT4.0. My client is accessing the database using ADO.
> > On startup, the client opens multiple connections to the database.
> > The database is searched and updated by the client through stored
> > procedure on the Oracle. The client closes the connections before
> > terminating.
> >
> > I checked the task manager. It shows Oracle uses 245MB of memory
> > and 570MB of virtual memory.
> > Why Oracle continues to consume memory and does not release the
> > memory until the client is terminated.
>
> Have you verified that the memory is being held due to Oracle's action?
>
> Or is it possibly due to the ADO client not releasing the connection
> (and the poor server is simply doing what it is told to do)? In which
> case, is it possible the client is using poorly developed code?
>
> And is there a particularily good reason for still using 8.1.5 (which is
> obsolete, 'cause lots of stuff's been fixed). Any possibility of
> getting at least to 8.1.7, if not 9.2.x?
>
> --
> /Hans
> [mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]
Received on Wed Nov 05 2003 - 16:47:46 CST