My system has 34GB RAM, however, I have set
memory_max_target = 3G memory_target = 3G
Oracle memory parameters are specified using G (GB), M (MB) or K (KB)
...and I use AMM (Automatic Memory Management).
Even though that's the case when I check the current usage of my memory with
...it shows that around 33 GB of the total has been used. So I guess, Oracle also uses some of it (yes, I mean more than memory_max_target size, which is 3 GB).
So, my questions are:
- Can Oracle use more memory than what we have set for
- Or is that a "hard" limit that Oracle never changes, even though the system has plenty of free memory?