📋Steps in this guide1/1

Pga usage by sessions

set lines 2000 SELECT SID, b.NAME, ROUND(a.VALUE/(1024*1024),2) MB FROM v$sesstat a, v$statname b WHERE (NAME LIKE '%session uga memory%' OR NAME LIKE '%session pga memory%') AND a.statistic# = b.statistic# order by ROUND(a.VALUE/(1024*1024),2) desc

oracle configurationintermediate

by OracleDba

13 views

Pga usage by sessions

Code/Command (click line numbers to comment):

set lines 2000
SELECT SID, b.NAME, ROUND(a.VALUE/(1024*1024),2) MB FROM
v$sesstat a, v$statname b
WHERE (NAME LIKE '%session uga memory%' OR NAME LIKE '%session pga memory%')
AND a.statistic# = b.statistic# order by ROUND(a.VALUE/(1024*1024),2) desc

Comments (0)

Please to add comments

No comments yet. Be the first to comment!