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

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博客 ” ，链接：http://blog.itpub.net/26764973/viewspace-764862/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26764973/viewspace-764862/