question

tahir.akhtar avatar image
tahir.akhtar asked

Why Oracle 11g on windows default installation keeps increasing memory usage even when idle?

I installed Oracle 11g on my Windows XP 64 bit desktop with pretty much the default options. Now when I start the database, it just keeps increasing the memory usage few hundred KB at a time even when the database is not in use. At the moment I am looking at Windows Task Manager and it is showing oracle.exe using more than 1.4 G and counting.

What's happening? How can I set a maximum limit on the memory usage?

It's a developer machine and database will not be huge in most cases. Even when they are huge, the number of concurrent users will be very few.

oracleperformance64-bitwindows
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Gary 4 avatar image
Gary 4 answered

Default install will use Automatic Memory Management. So you set it a target and a max target and it will use (approximately) that amount of memory.

If you've got 4GB on the machine, 1.4Gb for the database doesn't seem unreasonable for a DB server. If it's only 2GB that leaves the OS a bit tight. Oracle generally figures that, if you've paid for the database to run on that machine, make the most of the machine's resources. It is intentionally 'greedy'.

http://www.oracle-base.com/articles/11g/AutomaticMemoryManagement_11gR1.php

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.