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?
Comments
What are you viewing that indicates 22G? What does the following return?