Re: Oracle eats up memory

"Poh" <pohtl_at_singnet.com.sg> wrote in message news:<bob3ub$5h4$1_at_reader01.singnet.com.sg>...
> 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.

Poh,

don't change anything on this box. leave it be. this will cya with respect to taking this box over. just make sure that there is some sort of backup scheme in place.

get a new box. get it pre-installed with your server OS of choice. (w2k3 server would be a good candidate in your situation. if not, w2k server, sp4). get new versions of whatever third party software (e.g. backup software).

install Oracle 9i R2 on it, patch it to 9.2.0.4, before you create any databases.
create a new database. export the data out of the 8.1.5 database, import it into the new database.

test it thoroughly. have other people (users) test the applications on it. test your backups and restore, recovery. this is all before you even think about switching production usage over to it. test RMAN on it.

if the existing box has NT 4.0 server on it out of the factory - you do not want to upgrade it to w2k3 server. really. turn it into your disaster recovery box afterwards.

hth.

Pd Received on Thu Nov 06 2003 - 00:12:43 CST