查看pga状态脚本

查看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.