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.