查看pga状态脚本
SQL> col name format a45
SQL> select * from v$pgastat;
NAME VALUE UNIT
--------------------------------------------- ---------- ------------
aggregate PGA target parameter 314572800 bytes
aggregate PGA auto target 171362304 bytes
global memory bound 62914560 bytes
total PGA inuse 124162048 bytes
total PGA allocated 143236096 bytes
maximum PGA allocated 170869760 bytes
total freeable PGA memory 7405568 bytes
process count 27
max processes count 38
PGA memory freed back to OS 43843584 bytes
total PGA used for auto workareas 0 bytes
NAME VALUE UNIT
--------------------------------------------- ---------- ------------
maximum PGA used for auto workareas 1598464 bytes
total PGA used for manual workareas 0 bytes
maximum PGA used for manual workareas 0 bytes
over allocation count 0
bytes processed 20955136 bytes
extra bytes read/written 0 bytes
cache hit percentage 100 percent
recompute count (total) 27
19 rows selected.
查看pga状态脚本
最新推荐文章于 2023-03-15 18:32:31 发布