Memory Usage For Sessions

SET SERVEROUTPUT ON
SET ECHO OFF
SET FEEDBACK OFF
SET PAGES 80
SET LINES 132

REM
REM || Title : show_mem_usage.sql
REM ||
REM || Purpose : This script show how much memory is used by sessions.
REM ||
REM ||
REM || Release No : 1
REM ||
REM || Variables : None
REM ||
REM || Schema : system
REM ||
REM ||


SELECT DISTINCT SUBSTR (username, 1, 8) username,
sid,
SUBSTR (persistent_mem, 1, 8) persit_mem,
SUBSTR (runtime_mem, 1, 8) runtime_mem,
SUBSTR (kglnaobj, 1, 60) sql_run
FROM v$session,
x$kglcursor,
v$sqlarea
WHERE prev_sql_addr = kglhdpar
AND prev_hash_value = kglnahsh
AND kglhdpar = address
AND kglnahsh = hash_value

SPOOL show_mem_usage.lis
/
SPOOL OFF


SET SERVEROUTPUT ON
SET FEEDBACK ON
This script is provided for educational purposes only. The script has been tested and appears to work as intended. However, you should always test any script before relying on it. No responsibility will be accepted for Lost or damage that may occur from it's use.