V$SORT_SEGMENT

Who is occupying the space in temporary tablespaces.

Columns
   ___________________________
 
   TABLESPACE_NAME
   SEGMENT_FILE
   SEGMENT_BLOCK
   EXTENT_SIZE
   CURRENT_USERS
   TOTAL_EXTENTS
   TOTAL_BLOCKS
   USED_EXTENTS
   USED_BLOCKS
   FREE_EXTENTS
   FREE_BLOCKS
   ADDED_EXTENTS
   EXTENT_HITS
   FREED_EXTENTS
   FREE_REQUESTS
   MAX_SIZE
   MAX_BLOCKS
   MAX_USED_SIZE
   MAX_USED_BLOCKS
   MAX_SORT_SIZE
   MAX_SORT_BLOCKS
   RELATIVE_FNO

Related:

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


© Copyright SS64.com 1999-2013
Some rights reserved