oracle 设置SGA

SQL> show parameter sga;NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------lock_sga                             boolean     FALSEpre_page_sga                         boolean     FALSEsga_max_size                         big integer 512Msga_target                           big integer 200MSQL> alter system set sga_max_size=200M scope=spfile ;系统已更改。SQL> show parameter memoryNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------hi_shared_memory_address             integer     0memory_max_target                    big integer 820Mmemory_target                        big integer 820Mshared_memory_address                integer     0SQL> alter system set memory_target=300M scope=spfile ;系统已更改。