|
USER |
VARCHAR2(30) |
This column is obsolete and maintained only for compatibility reasons. The value of this column is always equal to the value in USERNAME. |
|
USERNAME |
VARCHAR2(30) |
User who requested temporary space |
|
SESSION_ADDR |
RAW(4) |
Address of shared SQL cursor |
|
SESSION_NUM |
NUMBER |
Serial number of session |
|
SQLADDR |
RAW(4) |
Address of SQL statement |
|
SQLHASH |
NUMBER |
Hash value of SQL statement |
|
TABLESPACE |
VARCHAR2(31) |
Tablespace in which space is allocated |
|
CONTENTS |
VARCHAR2(9) |
Indicates whether tablespace is TEMPORARY|PERMANENT |
|
SEGTYPE |
VARCHAR2(9) |
|
|
SEGFILE# |
NUMBER |
File number of initial extent |
|
SEGBLK# |
NUMBER |
Block number of the initial extent |
|
EXTENTS |
NUMBER |
Extents allocated to the sort |
|
BLOCKS |
NUMBER |
Extents in blocks allocated to the sort |
|
SEGRFNO# |
NUMBER |
Relative file number of initial extent |
