memory_target、sga_target、pga_target的設定

lsq_008發表於2012-11-09
---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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章