查看pga状态脚本

查看pga状态脚本SQL> col name format a45SQL> select *  from v$pgastat;NAME                                               VALUE UNIT--------------------------------------------- ---------- ------------aggregate PGA target parameter                 314572800 bytesaggregate PGA auto target                      171362304 bytesglobal memory bound                             62914560 bytestotal PGA inuse                                124162048 bytestotal PGA allocated                            143236096 bytesmaximum PGA allocated                          170869760 bytestotal freeable PGA memory                        7405568 bytesprocess count                                         27max processes count                                   38PGA memory freed back to OS                     43843584 bytestotal PGA used for auto workareas                      0 bytesNAME                                               VALUE UNIT--------------------------------------------- ---------- ------------maximum PGA used for auto workareas              1598464 bytestotal PGA used for manual workareas                    0 bytesmaximum PGA used for manual workareas                  0 bytesover allocation count                                  0bytes processed                                 20955136 bytesextra bytes read/written                               0 bytescache hit percentage                                 100 percentrecompute count (total)                               2719 rows selected.