Some basic windows 32 bit info: Windows allocate for each program up to 4 GB memory. Each 4 GB address space is divided: 2 GB belong to the program and 2 GB to windows. So each of your instances has 2 GB. The 2 GB include the oracle instance and the buffers, and all the memory used by the connections. Using the /3GB switch change the division to: 1 GB to windows, 3 GB to the program. Adar Yechiel Rechovot, Israel Blessing Kamutande wrote: > Thank you Niall, > When you say 800mb is used by user processes are you referring to > Oracle processes or generally the whole system? > Also that 2047M is it for this one instance or all instances on the > server? > For instance, say I have two instances, do the two instances share the > 2074M or each instance can grow it's memory usage to 2047M? > Thank you so much for the explanation. > Kind Regards > Blessing > -- //www.freelists.org/webpage/oracle-l