Temp space usage per session

–how who is using all sort ( TEMP ) space. See showTempUsers.sql
set pagesize 10000
set linesize 133
col tablespace format a15 heading ‘Tablespace Name’
col segfile# format 9,999 heading ‘File|ID’
col segblk# format 999,999,999 heading ‘Block|ID’
col blocks format 999,999,999 heading ‘Blocks’
col username format a15
select b.tablespace,b.segfile#,b.segblk#,b.blocks,a.sid,a.serial#,a.username,a.osuser,a.status
from V$SESSION a,V$SORT_USAGE b where a.saddr = b.session_addr order by b.tablespace,b.segfile#,b.segblk#,b.blocks;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: