这是最后面的结果输出:
Thu Jan 12 page 1523
PGA = dedicated server processes - UGA = Client machine process
SID Name Max Bytes
----- ------------------------- -----------------
72 session uga memory max 54,003,952
72 session pga memory 54,594,312
72 session pga memory max 54,659,848
2614 session uga memory max 620,655,792
2614 session pga memory max 644,680,456
-----------------
sum 10,646,394,424
12181 rows selected.
SQL> spool off
最后面的sum的值就是所有的session占用的物理内存吗?
10646394424/1024/1024/1024=9.91522G
2012-1-12 12:38 上传
点击文件名下载附件
49 KB, 下载次数: 1166