V$SORT_USAGE

Who is occupying the space in temporary tablespaces.

Columns
   ___________________________
 
   USERNAME
   USER
   SESSION_ADDR
   SESSION_NUM
   SQLADDR
   SQLHASH
   TABLESPACE
   CONTENTS
   SEGTYPE
   SEGFILE#
   SEGBLK#
   EXTENTS
   BLOCKS
   SEGRFNO#

Related:

V$GLOBAL_TRANSACTION 
V$SHARED_POOL_RESERVED 
V$SORT_SEGMENT 
V$STATNAME 
V$SYSSTAT 
V$SYSTEM_CURSOR_CACHE 
V$SYSTEM_EVENT 
V$TRANSACTION 


© Copyright SS64.com 1999-2013
Some rights reserved