oracle pga不够的现象,经验少，抓瞎了：PGA的使用情况分析【已结贴】

现在系统慢，却找不到解决的办法，PGA Cache Hit非常低，做了一个statspack，

其中关于PGA的部分我贴到附件里了，请大家帮忙分析下吧，非常感谢！

PGA Aggr Target Stats for DB: ORCL  Instance: orcl  Snaps: 12 -14

-> B: Begin snap   E: End snap (rows dentified with B or E contain data

which is absolute i.e. not diffed over the interval)

-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

-> Auto PGA Target - actual workarea memory target

-> W/A PGA Used    - amount of memory used for all Workareas (manual + auto)

-> %PGA W/A Mem    - percentage of PGA memory allocated to workareas

-> %Auto W/A Mem   - percentage of workarea memory controlled by Auto Mem Mgmt

-> %Man W/A Mem    - percentage of workarea memory under manual control

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written

--------------- -------