|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$ACCESS: Synonym for V_$ACCESS
iSelfSchooling-SQL> desc V$ACCESS;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
OWNER
VARCHAR2(64)
OBJECT
VARCHAR2(1000)
TYPE
VARCHAR2(24)
V$ACTIVE_INSTANCES: Synonym for V_$ACTIVE_INSTANCES
iSelfSchooling-SQL> desc V$ACTIVE_INSTANCES;
Name
Null? Type
----------------------------- -------- --------------------
INST_NUMBER
NUMBER
INST_NAME
VARCHAR2(60)
V$ACTIVE_SERVICES: Synonym for V_$ACTIVE_SERVICES
iSelfSchooling-SQL> desc V$ACTIVE_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)
BLOCKED
VARCHAR2(3)
AQ_HA_NOTIFICATION
VARCHAR2(3)
CLB_GOAL
VARCHAR2(5)
V$ACTIVE_SESSION_HISTORY: Synonym for V_$ACTIVE_SESSION_HISTORY
iSelfSchooling-SQL> desc V$ACTIVE_SESSION_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
SAMPLE_ID
NUMBER
SAMPLE_TIME
TIMESTAMP(3)
SESSION_ID
NUMBER
SESSION_SERIAL#
NUMBER
USER_ID
NUMBER
SQL_ID
VARCHAR2(13)
SQL_CHILD_NUMBER
NUMBER
SQL_PLAN_HASH_VALUE
NUMBER
FORCE_MATCHING_SIGNATURE
NUMBER
SQL_OPCODE
NUMBER
SERVICE_HASH
NUMBER
SESSION_TYPE
VARCHAR2(10)
SESSION_STATE
VARCHAR2(7)
QC_SESSION_ID
NUMBER
QC_INSTANCE_ID
NUMBER
BLOCKING_SESSION
NUMBER
BLOCKING_SESSION_STATUS
VARCHAR2(11)
BLOCKING_SESSION_SERIAL#
NUMBER
EVENT
VARCHAR2(64)
EVENT_ID
NUMBER
EVENT#
NUMBER
SEQ#
NUMBER
P1TEXT
VARCHAR2(64)
P1
NUMBER
P2TEXT
VARCHAR2(64)
P2
NUMBER
P3TEXT
VARCHAR2(64)
P3
NUMBER
WAIT_CLASS
VARCHAR2(64)
WAIT_CLASS_ID
NUMBER
WAIT_TIME
NUMBER
TIME_WAITED
NUMBER
XID
RAW(8)
CURRENT_OBJ#
NUMBER
CURRENT_FILE#
NUMBER
CURRENT_BLOCK#
NUMBER
PROGRAM
VARCHAR2(48)
MODULE
VARCHAR2(48)
ACTION
VARCHAR2(32)
CLIENT_ID
VARCHAR2(64)
V$ACTIVE_SESS_POOL_MTH: Synonym for V_$ACTIVE_SESS_POOL_MTH
iSelfSchooling-SQL> desc V$ACTIVE_SESS_POOL_MTH;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(40)
V$ADVISOR_PROGRESS: Synonym for V_$ADVISOR_PROGRESS
iSelfSchooling-SQL> desc V$ADVISOR_PROGRESS;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
SERIAL#
NUMBER
USERNAME
VARCHAR2(30)
OPNAME
VARCHAR2(64)
ADVISOR_NAME
VARCHAR2(64)
TASK_ID
NUMBER
TARGET_DESC
VARCHAR2(32)
SOFAR
NUMBER
TOTALWORK
NUMBER
UNITS
VARCHAR2(32)
BENEFIT_SOFAR
NUMBER
BENEFIT_MAX
NUMBER
FINDINGS
NUMBER
RECOMMENDATIONS
NUMBER
TIME_REMAINING
NUMBER
START_TIME
DATE
LAST_UPDATE_TIME
DATE
ELAPSED_SECONDS
NUMBER
ADVISOR_METRIC1
NUMBER
METRIC1_DESC
VARCHAR2(64)
V$ALERT_TYPES: Synonym for V_$ALERT_TYPES
iSelfSchooling-SQL> desc V$ALERT_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
REASON_ID
NUMBER
OBJECT_TYPE
VARCHAR2(64)
TYPE
VARCHAR2(9)
GROUP_NAME
VARCHAR2(64)
SCOPE
VARCHAR2(8)
INTERNAL_METRIC_CATEGORY
VARCHAR2(64)
INTERNAL_METRIC_NAME
VARCHAR2(64)
V$AQ: Synonym for V_$AQ
iSelfSchooling-SQL> desc V$AQ;
Name
Null? Type
----------------------------- -------- --------------------
QID
NUMBER
WAITING
NUMBER
READY
NUMBER
EXPIRED
NUMBER
TOTAL_WAIT
NUMBER
AVERAGE_WAIT
NUMBER
V$AQ1: Synonym for V_$AQ1
iSelfSchooling-SQL> desc V$AQ1;
Name
Null? Type
----------------------------- -------- --------------------
QID
NUMBER
WAITING
NUMBER
READY
NUMBER
EXPIRED
NUMBER
TOTAL_CONSUMERS
NUMBER
TOTAL_WAIT
NUMBER
AVERAGE_WAIT
NUMBER
V$ARCHIVE: Synonym for V_$ARCHIVE
iSelfSchooling-SQL> desc V$ARCHIVE;
Name
Null? Type
----------------------------- -------- --------------------
GROUP#
NUMBER
THREAD#
NUMBER
SEQUENCE#
NUMBER
ISCURRENT
VARCHAR2(3)
CURRENT
VARCHAR2(3)
FIRST_CHANGE#
NUMBER
V$ARCHIVED_LOG: Synonym for V_$ARCHIVED_LOG
iSelfSchooling-SQL> desc V$ARCHIVED_LOG;
Name
Null? Type
----------------------------- -------- --------------------
RECID
NUMBER
STAMP
NUMBER
NAME
VARCHAR2(513)
DEST_ID
NUMBER
THREAD#
NUMBER
SEQUENCE#
NUMBER
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
RESETLOGS_ID
NUMBER
FIRST_CHANGE#
NUMBER
FIRST_TIME
DATE
NEXT_CHANGE#
NUMBER
NEXT_TIME
DATE
BLOCKS
NUMBER
BLOCK_SIZE
NUMBER
CREATOR
VARCHAR2(7)
REGISTRAR
VARCHAR2(7)
STANDBY_DEST
VARCHAR2(3)
ARCHIVED
VARCHAR2(3)
APPLIED
VARCHAR2(3)
DELETED
VARCHAR2(3)
STATUS
VARCHAR2(1)
COMPLETION_TIME
DATE
DICTIONARY_BEGIN
VARCHAR2(3)
DICTIONARY_END
VARCHAR2(3)
|