SGA size in AWR report
I run Oracle 11.1 database on 2 nodes RAC
OS: AIX 6.1 Each server has 64G RAM
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 40192M
sga_target big integer 0
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 40192M
memory_target big integer 40192M
shared_memory_address integer 0
SQL> show sga
Total System Global Area 4.1956E+10 bytes
Fixed Size 2141072 bytes
Variable Size 2.8991E+10 bytes
Database Buffers 1.2885E+10 bytes
Redo Buffers 78139392 bytes
So SGA = 40192M