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
VARCHAR2(255)
ISDEFAULT
VARCHAR2(64)
V$PGASTAT: Synonym for V_$PGASTAT
iSelfSchooling-SQL> desc V$PGASTAT;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(64)
VALUE
NUMBER
UNIT
VARCHAR2(12)
V$PGA_TARGET_ADVICE: Synonym for V_$PGA_TARGET_ADVICE
iSelfSchooling-SQL> desc V$PGA_TARGET_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
PGA_TARGET_FOR_ESTIMATE
NUMBER
PGA_TARGET_FACTOR
NUMBER
ADVICE_STATUS
VARCHAR2(3)
BYTES_PROCESSED
NUMBER
ESTD_EXTRA_BYTES_RW
NUMBER
ESTD_PGA_CACHE_HIT_PERCENTAGE NUMBER
ESTD_OVERALLOC_COUNT
NUMBER
V$PGA_TARGET_ADVICE_HISTOGRAM: Synonym for
V_$PGA_TARGET_ADVICE_HISTOGRAM
iSelfSchooling-SQL> desc V$PGA_TARGET_ADVICE_HISTOGRAM;
Name
Null? Type
----------------------------- -------- --------------------
PGA_TARGET_FOR_ESTIMATE
NUMBER
PGA_TARGET_FACTOR
NUMBER
ADVICE_STATUS
VARCHAR2(3)
LOW_OPTIMAL_SIZE
NUMBER
HIGH_OPTIMAL_SIZE
NUMBER
ESTD_OPTIMAL_EXECUTIONS
NUMBER
ESTD_ONEPASS_EXECUTIONS
NUMBER
ESTD_MULTIPASSES_EXECUTIONS NUMBER
ESTD_TOTAL_EXECUTIONS
NUMBER
IGNORED_WORKAREAS_COUNT
NUMBER
V$PQ_SESSTAT: Synonym for V_$PQ_SESSTAT
iSelfSchooling-SQL> desc V$PQ_SESSTAT;
Name
Null? Type
----------------------------- -------- --------------------
STATISTIC
VARCHAR2(30)
LAST_QUERY
NUMBER
SESSION_TOTAL
NUMBER
V$PQ_SLAVE: Synonym for V_$PQ_SLAVE
iSelfSchooling-SQL> desc V$PQ_SLAVE;
Name
Null? Type
----------------------------- -------- --------------------
SLAVE_NAME
VARCHAR2(4)
STATUS
VARCHAR2(4)
SESSIONS
NUMBER
IDLE_TIME_CUR
NUMBER
BUSY_TIME_CUR
NUMBER
CPU_SECS_CUR
NUMBER
MSGS_SENT_CUR
NUMBER
MSGS_RCVD_CUR
NUMBER
IDLE_TIME_TOTAL
NUMBER
BUSY_TIME_TOTAL
NUMBER
CPU_SECS_TOTAL
NUMBER
MSGS_SENT_TOTAL
NUMBER
MSGS_RCVD_TOTAL
NUMBER
V$PQ_SYSSTAT: Synonym for V_$PQ_SYSSTAT
iSelfSchooling-SQL> desc V$PQ_SYSSTAT;
Name
Null? Type
----------------------------- -------- --------------------
STATISTIC
VARCHAR2(30)
VALUE
NUMBER
V$PQ_TQSTAT: Synonym for V_$PQ_TQSTAT
iSelfSchooling-SQL> desc V$PQ_TQSTAT;
Name
Null? Type
----------------------------- -------- --------------------
DFO_NUMBER
NUMBER
TQ_ID
NUMBER
SERVER_TYPE
VARCHAR2(10)
NUM_ROWS
NUMBER
BYTES
NUMBER
OPEN_TIME
NUMBER
AVG_LATENCY NUMBER
WAITS
NUMBER
TIMEOUTS
NUMBER
PROCESS
VARCHAR2(10)
INSTANCE
NUMBER
V$PROCESS: Synonym for V_$PROCESS
iSelfSchooling-SQL> desc V$PROCESS;
Name
Null? Type
----------------------------- -------- --------------------
ADDR
RAW(8)
PID
NUMBER
SPID
VARCHAR2(12)
USERNAME
VARCHAR2(15)
SERIAL#
NUMBER
TERMINAL
VARCHAR2(30)
PROGRAM
VARCHAR2(48)
TRACEID VARCHAR2(255)
BACKGROUND
VARCHAR2(1)
LATCHWAIT
VARCHAR2(16)
LATCHSPIN
VARCHAR2(16)
PGA_USED_MEM
NUMBER
PGA_ALLOC_MEM
NUMBER
PGA_FREEABLE_MEM
NUMBER
PGA_MAX_MEM
NUMBER
V$PROCESS_MEMORY: Synonym for V_$PROCESS_MEMORY
iSelfSchooling-SQL> desc V$PROCESS_MEMORY;
Name
Null?
Type
----------------------------- -------- --------------------
PID
NUMBER
SERIAL#
NUMBER
CATEGORY
VARCHAR2(15)
ALLOCATED
NUMBER
USED
NUMBER
MAX_ALLOCATED
NUMBER
V$PROCESS_MEMORY_DETAIL: Synonym for V_$PROCESS_MEMORY_DETAIL
iSelfSchooling-SQL> desc V$PROCESS_MEMORY_DETAIL;
Name
Null? Type
----------------------------- -------- --------------------
PID
NUMBER
SERIAL#
NUMBER
CATEGORY
VARCHAR2(15)
NAME
VARCHAR2(26)
HEAP_NAME
VARCHAR2(15)
BYTES
NUMBER
ALLOCATION_COUNT
NUMBER
HEAP_DESCRIPTOR
RAW(8)
PARENT_HEAP_DESCRIPTOR
RAW(8)
V$PROCESS_MEMORY_DETAIL_PROG: Synonym for
V_$PROCESS_MEMORY_DETAIL_PROG
iSelfSchooling-SQL> desc V$PROCESS_MEMORY_DETAIL_PROG;
Name
Null? Type
----------------------------- -------- --------------------
PID
NUMBER
SERIAL#
NUMBER
STATUS
VARCHAR2(10)
V$PROPAGATION_RECEIVER: Synonym for V_$PROPAGATION_RECEIVER
iSelfSchooling-SQL> desc V$PROPAGATION_RECEIVER;
Name
Null? Type
----------------------------- -------- --------------------
SRC_QUEUE_SCHEMA
VARCHAR2(30)
SRC_QUEUE_NAME
VARCHAR2(30)
SRC_DBNAME
VARCHAR2(128)
DST_QUEUE_SCHEMA
VARCHAR2(30)
DST_QUEUE_NAME
VARCHAR2(30)
STARTUP_TIME
DATE
HIGH_WATER_MARK
NUMBER
ACKNOWLEDGEMENT
NUMBER
TOTAL_MSGS
NUMBER
ELAPSED_UNPICKLE_TIME
NUMBER
ELAPSED_RULE_TIME
NUMBER
ELAPSED_ENQUEUE_TIME
NUMBER
V$PROPAGATION_SENDER: Synonym for V_$PROPAGATION_SENDER
iSelfSchooling-SQL> desc V$PROPAGATION_SENDER;
Name
Null? Type
----------------------------- -------- --------------------
QUEUE_ID
NUMBER
QUEUE_SCHEMA
VARCHAR2(30)
QUEUE_NAME
VARCHAR2(30)
DST_QUEUE_SCHEMA
VARCHAR2(30)
DST_QUEUE_NAME
VARCHAR2(30)
STARTUP_TIME
DATE
DBLINK
VARCHAR2(128)
HIGH_WATER_MARK
NUMBER
ACKNOWLEDGEMENT
NUMBER
SCHEDULE_STATUS
VARCHAR2(30)
TOTAL_MSGS
NUMBER
TOTAL_BYTES
NUMBER
ELAPSED_DEQUEUE_TIME
NUMBER
ELAPSED_PICKLE_TIME
NUMBER
ELAPSED_PROPAGATION_TIME
NUMBER
MAX_NUM_PER_WIN
NUMBER
MAX_SIZE
NUMBER
V$PROXY_ARCHIVEDLOG: Synonym for V_$PROXY_ARCHIVEDLOG
iSelfSchooling-SQL> desc V$PROXY_ARCHIVEDLOG;
Name
Null? Type
----------------------------- -------- --------------------
RECID
NUMBER
STAMP
NUMBER
DEVICE_TYPE
VARCHAR2(17)
HANDLE
VARCHAR2(513)
COMMENTS
VARCHAR2(81)
MEDIA
VARCHAR2(65)
MEDIA_POOL
NUMBER
TAG
VARCHAR2(32)
STATUS
VARCHAR2(1)
DELETED
VARCHAR2(3)
THREAD#
NUMBER
SEQUENCE#
NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME
DATE
FIRST_CHANGE#
NUMBER
FIRST_TIME
DATE
NEXT_CHANGE#
NUMBER
NEXT_TIME
DATE
BLOCKS
NUMBER
BLOCK_SIZE
NUMBER
START_TIME
DATE
COMPLETION_TIME
DATE
ELAPSED_SECONDS
NUMBER
RMAN_STATUS_RECID
NUMBER
RMAN_STATUS_STAMP
NUMBER
V$PROXY_ARCHIVELOG_DETAILS: Synonym for V_$PROXY_ARCHIVELOG_DETAILS
iSelfSchooling-SQL> desc V$PROXY_ARCHIVELOG_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_KEY
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
COPY_KEY
NUMBER
THREAD#
NUMBER
SEQUENCE#
NUMBER
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
HANDLE
VARCHAR2(513)
MEDIA
VARCHAR2(65)
MEDIA_POOL
NUMBER
TAG
VARCHAR2(32)
FIRST_CHANGE#
NUMBER
NEXT_CHANGE#
NUMBER
FIRST_TIME
DATE
NEXT_TIME
DATE
OUTPUT_BYTES
NUMBER
COMPLETION_TIME
DATE
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$PROXY_ARCHIVELOG_SUMMARY: Synonym for V_$PROXY_ARCHIVELOG_SUMMARY
iSelfSchooling-SQL> desc V$PROXY_ARCHIVELOG_SUMMARY;
Name
Null? Type
----------------------------- -------- --------------------
NUM_FILES_BACKED
NUMBER
NUM_DISTINCT_FILES_BACKED
NUMBER
MIN_FIRST_CHANGE#
NUMBER
MAX_NEXT_CHANGE#
NUMBER
MIN_FIRST_TIME
DATE
MAX_NEXT_TIME
DATE
OUTPUT_BYTES
NUMBER
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$PROXY_COPY_DETAILS: Synonym for V_$PROXY_COPY_DETAILS
iSelfSchooling-SQL> desc V$PROXY_COPY_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_KEY
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
COPY_KEY
NUMBER
FILE#
NUMBER
HANDLE
VARCHAR2(513)
MEDIA
VARCHAR2(65)
MEDIA_POOL
NUMBER
TAG
VARCHAR2(32)
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
OUTPUT_BYTES
NUMBER
COMPLETION_TIME
DATE
CONTROLFILE_TYPE
VARCHAR2(1)
KEEP
VARCHAR2(3)
KEEP_UNTIL
DATE
KEEP_OPTIONS
VARCHAR2(10)
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$PROXY_COPY_SUMMARY: Synonym for V_$PROXY_COPY_SUMMARY
iSelfSchooling-SQL> desc V$PROXY_COPY_SUMMARY;
Name
Null? Type
----------------------------- -------- --------------------
NUM_COPIES
NUMBER
NUM_DISTINCT_COPIES
NUMBER
MIN_CHECKPOINT_CHANGE#
NUMBER
MAX_CHECKPOINT_CHANGE#
NUMBER
MIN_CHECKPOINT_TIME
DATE
MAX_CHECKPOINT_TIME
DATE
OUTPUT_BYTES
NUMBER
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$PROXY_DATAFILE: Synonym for V_$PROXY_DATAFILE
iSelfSchooling-SQL> desc V$PROXY_DATAFILE;
Name
Null? Type
----------------------------- -------- --------------------
RECID
NUMBER
STAMP
NUMBER
DEVICE_TYPE
VARCHAR2(17)
HANDLE
VARCHAR2(513)
COMMENTS
VARCHAR2(81)
MEDIA
VARCHAR2(65)
MEDIA_POOL
NUMBER
TAG
VARCHAR2(32)
STATUS
VARCHAR2(1)
DELETED
VARCHAR2(3)
FILE#
NUMBER
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
ABSOLUTE_FUZZY_CHANGE#
NUMBER
RECOVERY_FUZZY_CHANGE#
NUMBER
RECOVERY_FUZZY_TIME
DATE
INCREMENTAL_LEVEL
NUMBER
ONLINE_FUZZY
VARCHAR2(3)
BACKUP_FUZZY
VARCHAR2(3)
BLOCKS
NUMBER
BLOCK_SIZE
NUMBER
OLDEST_OFFLINE_RANGE
NUMBER
START_TIME
DATE
COMPLETION_TIME
DATE
ELAPSED_SECONDS
NUMBER
CONTROLFILE_TYPE
VARCHAR2(1)
KEEP
VARCHAR2(3)
KEEP_UNTIL
DATE
KEEP_OPTIONS
VARCHAR2(10)
RMAN_STATUS_RECID
NUMBER
RMAN_STATUS_STAMP
NUMBER
V$PWFILE_USERS: Synonym for V_$PWFILE_USERS
iSelfSchooling-SQL> desc V$PWFILE_USERS;
Name
Null? Type
----------------------------- -------- --------------------
USERNAME
VARCHAR2(30)
SYSDBA
VARCHAR2(5)
SYSOPER
VARCHAR2(5)
V$PX_BUFFER_ADVICE: Synonym for V_$PX_BUFFER_ADVICE
iSelfSchooling-SQL> desc V$PX_BUFFER_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
STATISTIC
VARCHAR2(30)
VALUE
NUMBER
V$PX_PROCESS: Synonym for V_$PX_PROCESS
iSelfSchooling-SQL> desc V$PX_PROCESS;
Name
Null? Type
----------------------------- -------- --------------------
SERVER_NAME
VARCHAR2(4)
STATUS
VARCHAR2(9)
PID
NUMBER
SPID
VARCHAR2(12)
SID
NUMBER
SERIAL#
NUMBER
V$PX_PROCESS_SYSSTAT: Synonym for V_$PX_PROCESS_SYSSTAT
iSelfSchooling-SQL> desc V$PX_PROCESS_SYSSTAT;
Name
Null? Type
----------------------------- -------- --------------------
STATISTIC
VARCHAR2(30)
VALUE
NUMBER
V$PX_SESSION: Synonym for V_$PX_SESSION
iSelfSchooling-SQL> desc V$PX_SESSION;
Name
Null? Type
----------------------------- -------- --------------------
SADDR
RAW(8)
SID
NUMBER
SERIAL#
NUMBER
QCSID
NUMBER
QCSERIAL#
NUMBER
QCINST_ID
NUMBER
SERVER_GROUP
NUMBER
SERVER_SET
NUMBER
SERVER#
NUMBER
DEGREE
NUMBER
REQ_DEGREE
NUMBER
|