Oracle Database Discussions

AIX 6.1, Oracle 11.1.0.7

Anyone know why I can't increase my SGA_TARGET more than 2048M?

I have my SGA_MAX_SIZE set to 8G, but still can't increase SGA_TARGET.

Meanwhile, I just got an ORA-04031: unable to allocate 32 bytes of shared memory.

REFERENCE:
=========
SQL> sho parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 8G
sga_target big integer 2G

1 SELECT component, current_size, min_size, max_size
2 FROM v$memory_dynamic_components
3* WHERE current_size != 0



SQL> /

COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
---------------------------------------------------------------- ------------ ---------- ----------
shared pool 1744830464 738197504 1744830464
large pool 67108864 67108864 67108864
java pool 134217728 67108864 134217728
streams pool 67108864 67108864 134217728
SGA Target 2147483648 2147483648 2147483648
DEFAULT buffer cache 67108864 67108864 1073741824
PGA Target 2147483648 2147483648 2147483648

7 rows selected.

Any ideas?