|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$FLASH_RECOVERY_AREA_USAGE: Synonym for
V_$FLASH_RECOVERY_AREA_USAGE
iSelfSchooling-SQL> desc V$FLASH_RECOVERY_AREA_USAGE;
Name
Null? Type
----------------------------- -------- --------------------
FILE_TYPE
VARCHAR2(12)
PERCENT_SPACE_USED
NUMBER
PERCENT_SPACE_RECLAIMABLE NUMBER
NUMBER_OF_FILES
NUMBER
V$GCSHVMASTER_INFO: Synonym for V_$GCSHVMASTER_INFO
iSelfSchooling-SQL> desc V$GCSHVMASTER_INFO;
Name
Null? Type
----------------------------- -------- --------------------
HV_ID
NUMBER
CURRENT_MASTER
NUMBER
PREVIOUS_MASTER
NUMBER
REMASTER_CNT
NUMBER
V$GCSPFMASTER_INFO: Synonym for V_$GCSPFMASTER_INFO
iSelfSchooling-SQL> desc V$GCSPFMASTER_INFO;
Name
Null? Type
----------------------------- -------- --------------------
FILE_ID
NUMBER
OBJECT_ID
NUMBER
CURRENT_MASTER
NUMBER
PREVIOUS_MASTER
NUMBER
REMASTER_CNT
NUMBER
V$GC_ELEMENT: Synonym for V_$GC_ELEMENT
iSelfSchooling-SQL> desc V$GC_ELEMENT;
Name
Null? Type
----------------------------- -------- --------------------
GC_ELEMENT_ADDR
RAW(8)
INDX
NUMBER
CLASS
NUMBER
GC_ELEMENT_NAME
NUMBER
MODE_HELD
NUMBER
BLOCK_COUNT
NUMBER
RELEASING
NUMBER
ACQUIRING
NUMBER
WRITING
NUMBER
RECOVERING
NUMBER
LOCAL
NUMBER
FLAGS
NUMBER
V$GC_ELEMENTS_WITH_COLLISIONS: Synonym for V_$GC_ELEMENTS_W_COLLISIONS
iSelfSchooling-SQL> desc V$GC_ELEMENTS_WITH_COLLISIONS;
Name
Null? Type
----------------------------- -------- --------------------
GC_ELEMENT_ADDR
RAW(8)
V$GES_BLOCKING_ENQUEUE: Synonym for V_$GES_BLOCKING_ENQUEUE
iSelfSchooling-SQL> desc V$GES_BLOCKING_ENQUEUE;
Name
Null?
Type
----------------------------- -------- --------------------
HANDLE
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
STATE
VARCHAR2(64)
AST_EVENT0
NUMBER
OWNER_NODE
NUMBER
BLOCKED
NUMBER
BLOCKER
NUMBER
V$GES_ENQUEUE: Synonym for V_$GES_ENQUEUE
iSelfSchooling-SQL> desc V$GES_ENQUEUE;
Name
Null? Type
----------------------------- -------- --------------------
HANDLE
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
STATE
VARCHAR2(64)
AST_EVENT0
NUMBER
OWNER_NODE
NUMBER
BLOCKED
NUMBER
BLOCKER
NUMBER
V$GLOBALCONTEXT: Synonym for V_$GLOBALCONTEXT
iSelfSchooling-SQL> desc V$GLOBALCONTEXT;
Name
Null? Type
----------------------------- -------- --------------------
NAMESPACE
VARCHAR2(31)
ATTRIBUTE
VARCHAR2(31)
VALUE
VARCHAR2(4000)
USERNAME
VARCHAR2(31)
CLIENTIDENTIFIER
VARCHAR2(65)
V$GLOBAL_BLOCKED_LOCKS: Synonym for V_$GLOBAL_BLOCKED_LOCKS
iSelfSchooling-SQL> desc V$GLOBAL_BLOCKED_LOCKS;
Name
Null? Type
----------------------------- -------- --------------------
ADDR
RAW(8)
KADDR
RAW(8)
SID
NUMBER
TYPE
VARCHAR2(2)
ID1
NUMBER
ID2
NUMBER
LMODE
NUMBER
REQUEST
NUMBER
CTIME
NUMBER
V$GLOBAL_TRANSACTION: Synonym for V_$GLOBAL_TRANSACTION
iSelfSchooling-SQL> desc V$GLOBAL_TRANSACTION;
Name
Null?
Type
----------------------------- -------- --------------------
FORMATID
NUMBER
GLOBALID
RAW(64)
BRANCHID
RAW(64)
BRANCHES
NUMBER
REFCOUNT
NUMBER
PREPARECOUNT
NUMBER
STATE
VARCHAR2(18)
FLAGS
NUMBER
COUPLING
VARCHAR2(15)
V$HS_AGENT: Synonym for V_$HS_AGENT
iSelfSchooling-SQL> desc V$HS_AGENT;
Name
Null? Type
----------------------------- -------- --------------------
AGENT_ID
NUMBER
MACHINE
VARCHAR2(64)
PROCESS
VARCHAR2(9)
PROGRAM
VARCHAR2(48)
OSUSER
VARCHAR2(30)
STARTTIME
DATE
AGENT_TYPE
NUMBER
FDS_CLASS_ID
NUMBER
FDS_INST_ID
NUMBER
V$HS_PARAMETER: Synonym for V_$HS_PARAMETER
iSelfSchooling-SQL> desc V$HS_PARAMETER;
Name
Null? Type
----------------------------- -------- --------------------
HS_SESSION_ID
NUMBER
PARAMETER
VARCHAR2(30)
VALUE
VARCHAR2(64)
SOURCE
VARCHAR2(1)
ENV
VARCHAR2(1)
V$HS_SESSION: Synonym for V_$HS_SESSION
iSelfSchooling-SQL> desc V$HS_SESSION;
Name
Null? Type
----------------------------- -------- --------------------
HS_SESSION_ID
NUMBER
AGENT_ID
NUMBER
SID
NUMBER
DB_LINK
VARCHAR2(128)
DB_LINK_OWNER
NUMBER
|