General Resource Pool - Memory Allocation
I have three node cluster of 64GB RAM Each. As mentioned using below query.
Select processor_core_count, processor_description, total_memory_bytes from HOST_RESOURCES;
processor_core_count processor_description total_memory_bytes
16 Intel(R) Xeon(R) CPU E5-2667 v2 @ 3.30GHz 67,336,785,920
16 Intel(R) Xeon(R) CPU E5-2667 v2 @ 3.30GHz 67,335,409,664
16 Intel(R) Xeon(R) CPU E5-2667 v2 @ 3.30GHz 67,336,105,984
No user defined pools are created.
select name,memorysize,maxmemorysize from resource_pools;
name memorysize maxmemorysize
1 general Special: 95%
2 sysquery 64M
3 sysdata 100M 1G
4 wosdata 2G 2G
5 tm 200M
6 refresh 0%
7 recovery 0%
8 dbd 0%
9 jvm 0% 2G
10 blobdata 0% 10%
11 metadata 0%
My default General Pool with 95% allocation of max memory is showing only 22GB. What could be the reason and how to fix it?