----------------------------------------------------------------------------
----
From: Chen, Jeffrey Jianfeng
Sent: Thursday, May 13, 2004 1:38 PM
To: Brown, Bob
Subject: RE: Oracle Memory Allocation...


It should not be worried about, unless your server is running low of free
memory. Then you need to modify the db init settings.

-JC





----------------------------------------------------------------------------
----
From: Brown, Bob
Sent: Thursday, May 13, 2004 3:30 PM
To: Chen, Jeffrey Jianfeng
Cc: DBA - New York
Subject: Oracle Memory Allocation...


Hi,

We are on Oracle 8i.

On the server, the processes show:

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
1519 oracle 24 0 872M 872M 854M S 0.0 23.3 0:45 oracle
1044 oracle 15 0 137M 137M 136M S 0.0 3.6 0:00 oracle
1076 oracle 15 0 129M 129M 129M S 0.0 3.4 0:05 oracle

The process 1519 is the newly created thread. As you can see, it is taking
up 23.3% of the memory and the share is quite sizeable.

It doesn't surprise me that the query would take up a lot of memory,
however, after the query is complete and the client has all of the data, the
memory allocation doesn't seem to change.

Shouldn't the memory be given back? If not, will Oracle be able to
reallocate the memory when another query needs it? Does the connection have
to be closed to get the memory back?

Is there a setting in Oracle to reclaim this memory or a cleanup routine
that will close inactive threads?

Bobby