memory_target、sga_target、pga_target的设置

---memory_target设置为非0时

SQL> show parameter target 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

archive_lag_target                   integer     0

db_flashback_retention_target        integer     1440

fast_start_io_target                 integer     0

fast_start_mttr_target               integer     0

memory_max_target                    big integer 800M

memory_target                        big integer 800M

parallel_servers_target              integer     8

pga_aggregate_target                 big integer 600M

sga_target                           big integer 152M

SQL> alter system set pga_aggregate_target=100m scope=both;

System altered.

SQL> alter system set sga_target=100m scope=both;

System altered.

SQL> show parameter target

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

archive_lag_target                   integer     0

db_flashback_retention_target        integer     1440

fast_start_io_target                 integer     0

fast_start_mttr_target               integer     0

memory_max_target                    big integer 800M

memory_target                        big integer 800M

parallel_servers_target              integer     8

pga_aggregate_target                 big integer 100M

sga_target                           big integer 100M

从spfile创建pfile，内容：

mbs.__db_cache_size=29360128

mbs.__java_pool_size=4194304

mbs.__large_pool_size=4194304

mbs.__oracle_base='/home/db/oracle'#ORACLE_BASE set from environment

mbs.__pga_aggregate_target=629145600

mbs.__sga_target=209715200

mbs.__shared_io_pool_size=0

mbs.__shared_pool_size=159383552

mbs.__streams_pool_size=4194304

---memory target 设置为0时

SQL> show parameter target

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

archive_lag_target                   integer     0

db_flashback_retention_target        integer     1440

fast_start_io_target                 integer     0

fast_start_mttr_target               integer     0

memory_max_target                    big integer 0

memory_target                        big integer 0

parallel_servers_target              integer     8

pga_aggregate_target                 big integer 100M

sga_target                           big integer 152M

mbs.__db_cache_size=16777216

mbs.__java_pool_size=4194304

mbs.__large_pool_size=4194304

mbs.__oracle_base='/home/db/oracle'#ORACLE_BASE set from environment

mbs.__pga_aggregate_target=104857600

mbs.__sga_target=159383552

mbs.__shared_io_pool_size=0

mbs.__shared_pool_size=121634816

mbs.__streams_pool_size=4194304

结论：

memory_target设置为非0时，sga_target及pga_aggregate_target设置无效。

memory_target设置为0时，sga_target及pga_aggregate_target设置有效。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10972173/viewspace-748859/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10972173/viewspace-748859/