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 ;系统已更改。
