查看pga最大使用量：
select inst_id,name, ROUND(value/1024/1024) as Mbytes from gv$pgastat
where name in ('maximum PGA allocated','aggregate PGA target parameter','aggregate PGA auto target');
查看sga/pga等设置：
select con_id, name as Parameter, value/1024/1024 as Mbytes from V$SYSTEM_PARAMETER
where name in ('pga_aggregate_target','memory_target','memory_max_target','sga_max_size','sga_target','pga_aggregate_limit','processes')
order by name;
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对