Oracle Database Discussions

i want change sga_target=6400MB accordindg addm report.can i change




SQL> select * from v$sga_target_advice;

no rows selected

above queary does not give result ,what is the reason


SQL> SELECT name,bytes FROM v$sgainfo;

NAME BYTES
-------------------------------- ----------
Fixed SGA Size 2086200
Redo Buffers 14688256
Buffer Cache Size 838860800
Shared Pool Size 1526726656
Large Pool Size 16777216
Java Pool Size 134217728
Streams Pool Size 16777216
Granule Size 16777216
Maximum SGA Size 2550136832
Startup overhead in Shared Pool 167772160
Free SGA Memory Available 0


SQL> show parameter sga_target;

NAME TYPE VALUE
------------------------------------ ----------- -------------
sga_target big integer 2432M




SQL> show parameter sga_max_size

NAME TYPE VALUE
------------------------------------ ----------- -------------
sga_max_size big integer 2432M