DB Instance: Virtual memory usage (Oracle 10g)
497683Aug 20 2008 — edited Aug 20 2008I need to install several Oracle 10g Database instances on a Windows Server. After creating 5-6 Instances the virtual memory on the server reaches the limit of 4 GByte.
But I have to create more instances for development issues on the server. Is there any possibility to reduce the virtual memory used by a DB Instance because the schemas stored in the Instance are really small? Is there any parameter in any ora-file or anything else or an SQL-Command which affects the usage of the virtual memory of an DB instance?
Thanks in advance :-)