一、引言:
Oracle 9i引入pga_aggregate_target,可以自动对PGA进行调整;
Oracle 10g引入sga_target,可以自动对SGA进行调整;
Oracle 11g则对这两部分进行综合,引入memory_target,可以自动调整所有的内存,这就是新引入的自动内存管理特性。
二、本文说明:
操作系统:rhel 5.4 x32
数据库:oracle 11g r2
三、memory_target的介绍:
3.1、下面通过示例了解一下memory_target的设置与PGA和SGA关系:
1 SQL> show parameter memory_target;
2
3 NAME TYPE VALUE
4 ------------------------------------ ----------- ------------------------------
5 memory_target big integer 316M
6 SQL> show sga;
7
8 Total System Global Area 330600448 bytes
9 Fixed Size 1336344 bytes
10 Variable Size 247466984 bytes
11 Database Buffers 75497472 bytes
12 Redo Buffers 6299648 bytes
13 SQL> alter system set memory_target=200m scope=spfile;
14
15 System altered.
16
17 SQL> alter system set sga_target=0 scope=spfile;
18
19 System altered.
20
21 SQL> alter system set pga_aggregate_target=0 scope=spfile;
22
23 System altered.
24
25 SQL> shutdown immediate;
26 Database closed.
27 Database dismounted.
28 ORACLE instance shut down.</