SQL Script Session Details

Updated: 20-Mar-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

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

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

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links