MEMORY_TARGET and SGA_MAX_SIZE
I have to RAC (11.1.0.7) nodes on OS Solaris 10. On both nodes, i have MEMORY_TARGET=10g
I realized that at OS level, node1 has allocated a 10G shared segment and hence consuming 10G of RAM on this node for Oracle, but, on node2, it allocated only 6G. When i further investigated, i saw that on node 2, my instance has a value for SGA_MAX_SIZE set to 6G and on node 1, this value is 10G.
Which means, my instance on node2 is only utilizing 6G of memory for SGA.
Can any expert help to find out that eventhough i have MEMORY_TARGET set to 10G on node2, why it is consuming 6G and why SGA_MAX_SIZE is set to 6G. Remember that SGA_TARGET=0 on both nodes.
Salman