We observe strange situation with memory available for general pool.
There is 252,3 GB total physical memory on each node.
The maxmemorysize parameter for general pool is 95%.
According to documentation, we are expecting that 239,685 GB of memory will be available for general pool.
But we see only 199,9 GB memory available for general in v_monitor.resource_pool_status (memory_size_kb column). That is only 79% of total physical RAM.
Moreover, memory_size_kb data slightly differs for each node. That is also strange.
Thank you.
PS: ulimit -a and /etc/security/limits.conf don't have any restrictions for dbadmin user
We didn't have proper understanding of general pool.
