ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$PGASTAT: Synonym for GV_$PGASTAT
iSelfSchooling-SQL> desc GV$PGASTAT;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(64)
VALUE
NUMBER
UNIT
VARCHAR2(12)
GV$PGA_TARGET_ADVICE: Synonym for GV_$PGA_TARGET_ADVICE
iSelfSchooling-SQL> desc GV$PGA_TARGET_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PGA_TARGET_ADVICE_HISTOGRAM:
Synonym
for GV_$PGATARGET_ADVICE_HISTOGRAM
iSelfSchooling-SQL> desc GV$PGA_TARGET_ADVICE_HISTOGRAM;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PQ_SESSTAT: Synonym for GV_$PQ_SESSTAT
iSelfSchooling-SQL> desc GV$PQ_SESSTAT;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
STATISTIC
VARCHAR2(30)
LAST_QUERY
NUMBER
SESSION_TOTAL
NUMBER
GV$PQ_SLAVE: Synonym for GV_$PQ_SLAVE
iSelfSchooling-SQL> desc GV$PQ_SLAVE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PQ_SYSSTAT: Synonym for GV_$PQ_SYSSTAT
iSelfSchooling-SQL> desc GV$PQ_SYSSTAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STATISTIC
VARCHAR2(30)
VALUE
NUMBER
GV$PQ_TQSTAT: Synonym for GV_$PQ_TQSTAT
iSelfSchooling-SQL> desc GV$PQ_TQSTAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PROCESS: Synonym for GV_$PROCESS
iSelfSchooling-SQL> desc GV$PROCESS;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
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
GV$PROCESS_MEMORY: Synonym for GV_$PROCESS_MEMORY
iSelfSchooling-SQL> desc GV$PROCESS_MEMORY;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
PID
NUMBER
SERIAL#
NUMBER
CATEGORY
VARCHAR2(15)
ALLOCATED
NUMBER
USED
NUMBER
MAX_ALLOCATED
NUMBER
GV$PROCESS_MEMORY_DETAIL: Synonym for GV_$PROCESS_MEMORY_DETAIL
iSelfSchooling-SQL> desc GV$PROCESS_MEMORY_DETAIL;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$PROCESS_MEMORY_DETAIL_PROG:
Synonym
for GV_$PROCESS_MEMORY_DETAIL_PROG
iSelfSchooling-SQL> desc GV$PROCESS_MEMORY_DETAIL_PROG;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
PID
NUMBER
SERIAL#
NUMBER
STATUS
VARCHAR2(10)
GV$PROPAGATION_RECEIVER: Synonym for GV_$PROPAGATION_RECEIVER
iSelfSchooling-SQL> desc GV$PROPAGATION_RECEIVER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PROPAGATION_SENDER: Synonym for GV_$PROPAGATION_SENDER
iSelfSchooling-SQL> desc GV$PROPAGATION_SENDER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PROXY_ARCHIVEDLOG: Synonym for GV_$PROXY_ARCHIVEDLOG
iSelfSchooling-SQL> desc GV$PROXY_ARCHIVEDLOG;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PROXY_DATAFILE: Synonym for GV_$PROXY_DATAFILE
iSelfSchooling-SQL> desc GV$PROXY_DATAFILE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PWFILE_USERS: Synonym for GV_$PWFILE_USERS
iSelfSchooling-SQL> desc GV$PWFILE_USERS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
USERNAME
VARCHAR2(30)
SYSDBA
VARCHAR2(5)
SYSOPER
VARCHAR2(5)
GV$PX_BUFFER_ADVICE: Synonym for GV_$PX_BUFFER_ADVICE
iSelfSchooling-SQL> desc GV$PX_BUFFER_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STATISTIC
VARCHAR2(30)
VALUE
NUMBER
GV$PX_PROCESS: Synonym for GV_$PX_PROCESS
iSelfSchooling-SQL> desc GV$PX_PROCESS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SERVER_NAME
VARCHAR2(4)
STATUS
VARCHAR2(9)
PID
NUMBER
SPID
VARCHAR2(12)
SID
NUMBER
SERIAL#
NUMBER
GV$PX_PROCESS_SYSSTAT: Synonym for GV_$PX_PROCESS_SYSSTAT
iSelfSchooling-SQL> desc GV$PX_PROCESS_SYSSTAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STATISTIC
VARCHAR2(30)
VALUE
NUMBER
GV$PX_SESSION: Synonym for GV_$PX_SESSION
iSelfSchooling-SQL> desc GV$PX_SESSION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$PX_SESSTAT: Synonym for GV_$PX_SESSTAT
iSelfSchooling-SQL> desc GV$PX_SESSTAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
STATISTIC#
NUMBER
VALUE
NUMBER
GV$QUEUE: Synonym for GV_$QUEUE
iSelfSchooling-SQL> desc GV$QUEUE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
PADDR
RAW(8)
TYPE
VARCHAR2(10)
QUEUED
NUMBER
WAIT
NUMBER
TOTALQ
NUMBER
GV$QUEUEING_MTH: Synonym for GV_$QUEUEING_MTH
iSelfSchooling-SQL> desc GV$QUEUEING_MTH;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(40)
GV$RECOVERY_FILE_STATUS: Synonym for GV_$RECOVERY_FILE_STATUS
iSelfSchooling-SQL> desc GV$RECOVERY_FILE_STATUS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
FILENUM
NUMBER
FILENAME
VARCHAR2(513)
STATUS
VARCHAR2(13)
GV$RECOVERY_LOG: Synonym for GV_$RECOVERY_LOG
iSelfSchooling-SQL> desc GV$RECOVERY_LOG;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
THREAD#
NUMBER
SEQUENCE#
NUMBER
TIME
DATE
ARCHIVE_NAME
VARCHAR2(513)
GV$RECOVERY_PROGRESS: Synonym for GV_$RECOVERY_PROGRESS
iSelfSchooling-SQL> desc GV$RECOVERY_PROGRESS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
START_TIME
DATE
TYPE
VARCHAR2(64)
ITEM
VARCHAR2(32)
UNITS
VARCHAR2(32)
SOFAR
NUMBER
TOTAL
NUMBER
TIMESTAMP
DATE
GV$RECOVERY_STATUS: Synonym for GV_$RECOVERY_STATUS
iSelfSchooling-SQL> desc GV$RECOVERY_STATUS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
RECOVERY_CHECKPOINT
DATE
THREAD
NUMBER
SEQUENCE_NEEDED
NUMBER
SCN_NEEDED
VARCHAR2(16)
TIME_NEEDED
DATE
PREVIOUS_LOG_NAME
VARCHAR2(513)
PREVIOUS_LOG_STATUS
VARCHAR2(13)
REASON
VARCHAR2(13)
GV$RECOVER_FILE: Synonym for GV_$RECOVER_FILE
iSelfSchooling-SQL> desc GV$RECOVER_FILE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
FILE#
NUMBER
ONLINE
VARCHAR2(7)
ONLINE_STATUS
VARCHAR2(7)
ERROR
VARCHAR2(18)
CHANGE#
NUMBER
TIME
DATE
GV$REPLPROP: Synonym for GV_$REPLPROP
iSelfSchooling-SQL> desc GV$REPLPROP;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
SERIAL#
NUMBER
NAME
VARCHAR2(71)
DBLINK
VARCHAR2(128)
STATE
VARCHAR2(12)
XID
VARCHAR2(22)
SEQUENCE
NUMBER
GV$REPLQUEUE: Synonym for GV_$REPLQUEUE
iSelfSchooling-SQL> desc GV$REPLQUEUE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
TXNS_ENQUEUED
NUMBER
CALLS_ENQUEUED
NUMBER
TXNS_PURGED
NUMBER
LAST_ENQUEUE_TIME
DATE
LAST_PURGE_TIME
DATE
GV$REQDIST: Synonym for GV_$REQDIST
iSelfSchooling-SQL> desc GV$REQDIST;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
BUCKET
NUMBER
COUNT
NUMBER
GV$RESERVED_WORDS: Synonym for GV_$RESERVED_WORDS
iSelfSchooling-SQL> desc GV$RESERVED_WORDS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
KEYWORD
VARCHAR2(30)
LENGTH
NUMBER
RESERVED
VARCHAR2(1)
RES_TYPE
VARCHAR2(1)
RES_ATTR
VARCHAR2(1)
RES_SEMI
VARCHAR2(1)
DUPLICATE
VARCHAR2(1)
GV$RESOURCE: Synonym for GV_$RESOURCE
iSelfSchooling-SQL> desc GV$RESOURCE;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDR
RAW(8)
TYPE
VARCHAR2(2)
ID1
NUMBER
ID2
NUMBER
GV$RESOURCE_LIMIT: Synonym for GV_$RESOURCE_LIMIT
iSelfSchooling-SQL> desc GV$RESOURCE_LIMIT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
RESOURCE_NAME
VARCHAR2(30)
CURRENT_UTILIZATION
NUMBER
MAX_UTILIZATION
NUMBER
INITIAL_ALLOCATION
VARCHAR2(10)
LIMIT_VALUE
VARCHAR2(10)
GV$RESTORE_POINT: Synonym for GV_$RESTORE_POINT
iSelfSchooling-SQL> desc GV$RESTORE_POINT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SCN
NUMBER
DATABASE_INCARNATION#
NUMBER
GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3)
STORAGE_SIZE
NUMBER
TIME
TIMESTAMP(9)
NAME
VARCHAR2(128)
GV$RESUMABLE: Synonym for GV_$RESUMABLE
iSelfSchooling-SQL> desc GV$RESUMABLE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDR
RAW(8)
SID
NUMBER
ENABLED
VARCHAR2(3)
STATUS
VARCHAR2(9)
TIMEOUT
NUMBER
SUSPEND_TIME
VARCHAR2(20)
RESUME_TIME
VARCHAR2(20)
NAME
VARCHAR2(4000)
ERROR_NUMBER
NUMBER
ERROR_PARAMETER1
VARCHAR2(80)
ERROR_PARAMETER2
VARCHAR2(80)
ERROR_PARAMETER3
VARCHAR2(80)
ERROR_PARAMETER4
VARCHAR2(80)
ERROR_PARAMETER5
VARCHAR2(80)
ERROR_MSG
VARCHAR2(4000)
GV$RFS_THREAD: Synonym for GV_$RFS_THREAD
iSelfSchooling-SQL> desc GV$RFS_THREAD;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
THREAD#
NUMBER
RESETLOGS_CHANGE#
NUMBER
RESET_TIMESTAMP
NUMBER
LAST_REDO_SEQ#
NUMBER
LAST_REDO_BLK#
NUMBER
LAST_REDO_TIME
DATE
LOW_GAP_SCN
NUMBER
LOW_GAP_TIME
DATE
LAST_PING_TIME
DATE
GV$RMAN_CONFIGURATION: Synonym for GV_$RMAN_CONFIGURATION
iSelfSchooling-SQL> desc GV$RMAN_CONFIGURATION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CONF#
NUMBER
NAME
VARCHAR2(65)
VALUE
VARCHAR2(1025)
GV$RMAN_OUTPUT: Synonym for GV_$RMAN_OUTPUT
iSelfSchooling-SQL> desc GV$RMAN_OUTPUT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
RECID
NUMBER
STAMP
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
OUTPUT
VARCHAR2(130)
RMAN_STATUS_RECID
NUMBER
RMAN_STATUS_STAMP
NUMBER
GV$ROLLSTAT: Synonym for GV_$ROLLSTAT
iSelfSchooling-SQL> desc GV$ROLLSTAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
USN
NUMBER
LATCH
NUMBER
EXTENTS
NUMBER
RSSIZE
NUMBER
WRITES
NUMBER
XACTS
NUMBER
GETS
NUMBER
WAITS
NUMBER
OPTSIZE
NUMBER
HWMSIZE
NUMBER
SHRINKS
NUMBER
WRAPS
NUMBER
EXTENDS
NUMBER
AVESHRINK
NUMBER
AVEACTIVE
NUMBER
STATUS
VARCHAR2(15)
CUREXT
NUMBER
CURBLK
NUMBER
|