调整数据库参数

以dba角色登录

1、查询数据库参数
select * name, value from v$parameter where name like '%size';

2、调整数据库参数

alter system set sga_max_size=2400m scope=spfile;

alter system set db_cache_size=1200m scope=spfile;

alter system set shared_pool_size=480m scope=spfile;

alter system set pga_aggregate_target=512m scope=spfile;

alter system set parallel_automatic_tuning=TRUE scope=spfile;

alter system set workarea_size_policy='AUTO' scope=spfile;

alter system set large_pool_size=80m scope=spfile;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/720091/viewspace-838152/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/720091/viewspace-838152/