SQL> show parameter memory NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ hi_shared_memory_address integer 0 memory_max_target big integer 0 memory_target big integer 0 shared_memory_address integer 0 SQL> show parameter sga NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 4G sga_target big integer 4G SQL> show parameter pga NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ pga_aggregate_target big integer 2G SQL> MEMORY_MAX_TARGET 默认值=0 MEMORY_MAX_TARGET 指定了DBA可以设置MEMORY_TARGET参数的最大值 MEMORY_TARGET 默认是为0 SGA自动调整被关闭
oracle关闭自动内存管理,Oracle 11g 关闭内存自动管理
最新推荐文章于 2023-02-18 00:39:01 发布