|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$TEMPSEG_USAGE: Synonym for V_$SORT_USAGE
iSelfSchooling-SQL> desc V$TEMPSEG_USAGE;
Name
Null? Type
----------------------------- -------- --------------------
USERNAME
VARCHAR2(30)
USER
VARCHAR2(30)
SESSION_ADDR
RAW(8)
SESSION_NUM
NUMBER
SQLADDR
RAW(8)
SQLHASH
NUMBER
SQL_ID
VARCHAR2(13)
TABLESPACE
VARCHAR2(31)
CONTENTS
VARCHAR2(9)
SEGTYPE
VARCHAR2(9)
SEGFILE#
NUMBER
SEGBLK#
NUMBER
EXTENTS
NUMBER
BLOCKS
NUMBER
SEGRFNO#
NUMBER
V$TEMPSTAT: Synonym for V_$TEMPSTAT
iSelfSchooling-SQL> desc V$TEMPSTAT;
Name
Null? Type
----------------------------- -------- --------------------
FILE#
NUMBER
PHYRDS
NUMBER
PHYWRTS
NUMBER
PHYBLKRD
NUMBER
PHYBLKWRT
NUMBER
SINGLEBLKRDS
NUMBER
READTIM
NUMBER
WRITETIM
NUMBER
SINGLEBLKRDTIM
NUMBER
AVGIOTIM
NUMBER
LSTIOTIM
NUMBER
MINIOTIM
NUMBER
MAXIORTM
NUMBER
MAXIOWTM
NUMBER
V$TEMP_CACHE_TRANSFER: Synonym for V_$TEMP_CACHE_TRANSFER
iSelfSchooling-SQL> desc V$TEMP_CACHE_TRANSFER;
Name
Null? Type
----------------------------- -------- --------------------
FILE_NUMBER
NUMBER
X_2_NULL
NUMBER
X_2_NULL_FORCED_WRITE
NUMBER
X_2_NULL_FORCED_STALE
NUMBER
X_2_S
NUMBER
X_2_S_FORCED_WRITE
NUMBER
S_2_NULL
NUMBER
S_2_NULL_FORCED_STALE
NUMBER
RBR
NUMBER
RBR_FORCED_WRITE
NUMBER
NULL_2_X
NUMBER
S_2_X
NUMBER
NULL_2_S
NUMBER
V$TEMP_EXTENT_MAP: Synonym for V_$TEMP_EXTENT_MAP
iSelfSchooling-SQL> desc V$TEMP_EXTENT_MAP;
Name
Null? Type
----------------------------- -------- --------------------
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
FILE_ID
NUMBER
BLOCK_ID
NUMBER
BYTES
NUMBER
BLOCKS
NUMBER
OWNER
NUMBER
RELATIVE_FNO
NUMBER
V$TEMP_EXTENT_POOL: Synonym for V_$TEMP_EXTENT_POOL
iSelfSchooling-SQL> desc V$TEMP_EXTENT_POOL;
Name
Null? Type
----------------------------- -------- --------------------
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
FILE_ID
NUMBER
EXTENTS_CACHED
NUMBER
EXTENTS_USED
NUMBER
BLOCKS_CACHED
NUMBER
BLOCKS_USED
NUMBER
BYTES_CACHED
NUMBER
BYTES_USED
NUMBER
RELATIVE_FNO
NUMBER
V$TEMP_HISTOGRAM: Synonym for V_$TEMP_HISTOGRAM
iSelfSchooling-SQL> desc V$TEMP_HISTOGRAM;
Name
Null? Type
----------------------------- -------- --------------------
FILE#
NUMBER
SINGLEBLKRDTIM_MILLI
NUMBER
SINGLEBLKRDS
NUMBER
V$TEMP_PING: Synonym for V_$TEMP_PING
iSelfSchooling-SQL> desc V$TEMP_PING;
Name
Null? Type
----------------------------- -------- --------------------
FILE_NUMBER
NUMBER
FREQUENCY
NUMBER
X_2_NULL
NUMBER
X_2_NULL_FORCED_WRITE
NUMBER
X_2_NULL_FORCED_STALE
NUMBER
X_2_S
NUMBER
X_2_S_FORCED_WRITE
NUMBER
X_2_SSX
NUMBER
X_2_SSX_FORCED_WRITE
NUMBER
S_2_NULL
NUMBER
S_2_NULL_FORCED_STALE
NUMBER
SS_2_NULL
NUMBER
SS_2_RLS
NUMBER
WRB
NUMBER
WRB_FORCED_WRITE
NUMBER
RBR
NUMBER
RBR_FORCED_WRITE
NUMBER
RBR_FORCED_STALE
NUMBER
CBR
NUMBER
CBR_FORCED_WRITE
NUMBER
NULL_2_X
NUMBER
S_2_X
NUMBER
SSX_2_X
NUMBER
NULL_2_S
NUMBER
NULL_2_SS
NUMBER
OP_2_SS
NUMBER
V$TEMP_SPACE_HEADER: Synonym for V_$TEMP_SPACE_HEADER
iSelfSchooling-SQL> desc V$TEMP_SPACE_HEADER;
Name
Null? Type
----------------------------- -------- --------------------
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
FILE_ID
NUMBER
BYTES_USED
NUMBER
BLOCKS_USED
NUMBER
BYTES_FREE
NUMBER
BLOCKS_FREE
NUMBER
RELATIVE_FNO
NUMBER
V$THREAD: Synonym for V_$THREAD
iSelfSchooling-SQL> desc V$THREAD;
Name
Null? Type
----------------------------- -------- --------------------
THREAD#
NUMBER
STATUS
VARCHAR2(6)
ENABLED
VARCHAR2(8)
GROUPS
NUMBER
INSTANCE
VARCHAR2(80)
OPEN_TIME
DATE
CURRENT_GROUP#
NUMBER
SEQUENCE#
NUMBER
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
ENABLE_CHANGE#
NUMBER
ENABLE_TIME
DATE
DISABLE_CHANGE#
NUMBER
DISABLE_TIME
DATE
LAST_REDO_SEQUENCE#
NUMBER
LAST_REDO_BLOCK
NUMBER
LAST_REDO_CHANGE#
NUMBER
LAST_REDO_TIME
DATE
V$THRESHOLD_TYPES: Synonym for V_$THRESHOLD_TYPES
iSelfSchooling-SQL> desc V$THRESHOLD_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
METRICS_ID
NUMBER
METRICS_GROUP_ID
NUMBER
OPERATOR_MASK
NUMBER
OBJECT_TYPE
VARCHAR2(64)
ALERT_REASON_ID
NUMBER
METRIC_VALUE_TYPE
NUMBER
V$TIMER: Synonym for V_$TIMER
iSelfSchooling-SQL> desc V$TIMER;
Name
Null? Type
----------------------------- -------- --------------------
HSECS
NUMBER
V$TIMEZONE_FILE: Synonym for V_$TIMEZONE_FILE
iSelfSchooling-SQL> desc V$TIMEZONE_FILE;
Name
Null? Type
----------------------------- -------- --------------------
FILENAME
VARCHAR2(12)
VERSION
NUMBER
V$TIMEZONE_NAMES: Synonym for V_$TIMEZONE_NAMES
iSelfSchooling-SQL> desc V$TIMEZONE_NAMES;
Name
Null? Type
----------------------------- -------- --------------------
TZNAME |