general pool is less than 95% of total physical RAM

edited May 2017 in General Discussion

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


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file