Increase memory usage Oracle Windows 2003
730380Mar 11 2010 — edited Mar 11 2010Hello,
I have a problem with my Oracle. I have installed Oracle 10.2.0.3 on Windows Server 2003 (32 Bit).
Everything works fine, but every time I look at the task-manager I see, that Oracle only uses 250 MB Memory. My operating system has 4 GB RAM. Therefore I don't understand, that Oracle only uses 250 MB.
Normally, that wouldn't be a problem, but in my oracle database I have tables with over 5.000.000 Rows and I use spatial operations to compare these rows.
Because of this, in many cases I get the following error from oracle during the spatial operations from my enterprise manager.
'Significant virtual memory paging was detected on the host operating system ...'
As a solution, Oracle suggests, to increase the phyisical memory. But Oracle only uses 250 MB of the 4GB, which is available.
I searched a bit in the internet for a solution, but I didn't found something, which is useful for me.
I increased parameters like sga_max_size or sga_target in oracle, but nothing changed.
How can I increase the phyisical memory, which is used by oracle (1GB would be great instead of 250mb)
(Furthermore I read, that oracle can't use more than 1,3 gb under windows server 2003 32 bit. is that true?)
Thanks for your help.
Best regards