|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$MTTR_TARGET_ADVICE: Synonym for V_$MTTR_TARGET_ADVICE
iSelfSchooling-SQL> desc V$MTTR_TARGET_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
MTTR_TARGET_FOR_ESTIMATE
NUMBER
ADVICE_STATUS
VARCHAR2(5)
DIRTY_LIMIT
NUMBER
ESTD_CACHE_WRITES
NUMBER
ESTD_CACHE_WRITE_FACTOR
NUMBER
ESTD_TOTAL_WRITES
NUMBER
ESTD_TOTAL_WRITE_FACTOR
NUMBER
ESTD_TOTAL_IOS
NUMBER
ESTD_TOTAL_IO_FACTOR
NUMBER
V$MUTEX_SLEEP: Synonym for V_$MUTEX_SLEEP
iSelfSchooling-SQL> desc V$MUTEX_SLEEP;
Name
Null? Type
----------------------------- -------- --------------------
MUTEX_TYPE
VARCHAR2(32)
LOCATION
VARCHAR2(40)
SLEEPS
NUMBER
WAIT_TIME
NUMBER
V$MUTEX_SLEEP_HISTORY: Synonym for V_$MUTEX_SLEEP_HISTORY
iSelfSchooling-SQL> desc V$MUTEX_SLEEP_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
SLEEP_TIMESTAMP
TIMESTAMP(6)
MUTEX_TYPE
VARCHAR2(32)
GETS
NUMBER
SLEEPS
NUMBER
REQUESTING_SESSION
NUMBER
BLOCKING_SESSION
NUMBER
LOCATION
VARCHAR2(40)
MUTEX_VALUE
RAW(8)
P1
NUMBER
P1RAW
RAW(8)
P2
NUMBER
P3
NUMBER
P4
NUMBER
P5
VARCHAR2(64)
V$MVREFRESH: Synonym for V_$MVREFRESH
iSelfSchooling-SQL> desc V$MVREFRESH;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
SERIAL#
NUMBER
CURRMVOWNER
VARCHAR2(31)
CURRMVNAME
VARCHAR2(31)
V$MYSTAT: Synonym for V_$MYSTAT
iSelfSchooling-SQL> desc V$MYSTAT;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
STATISTIC#
NUMBER
VALUE
NUMBER
V$NLS_PARAMETERS: Synonym for V_$NLS_PARAMETERS
iSelfSchooling-SQL> desc V$NLS_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
PARAMETER
VARCHAR2(64)
VALUE
VARCHAR2(64)
V$NLS_VALID_VALUES: Synonym for V_$NLS_VALID_VALUES
iSelfSchooling-SQL> desc V$NLS_VALID_VALUES;
Name
Null? Type
----------------------------- -------- --------------------
PARAMETER
VARCHAR2(64)
VALUE
VARCHAR2(64)
ISDEPRECATED
VARCHAR2(5)
V$OBJECT_DEPENDENCY: Synonym for V_$OBJECT_DEPENDENCY
iSelfSchooling-SQL> desc V$OBJECT_DEPENDENCY;
Name
Null? Type
----------------------------- -------- --------------------
FROM_ADDRESS
RAW(8)
FROM_HASH
NUMBER
TO_OWNER
VARCHAR2(64)
TO_NAME
VARCHAR2(1000)
TO_ADDRESS
RAW(8)
TO_HASH
NUMBER
TO_TYPE
NUMBER
V$OBSOLETE_PARAMETER: Synonym for V_$OBSOLETE_PARAMETER
iSelfSchooling-SQL> desc V$OBSOLETE_PARAMETER;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(64)
ISSPECIFIED
VARCHAR2(5)
V$OFFLINE_RANGE: Synonym for V_$OFFLINE_RANGE
iSelfSchooling-SQL> desc V$OFFLINE_RANGE;
Name
Null? Type
----------------------------- -------- --------------------
RECID
NUMBER
STAMP
NUMBER
FILE#
NUMBER
OFFLINE_CHANGE#
NUMBER
ONLINE_CHANGE#
NUMBER
ONLINE_TIME
DATE
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
V$OPEN_CURSOR: Synonym for V_$OPEN_CURSOR
iSelfSchooling-SQL> desc V$OPEN_CURSOR;
Name
Null? Type
----------------------------- -------- --------------------
SADDR
RAW(8)
SID
NUMBER
USER_NAME
VARCHAR2(30)
ADDRESS
RAW(8)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
SQL_TEXT
VARCHAR2(60)
V$OPTION: Synonym for V_$OPTION
iSelfSchooling-SQL> desc V$OPTION;
Name
Null? Type
----------------------------- -------- --------------------
PARAMETER
VARCHAR2(64)
VALUE
VARCHAR2(64)
V$OSSTAT: Synonym for V_$OSSTAT
iSelfSchooling-SQL> desc V$OSSTAT;
Name
Null? Type
----------------------------- -------- --------------------
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
OSSTAT_ID
NUMBER
V$PARALLEL_DEGREE_LIMIT_MTH: Synonym for
V_$PARALLEL_DEGREE_LIMIT_MTH
iSelfSchooling-SQL> desc V$PARALLEL_DEGREE_LIMIT_MTH;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(40)
V$PARAMETER: Synonym for V_$PARAMETER
iSelfSchooling-SQL> desc V$PARAMETER;
Name
Null? Type
----------------------------- -------- --------------------
NUM
NUMBER
NAME
VARCHAR2(80)
TYPE
NUMBER
VALUE
VARCHAR2(512)
DISPLAY_VALUE
VARCHAR2(512)
ISDEFAULT
VARCHAR2(9)
ISSES_MODIFIABLE
VARCHAR2(5)
ISSYS_MODIFIABLE
VARCHAR2(9)
ISINSTANCE_MODIFIABLE
VARCHAR2(5)
ISMODIFIED
VARCHAR2(10)
ISADJUSTED
VARCHAR2(5)
ISDEPRECATED
VARCHAR2(5)
DESCRIPTION
VARCHAR2(255)
UPDATE_COMMENT
VARCHAR2(255)
HASH
NUMBER
V$PARAMETER2: Synonym for V_$PARAMETER2
iSelfSchooling-SQL> desc V$PARAMETER2;
Name
Null? Type
----------------------------- -------- --------------------
NUM
NUMBER
NAME
VARCHAR2(80)
TYPE
NUMBER
VALUE
VARCHAR2(512)
DISPLAY_VALUE
VARCHAR2(512)
ISDEFAULT
VARCHAR2(6)
ISSES_MODIFIABLE
VARCHAR2(5)
ISSYS_MODIFIABLE
VARCHAR2(9)
ISINSTANCE_MODIFIABLE
VARCHAR2(5)
ISMODIFIED
VARCHAR2(10)
ISADJUSTED
VARCHAR2(5)
ISDEPRECATED
VARCHAR2(5)
DESCRIPTION
VARCHAR2(255)
ORDINAL
NUMBER
UPDATE_COMMENT
VARCHAR2(255)
V$PARAMETER_VALID_VALUES: Synonym for V_$PARAMETER_VALID_VALUES
iSelfSchooling-SQL> desc V$PARAMETER_VALID_VALUES;
Name
Null?
Type
----------------------------- -------- --------------------
NUM
NUMBER
NAME
VARCHAR2(64)
ORDINAL
NUMBER
VALUE
VA |