5、e来决定 查看:showparametershared_pool_size 修改:alter system set shared_pool_size=120m; sys@ORCL> select * from v$version where rownum < 2; BANNER ---------------------------------------------------------------- Oracle Database 10gEnterpris
6、eEditionRelease10.2.0.1.0 - Prod sys@ORCL> showparametershared_pool_ NAME TYPE VALUE ----------------------------------------------------------------------------- shared_pool_reserved_size biginteger
7、3M shared_pool_size biginteger0 --为0,表明由系统自动分配 sys@ORCL> showparametersga_ NAME TYPE VALUE ----------------------------------------------------------------------------- sga_max_si
8、ze biginteger176M sga_target biginteger176M --非零值,表示由系统自动调整sga 五、SGA_MAX_SIZE与SGA_TARGET s