内存使用率查看

--内存使用率查看 select program c1,pga_used_mem c2,pga_alloc_mem c3,pga_max_mem c4 from v$process order by c4 desc select name,value from v$pgastat order by value desc select name c1,cnt c2,decode(total, 0, 0, round(cnt*100/total)) c3 from ( select name,value cnt,(sum(value) over ()) total from v$sysstat where name like 'workarea exec%' ) Select to_number(decode(SID, 65535, NULL, SID)) sid, operation_type OPERATION, trunc(WORK_AREA_SIZE/1024) WSIZE, trunc(EXPECTED_SIZE/1024) ESIZE, trunc(ACTUAL_MEM_USED/1024) MEM, trunc(MAX_MEM_USED/1024) "MAX MEM", number_passes PASS from v$sql_workarea_active order by 1,2