1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17

-- 修改值（需要重启数据库）

-- MEMORY_TARGET：
SELECT name, value FROM v$parameter WHERE name = 'memory_target';
-- ALTER SYSTEM SET memory_target = <new_value> SCOPE=SPFILE;

-- SGA_TARGET：
SELECT name, value FROM v$parameter WHERE name = 'sga_target';
-- ALTER SYSTEM SET sga_target = <new_value> SCOPE=SPFILE;

-- PGA_AGGREGATE_TARGET：
SELECT name, value FROM v$parameter WHERE name = 'pga_aggregate_target';
-- ALTER SYSTEM SET pga_aggregate_target = <new_value>;

-- SHARED_POOL_SIZE：
SELECT name, value FROM v$parameter WHERE name = 'shared_pool_size';
-- ALTER SYSTEM SET shared_pool_size = <new_value> SCOPE=SPFILE;