|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$DELETED_OBJECT: Synonym for V_$DELETED_OBJECT
iSelfSchooling-SQL> desc V$DELETED_OBJECT;
Name
Null? Type
----------------------------- -------- --------------------
RECID
NUMBER
STAMP
NUMBER
TYPE
VARCHAR2(26)
OBJECT_RECID
NUMBER
OBJECT_STAMP
NUMBER
OBJECT_DATA
NUMBER
V$DISPATCHER: Synonym for V_$DISPATCHER
iSelfSchooling-SQL> desc V$DISPATCHER;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(4)
NETWORK
VARCHAR2(128)
PADDR
RAW(8)
STATUS
VARCHAR2(16)
ACCEPT
VARCHAR2(3)
MESSAGES
NUMBER
BYTES
NUMBER
BREAKS
NUMBER
OWNED
NUMBER
CREATED
NUMBER
IDLE
NUMBER
BUSY
NUMBER
LISTENER
NUMBER
CONF_INDX
NUMBER
V$DISPATCHER_CONFIG: Synonym for V_$DISPATCHER_CONFIG
iSelfSchooling-SQL> desc V$DISPATCHER_CONFIG;
Name
Null? Type
----------------------------- -------- --------------------
CONF_INDX
NUMBER
NETWORK
VARCHAR2(128)
DISPATCHERS
NUMBER
CONNECTIONS
NUMBER
SESSIONS
NUMBER
POOL
VARCHAR2(4)
TICKS
NUMBER
INBD_TIMOUT
NUMBER
OUTBD_TIMOUT
NUMBER
MULTIPLEX
VARCHAR2(4)
LISTENER
VARCHAR2(1200)
SERVICE
VARCHAR2(512)
V$DISPATCHER_RATE: Synonym for V_$DISPATCHER_RATE
iSelfSchooling-SQL> desc V$DISPATCHER_RATE;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(4)
PADDR
RAW(8)
CUR_LOOP_RATE
NUMBER
CUR_EVENT_RATE
NUMBER
CUR_EVENTS_PER_LOOP
NUMBER
CUR_MSG_RATE
NUMBER
CUR_SVR_BUF_RATE
NUMBER
CUR_SVR_BYTE_RATE
NUMBER
CUR_SVR_BYTE_PER_BUF
NUMBER
CUR_CLT_BUF_RATE
NUMBER
CUR_CLT_BYTE_RATE
NUMBER
CUR_CLT_BYTE_PER_BUF
NUMBER
CUR_BUF_RATE
NUMBER
CUR_BYTE_RATE
NUMBER
CUR_BYTE_PER_BUF
NUMBER
CUR_IN_CONNECT_RATE
NUMBER
CUR_OUT_CONNECT_RATE
NUMBER
CUR_RECONNECT_RATE
NUMBER
MAX_LOOP_RATE
NUMBER
MAX_EVENT_RATE
NUMBER
MAX_EVENTS_PER_LOOP
NUMBER
MAX_MSG_RATE
NUMBER
MAX_SVR_BUF_RATE
NUMBER
MAX_SVR_BYTE_RATE
NUMBER
MAX_SVR_BYTE_PER_BUF
NUMBER
MAX_CLT_BUF_RATE
NUMBER
MAX_CLT_BYTE_RATE
NUMBER
MAX_CLT_BYTE_PER_BUF
NUMBER
MAX_BUF_RATE
NUMBER
MAX_BYTE_RATE
NUMBER
MAX_BYTE_PER_BUF
NUMBER
MAX_IN_CONNECT_RATE
NUMBER
MAX_OUT_CONNECT_RATE
NUMBER
MAX_RECONNECT_RATE
NUMBER
AVG_LOOP_RATE
NUMBER
AVG_EVENT_RATE
NUMBER
AVG_EVENTS_PER_LOOP
NUMBER
AVG_MSG_RATE
NUMBER
AVG_SVR_BUF_RATE
NUMBER
AVG_SVR_BYTE_RATE
NUMBER
AVG_SVR_BYTE_PER_BUF
NUMBER
AVG_CLT_BUF_RATE
NUMBER
AVG_CLT_BYTE_RATE
NUMBER
AVG_CLT_BYTE_PER_BUF
NUMBER
AVG_BUF_RATE
NUMBER
AVG_BYTE_RATE
NUMBER
AVG_BYTE_PER_BUF
NUMBER
AVG_IN_CONNECT_RATE
NUMBER
AVG_OUT_CONNECT_RATE
NUMBER
AVG_RECONNECT_RATE
NUMBER
TTL_LOOPS
NUMBER
TTL_MSG
NUMBER
TTL_SVR_BUF
NUMBER
TTL_CLT_BUF
NUMBER
TTL_BUF
NUMBER
TTL_IN_CONNECT
NUMBER
TTL_OUT_CONNECT
NUMBER
TTL_RECONNECT
NUMBER
SCALE_LOOPS
NUMBER
SCALE_MSG
NUMBER
SCALE_SVR_BUF
NUMBER
SCALE_CLT_BUF
NUMBER
SCALE_BUF
NUMBER
SCALE_IN_CONNECT
NUMBER
SCALE_OUT_CONNECT
NUMBER
SCALE_RECONNECT
NUMBER
V$DLM_ALL_LOCKS: Synonym for V_$DLM_ALL_LOCKS
iSelfSchooling-SQL> desc V$DLM_ALL_LOCKS;
Name
Null? Type
----------------------------- -------- --------------------
LOCKP
RAW(8)
GRANT_LEVEL
VARCHAR2(9)
REQUEST_LEVEL
VARCHAR2(9)
RESOURCE_NAME1
VARCHAR2(30)
RESOURCE_NAME2
VARCHAR2(30)
PID
NUMBER
TRANSACTION_ID0
NUMBER
TRANSACTION_ID1
NUMBER
GROUP_ID
NUMBER
OPEN_OPT_DEADLOCK
NUMBER
OPEN_OPT_PERSISTENT
NUMBER
OPEN_OPT_PROCESS_OWNED
NUMBER
OPEN_OPT_NO_XID
NUMBER
CONVERT_OPT_GETVALUE
NUMBER
CONVERT_OPT_PUTVALUE
NUMBER
CONVERT_OPT_NOVALUE
NUMBER
CONVERT_OPT_DUBVALUE
NUMBER
CONVERT_OPT_NOQUEUE
NUMBER
CONVERT_OPT_EXPRESS
NUMBER
CONVERT_OPT_NODEADLOCKWAIT NUMBER
CONVERT_OPT_NODEADLOCKBLOCK
NUMBER
WHICH_QUEUE
NUMBER
LOCKSTATE
VARCHAR2(64)
AST_EVENT0
NUMBER
OWNER_NODE
NUMBER
BLOCKED
NUMBER
BLOCKER
NUMBER
V$DLM_CONVERT_LOCAL: Synonym for V_$DLM_CONVERT_LOCAL
iSelfSchooling-SQL> desc V$DLM_CONVERT_LOCAL;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CONVERT_TYPE
VARCHAR2(16)
AVERAGE_CONVERT_TIME
NUMBER
CONVERT_COUNT
NUMBER
V$DLM_CONVERT_REMOTE: Synonym for V_$DLM_CONVERT_REMOTE
iSelfSchooling-SQL> desc V$DLM_CONVERT_REMOTE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CONVERT_TYPE
VARCHAR2(16)
AVERAGE_CONVERT_TIME
NUMBER
CONVERT_COUNT
NUMBER
V$DLM_LATCH: Synonym for V_$DLM_LATCH
iSelfSchooling-SQL> desc V$DLM_LATCH;
Name
Null? Type
----------------------------- -------- --------------------
ADDR
RAW(8)
LATCH#
NUMBER
LEVEL#
NUMBER
NAME
VARCHAR2(50)
GETS
NUMBER
MISSES
NUMBER
SLEEPS
NUMBER
IMMEDIATE_GETS
NUMBER
IMMEDIATE_MISSES
NUMBER
WAITERS_WOKEN
NUMBER
WAITS_HOLDING_LATCH
NUMBER
SPIN_GETS
NUMBER
SLEEP1
NUMBER
|