在sqlplus中查看用户的内存使用情况

《在sqlplus中查看用户的内存使用情况》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、在sqlplus中查看用户的内存使用情况SQL>edWrotefileafiedt.buf1selecta.sid,b.name,a.valuefromv$sesstata,v$statnameb2where(b.namelike'%uga%'orb.namelike'%pga%')anda.statistic#=b.statistic#3*orderbysidSQL>/SIDNAMEVALUE------------------------------------------------------------------------------------1ses

2、sionugamemory769601sessionugamemorymax769601sessionpgamemory1997601sessionpgamemorymax1997602sessionugamemory769602sessionugamemorymax769602sessionpgamemorymax15114442sessionpgamemory15114443sessionugamemory769603sessionugamemorymax769603sessionpgamemorymax5387524SIDNAMEVALUE-----------

3、-------------------------------------------------------------------------3sessionpgamemory53875244sessionugamemory769604sessionugamemorymax769604sessionpgamemorymax11438124sessionpgamemory11438125sessionugamemory769605sessionugamemorymax769605sessionpgamemorymax3398805sessionpgamemory33

4、98806sessionugamemory769606sessionpgamemorymax208272SIDNAMEVALUE------------------------------------------------------------------------------------6sessionugamemorymax769606sessionpgamemory2082727sessionugamemory769607sessionpgamemorymax2082727sessionpgamemory2082727sessionugamemorymax

5、769608sessionugamemory2078888sessionpgamemorymax37076488sessionpgamemory37076488sessionugamemorymax2078889sessionugamemory76960SIDNAMEVALUE------------------------------------------------------------------------------------9sessionpgamemorymax44713289sessionpgamemory44713289sessionugame

6、morymax7696010sessionugamemory7696010sessionpgamemorymax447132810sessionpgamemory447132810sessionugamemorymax7696015sessionugamemory27335215sessionpgamemorymax43410415sessionpgamemory43410415sessionugamemorymax27335244rowsselected.memorymax表示曾经达到过的最大值独立模式下server进程使用的内存，就是PGA9i中进程使用内存可以通

7、过v$process来查看QL>descv$processNameNull?Type--------------------------------------------------------------------------------ADDRRAW(4)PIDNUMBERSPIDVARCHAR2(12)USERNAMEVARCHAR2(15)SERIAL#NUMBERTERMINALVARCHAR2(16)PROGRAMVARCHAR2(64)TRACEIDVARCHAR2(255)BACKGROUNDVARCHAR2(1)LATCHWAI