SQL Script Session Details

Updated : 20-March-2002
Version : 1.1

Description

This script reports for each session in the database the objects accessed by the session and the memory used by each session.

Parameters

None

SQL Source

spool sessdets.lst
set pages 200

col name form a30
col username form a12
col sid form 999
col owner form a12
col object form a20
col type form a10

prompt
prompt Objects Accessed per Session
prompt 

select a.sid, a.username, b.*
from v$session a, v$access b
where a.sid = b.sid
order by a.sid
/
prompt
prompt Memory per Session
prompt

select a.sid, a.username, c.name, b.value
from v$session a, v$sesstat b, v$statname c
where a.sid = b.sid
and b.statistic# = c.statistic#
and c.name like 'session%memory'
order by a.sid
/
spool off                                                              

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz Legal