9.112 V$TEMPSEG_USAGE
V$TEMPSEG_USAGE
describes temporary segment usage.
Column | Datatype | Description |
---|---|---|
|
|
User who requested temporary space |
|
|
This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in |
|
|
Session address |
|
|
Serial number of session |
|
|
Address of SQL statement |
|
|
Hash value of SQL statement |
|
|
SQL identifier of SQL statement |
|
|
Tablespace in which space is allocated |
|
|
Indicates whether tablespace is |
|
|
Type of sort segment:
|
|
|
File number of initial extent |
|
|
Block number of the initial extent |
|
|
Extents allocated to the sort |
|
|
Extents in blocks allocated to the sort |
|
|
Relative file number of initial extent |
|
|
Tablespace number |
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
SQL identifier of the SQL statement that created the temporary segment |