[Home] [Help] [Dependency Information]
Object Name: | V_$SORT_USAGE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USERNAME | VARCHAR2 | (30) | ||
USER | VARCHAR2 | (30) | ||
SESSION_ADDR | RAW | (8) | ||
SESSION_NUM | NUMBER | |||
SQLADDR | RAW | (8) | ||
SQLHASH | NUMBER | |||
SQL_ID | VARCHAR2 | (13) | ||
TABLESPACE | VARCHAR2 | (30) | Yes | |
CONTENTS | VARCHAR2 | (9) | ||
SEGTYPE | VARCHAR2 | (9) | ||
SEGFILE# | NUMBER | |||
SEGBLK# | NUMBER | |||
EXTENTS | NUMBER | |||
BLOCKS | NUMBER | |||
SEGRFNO# | NUMBER | |||
TS# | NUMBER | |||
CON_ID | NUMBER | |||
SQL_ID_TEMPSEG | VARCHAR2 | (13) |
Cut, paste (and edit) the following text to query this object:
SELECT USERNAME
, USER
, SESSION_ADDR
, SESSION_NUM
, SQLADDR
, SQLHASH
, SQL_ID
, TABLESPACE
, CONTENTS
, SEGTYPE
, SEGFILE#
, SEGBLK#
, EXTENTS
, BLOCKS
, SEGRFNO#
, TS#
, CON_ID
, SQL_ID_TEMPSEG
FROM SYS.V_$SORT_USAGE;
|
|
|