Hi,
Using oracle 12.2 EE RAC with data guard, oracle linux 6, oracle hardware.
Using top and sorting on memory, I can see some top sessions consuming Gb of memory:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
...
27506 oracle 20 0 15.5g 8.4g 8.4g S 0.0 17.5 357:00.61 oracle_27506_bo
32001 oracle 20 0 15.4g 8.0g 8.0g S 0.0 16.7 16:44.02 oracle_32001_bo
32620 oracle 20 0 15.4g 7.0g 7.0g S 0.3 14.5 7:33.29 oracle_32620_bo
...
The ony common stuff to these sessions is that these are running for weeks/ (or even months):
* one is the data guard stanby
* others come from applications running on servers. Problem: these applications are idle, no cursor open, no transaction in progress, no statement in progress (even for read), but 8Gb ram still consumed.
It seems that a session stays open in oracle, ram allocated to this session raises constantly.
Is there any "garbage collection" process or any statement that could be run to get memory from these sessions without having to kill them? Swap begins to be very high on the server because of this.
Regards.