q_sga_usage

admin

1. --查询当前pga使用总量和平均使用量
   
2. select round(sum(pga_used_mem) / 1024 / 1024, 0) total_used,
   
3.        count(1) pnumber,
   
4.        round(sum(pga_used_mem) / count(1) / 1024 / 1024, 0) used_avg,
   
5.        round(sum(pga_alloc_mem) / 1024 / 1024, 0) totao_alloc,
   
6.        round(sum(pga_alloc_mem) / count(1) / 1024 / 1024, 0) alloc_avg
   
7.   from v$process
   
8. /
   

复制代码