Oracle 11g memory leak in Win 2008?

In general, regardless of platform, Oracle is going to allocate a large chunk of memory at startup for the SGA (System Global Area). This is what the database uses for things like caching blocks in RAM, caching SQL statements, etc.Every time a session is created, Oracle will allocate a much smaller chunk of memory for the PGA (Program Global Area) of that session. That's memory for things like sorts and hashing that will grow and shrink as the session requires it.

It wouldn't be unusual to configure Oracle to use half a machine's physical RAM as SGA and 15-20% of the physical RAM for total PGA leaving the remainder for the operating system and other applications. You should be able to dial that memory usage down though that may cause performance issues as more I/O requires physical reads rather than being satisfied from cache. Your configuration settings are instructing Oracle to use up to 9.65 GB of RAM between SGA and PGA and to allocate that memory as it sees fit.

It would be entirely reasonable to expect Oracle to grab 6 or 7 GB of RAM at startup for the SGA and to keep that RAM allocated forever. And that under load, Oracle would likely have in the neighborhood of 9.65 GB of RAM allocated between the shared SGA and the session-level PGAs. Is that the behavior that you're seeing?

If so, it sounds like Oracle is behaving as expected, that there is no memory leak, and that there is no need to restart the service.

1, as always a good answer from Justin. Burleson's site has a nice brief on the topic: dba-oracle. Com/oracle11g/oracle_11g_memory_target_parameter.

Htm – DCookie Mar 23 at 14:54 2 SGA should be 'grabbed' at startup. PGA will be grabbed by a process as and when needed. The process might release it, or it might hold on to it until the process terminates (eg session logs out).

If your app uses a connection pool, and doesn't end its sessions, that might have this effect. – Gary Myers Mar 23 at 23:05.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.