RAC: Displays memory allocations for all current sessions in whole RAC.

Displays memory allocations for all current sessions in whole RAC.


SET LINESIZE 230
COLUMN username FORMAT A30
COLUMN module FORMAT A25
SELECT a.inst_id,
NVL(a.username,'(oracle)') AS username,
a.module,
a.program,
Trunc(b.value/1024) AS memory_kb
FROM gv$session a,
gv$sesstat b,
gv$statname c
WHERE a.sid = b.sid
AND a.inst_id = b.inst_id
AND b.statistic# = c.statistic#
AND b.inst_id = c.inst_id
AND c.name = 'session pga memory'
AND a.program IS NOT NULL
ORDER BY b.value DESC ;

March 15, 2014 В· Sanjay В· No Comments
Posted in: 3. All Scripts, 6. RAC

Leave a Reply

You must be logged in to post a comment.