1、show parameter

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 404M

memory_target big integer 404M

parallel_servers_target integer 4

pga_aggregate_target big integer 0

sga_target big integer 0

2、Run the following query to determine the maximum instance PGA allocated

since the database was started:

select value from v$pgastat where name='maximum PGA allocated';

3、set memory_target

memory_target = sga_target + max(pga_aggregate_target, maximum PGA

allocated)

ITPub博客

将手动内存管理变为自动管理内存 ORACLE 11G