Hi,
Oracle 11g/12c database installed on a Windows 2012 R2 server.
Total physical memory on the Windows server is 20GB.
Oracle database is installed on automatic memory management and allocated 50% RAM.
So 10GB memory is reserved for Oracle database on the windows server.
Lets says at 10AM we start the Oracle database and look at WindowsTask Manager we see "oracle.exe" process showing 5GB memory used
At 11AM when there is lot of workload the "oracle.exe" shows 10GB memory used in Windows Task Manager.
Questions:
1) Does the 10GB at 11AM denote that Oracle database used 10GB ( maxed out) due to workloads ?
2) Let's say during lunch hour at 1PM, when there is not much workloads running, will Oracle.exe stay at 10GB or come down in size between 0GB-10GB ?
I mean if at some point (11AM) Oracle database used the 10GB (max memory allocated during installation), does it always hold the 10GB memory without releasing it back to Operating System
even when no user is connected to the database ?
3) If we notice that oracle.exe is at 9GB memory usage in Windows Task Manager, does it mean it is the approximate HWM for Oracle database ? Or does it mean that it is currently using it at that very moment ?
Thanks in advance