used temp tbs per each session

SET termout ON
> > SET heading ON
> > SET PAGESIZE 60
> > SET LINESIZE 126
> >
> > COLUMN tablespace FORMAT a20 HEADING 'Tablespace|Name'
> > COLUMN tablespace_name FORMAT a20 HEADING 'Tablespace|Name'
> > COLUMN username FORMAT a12 HEADING 'Oracle|Username'
> > COLUMN Client_User FORMAT a20 HEADING 'Client|Username'
> > COLUMN osuser FORMAT a12 HEADING 'O/S|Username'
> >
> > TTITLE CENTER 'Who/What is Using Which SORT Tablespace' -
> > skip Center '~~~~~~~~~~~~~~~~~~~~~~~~~~~' -
> > skip 2
> > repfooter off
> > btitle off
> >
> > 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;
> > ;
> >
> > select tablespace_name, used_blocks, free_blocks, total_blocks
> > from v$sort_segment;
> >