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.

otn.oracle.com its in the concepts and network administration document. look at dedicated server and shared server. shared server doesnt do that, HOWEVER, it has cons as well.

570MB of memory on a server is not that much. just add more RAM. you can go to 4GB of RAM on a windows system.

Oracle isnt really designed for low end systems. Received on Wed Nov 05 2003 - 15:40:22 CST