Oracle Database 11g の新機能「自動メモリ管理」を使用してみる

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
pga_aggregate_target                 big integer 11520M
sga_target                           big integer 1536M

SQL> alter system set memory_max_target=2G scope=spfile;
SQL> alter system set memory_target=2G scope=spfile;
SQL> alter system set sga_target=0 scope=spfile;
SQL> alter system set pga_aggregate_target=0 scope=spfile;
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
pga_aggregate_target                 big integer 11520M
sga_target                           big integer 1536M

SQL> shutdown immediate
SQL> startup
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 2G
memory_target                        big integer 2G
pga_aggregate_target                 big integer 0
sga_target                           big integer 0