SGA_MAX_SIZE与SGA_TARGET
Oracle的SGA包括以下几个部分，可以通过show sga命令或者是通过查看v$sga视图来查看SGA的大概组成：17:39:48 SQL> show sgaTotal System Global Area 1048576000 bytesFixed Size 1223392 bytesVariable Size 847250720 bytesDatabase Buffers 192937984 bytesRedo Buffers 7163904 bytes17:42:05 SQL> select * from v$sga;NAME VALUE------------------------------ -------------Fixed Size 1223392.00Variable Size 8472...