|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$SEGMENT_STATISTICS: Synonym for V_$SEGMENT_STATISTICS
iSelfSchooling-SQL> desc V$SEGMENT_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
SUBOBJECT_NAME
VARCHAR2(30)
TABLESPACE_NAME
VARCHAR2(30)
TS#
NUMBER
OBJ#
NUMBER
DATAOBJ#
NUMBER
OBJECT_TYPE
VARCHAR2(18)
STATISTIC_NAME
VARCHAR2(64)
STATISTIC#
NUMBER
VALUE
NUMBER
V$SEGSTAT: Synonym for V_$SEGSTAT
iSelfSchooling-SQL> desc V$SEGSTAT;
Name
Null? Type
----------------------------- -------- --------------------
TS#
NUMBER
OBJ#
NUMBER
DATAOBJ#
NUMBER
STATISTIC_NAME
VARCHAR2(64)
STATISTIC#
NUMBER
VALUE
NUMBER
V$SEGSTAT_NAME: Synonym for V_$SEGSTAT_NAME
iSelfSchooling-SQL> desc V$SEGSTAT_NAME;
Name
Null? Type
----------------------------- -------- --------------------
STATISTIC#
NUMBER
NAME
VARCHAR2(64)
SAMPLED
VARCHAR2(3)
V$SERVICEMETRIC: Synonym for V_$SERVICEMETRIC
iSelfSchooling-SQL> desc V$SERVICEMETRIC;
Name
Null? Type
----------------------------- -------- --------------------
BEGIN_TIME
DATE
END_TIME
DATE
INTSIZE_CSEC
NUMBER
GROUP_ID
NUMBER
SERVICE_NAME_HASH
NUMBER
SERVICE_NAME
VARCHAR2(64)
CTMHASH
NUMBER
ELAPSEDPERCALL
NUMBER
CPUPERCALL
NUMBER
DBTIMEPERCALL
NUMBER
CALLSPERSEC
NUMBER
DBTIMEPERSEC
NUMBER
GOODNESS
NUMBER
DELTA
NUMBER
FLAGS
NUMBER
V$SERVICEMETRIC_HISTORY: Synonym for V_$SERVICEMETRIC_HISTORY
iSelfSchooling-SQL> desc V$SERVICEMETRIC_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
BEGIN_TIME
DATE
END_TIME
DATE
INTSIZE_CSEC
NUMBER
GROUP_ID
NUMBER
SERVICE_NAME_HASH
NUMBER
SERVICE_NAME
VARCHAR2(64)
CTMHASH
NUMBER
ELAPSEDPERCALL
NUMBER
CPUPERCALL
NUMBER
DBTIMEPERCALL
NUMBER
CALLSPERSEC
NUMBER
DBTIMEPERSEC
NUMBER
V$SERVICES: Synonym for V_$SERVICES
iSelfSchooling-SQL> desc V$SERVICES;
Name
Null? Type
----------------------------- -------- --------------------
SERVICE_ID
NUMBER
NAME
VARCHAR2(64)
NAME_HASH
NUMBER
NETWORK_NAME
VARCHAR2(512)
CREATION_DATE
DATE
CREATION_DATE_HASH
NUMBER
GOAL
VARCHAR2(12)
DTP
VARCHAR2(1)
AQ_HA_NOTIFICATION
VARCHAR2(3)
CLB_GOAL
VARCHAR2(5)
V$SERVICE_EVENT: Synonym for V_$SERVICE_EVENT
iSelfSchooling-SQL> desc V$SERVICE_EVENT;
Name
Null? Type
----------------------------- -------- --------------------
SERVICE_NAME
VARCHAR2(64)
SERVICE_NAME_HASH
NUMBER
EVENT
VARCHAR2(64)
EVENT_ID
NUMBER
TOTAL_WAITS
NUMBER
TOTAL_TIMEOUTS
NUMBER
TIME_WAITED
NUMBER
AVERAGE_WAIT
NUMBER
MAX_WAIT
NUMBER
TIME_WAITED_MICRO
NUMBER
V$SERVICE_STATS: Synonym for V_$SERVICE_STATS
iSelfSchooling-SQL> desc V$SERVICE_STATS;
Name
Null? Type
----------------------------- -------- --------------------
SERVICE_NAME_HASH
NUMBER
SERVICE_NAME
VARCHAR2(64)
STAT_ID
NUMBER
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
V$SERVICE_WAIT_CLASS: Synonym for V_$SERVICE_WAIT_CLASS
iSelfSchooling-SQL> desc V$SERVICE_WAIT_CLASS;
Name
Null? Type
----------------------------- -------- --------------------
SERVICE_NAME
VARCHAR2(64)
SERVICE_NAME_HASH
NUMBER
WAIT_CLASS_ID
NUMBER
WAIT_CLASS#
NUMBER
WAIT_CLASS
VARCHAR2(64)
TOTAL_WAITS
NUMBER
TIME_WAITED
NUMBER
V$SERV_MOD_ACT_STATS: Synonym for V_$SERV_MOD_ACT_STATS
iSelfSchooling-SQL> desc V$SERV_MOD_ACT_STATS;
Name
Null? Type
----------------------------- -------- --------------------
AGGREGATION_TYPE
VARCHAR2(21)
SERVICE_NAME
VARCHAR2(64)
MODULE
VARCHAR2(49)
ACTION
VARCHAR2(33)
STAT_ID
NUMBER
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
V$SESSION: Synonym for V_$SESSION
iSelfSchooling-SQL> desc V$SESSION;
Name
Null? Type
----------------------------- -------- --------------------
SADDR
RAW(8)
SID
NUMBER
SERIAL#
NUMBER
AUDSID
NUMBER
PADDR
RAW(8)
USER#
NUMBER
USERNAME
VARCHAR2(30)
COMMAND
NUMBER
OWNERID
NUMBER
TADDR
VARCHAR2(16)
LOCKWAIT
VARCHAR2(16)
STATUS
VARCHAR2(8)
SERVER
VARCHAR2(9)
SCHEMA#
NUMBER
SCHEMANAME
VARCHAR2(30)
OSUSER
VARCHAR2(30)
PROCESS
VARCHAR2(12)
MACHINE
VARCHAR2(64)
TERMINAL
VARCHAR2(30)
PROGRAM
VARCHAR2(48)
TYPE
VARCHAR2(10)
SQL_ADDRESS
RAW(8)
SQL_HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
SQL_CHILD_NUMBER
NUMBER
PREV_SQL_ADDR
RAW(8)
PREV_HASH_VALUE
NUMBER
PREV_SQL_ID
VARCHAR2(13)
PREV_CHILD_NUMBER
NUMBER
MODULE
VARCHAR2(48)
MODULE_HASH
NUMBER
ACTION
VARCHAR2(32)
ACTION_HASH
NUMBER
CLIENT_INFO
VARCHAR2(64)
FIXED_TABLE_SEQUENCE
NUMBER
ROW_WAIT_OBJ#
NUMBER
ROW_WAIT_FILE#
NUMBER
ROW_WAIT_BLOCK#
NUMBER
ROW_WAIT_ROW#
NUMBER
LOGON_TIME
DATE
LAST_CALL_ET
NUMBER
PDML_ENABLED
VARCHAR2(3)
FAILOVER_TYPE
VARCHAR2(13)
|