ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$BUFFERED_SUBSCRIBERS: Synonym for V_$BUFFERED_SUBSCRIBERS
iSelfSchooling-SQL> desc V$BUFFERED_SUBSCRIBERS;
Name
Null? Type
----------------------------- -------- --------------------
QUEUE_ID
NUMBER
QUEUE_SCHEMA
VARCHAR2(30)
QUEUE_NAME
VARCHAR2(30)
SUBSCRIBER_ID
NUMBER
SUBSCRIBER_NAME
VARCHAR2(30)
SUBSCRIBER_ADDRESS
VARCHAR2(1024)
PROTOCOL
NUMBER
SUBSCRIBER_TYPE
VARCHAR2(30)
STARTUP_TIME
DATE
LAST_BROWSED_SEQ
NUMBER
LAST_BROWSED_NUM
NUMBER
LAST_DEQUEUED_SEQ
NUMBER
LAST_DEQUEUED_NUM
NUMBER
CURRENT_ENQ_SEQ
NUMBER
NUM_MSGS
NUMBER
CNUM_MSGS
NUMBER
TOTAL_DEQUEUED_MSG
NUMBER
TOTAL_SPILLED_MSG
NUMBER
EXPIRED_MSGS
NUMBER
V$BUFFER_POOL: Synonym for V_$BUFFER_POOL
iSelfSchooling-SQL> desc V$BUFFER_POOL;
Name
Null? Type
----------------------------- -------- --------------------
ID
NUMBER
NAME
VARCHAR2(20)
BLOCK_SIZE
NUMBER
RESIZE_STATE
VARCHAR2(10)
CURRENT_SIZE
NUMBER
BUFFERS
NUMBER
TARGET_SIZE
NUMBER
TARGET_BUFFERS
NUMBER
PREV_SIZE
NUMBER
PREV_BUFFERS
NUMBER
LO_BNUM
NUMBER
HI_BNUM
NUMBER
LO_SETID
NUMBER
HI_SETID
NUMBER
SET_COUNT
NUMBER
V$BUFFER_POOL_STATISTICS: Synonym for V_$BUFFER_POOL_STATISTICS
iSelfSchooling-SQL> desc V$BUFFER_POOL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
ID
NUMBER
NAME
VARCHAR2(20)
BLOCK_SIZE
NUMBER
SET_MSIZE
NUMBER
CNUM_REPL
NUMBER
CNUM_WRITE
NUMBER
CNUM_SET
NUMBER
BUF_GOT
NUMBER
SUM_WRITE
NUMBER
SUM_SCAN
NUMBER
FREE_BUFFER_WAIT
NUMBER
WRITE_COMPLETE_WAIT
NUMBER
BUFFER_BUSY_WAIT
NUMBER
FREE_BUFFER_INSPECTED
NUMBER
DIRTY_BUFFERS_INSPECTED
NUMBER
DB_BLOCK_CHANGE
NUMBER
DB_BLOCK_GETS
NUMBER
CONSISTENT_GETS
NUMBER
PHYSICAL_READS
NUMBER
PHYSICAL_WRITES
NUMBER
V$CIRCUIT: Synonym for V_$CIRCUIT
iSelfSchooling-SQL> desc V$CIRCUIT;
Name
Null? Type
----------------------------- -------- --------------------
CIRCUIT
RAW(8)
DISPATCHER
RAW(8)
SERVER
RAW(8)
WAITER
RAW(8)
SADDR
RAW(8)
STATUS
VARCHAR2(16)
QUEUE
VARCHAR2(16)
MESSAGE0
NUMBER
MESSAGE1
NUMBER
MESSAGE2
NUMBER
MESSAGE3
NUMBER
MESSAGES
NUMBER
BYTES
NUMBER
BREAKS
NUMBER
PRESENTATION
VARCHAR2(257)
PCIRCUIT
RAW(8)
V$CLASS_CACHE_TRANSFER: Synonym for V_$CLASS_CACHE_TRANSFER
iSelfSchooling-SQL> desc V$CLASS_CACHE_TRANSFER;
Name
Null? Type
----------------------------- -------- --------------------
CLASS
CHAR(10)
X_2_NULL
NUMBER
X_2_NULL_FORCED_WRITE
NUMBER
X_2_NULL_FORCED_STALE
NUMBER
X_2_S
NUMBER
X_2_S_FORCED_WRITE
NUMBER
S_2_NULL
NUMBER
S_2_NULL_FORCED_STALE
NUMBER
NULL_2_X
NUMBER
S_2_X
NUMBER
NULL_2_S
NUMBER
CR_TRANSFER
NUMBER
CURRENT_TRANSFER
NUMBER
V$CLASS_PING: Synonym for V_$CLASS_PING
iSelfSchooling-SQL> desc V$CLASS_PING;
Name
Null? Type
----------------------------- -------- --------------------
CLASS
CHAR(10)
X_2_NULL
NUMBER
X_2_NULL_FORCED_WRITE
NUMBER
X_2_NULL_FORCED_STALE
NUMBER
X_2_S
NUMBER
X_2_S_FORCED_WRITE
NUMBER
X_2_SSX
NUMBER
X_2_SSX_FORCED_WRITE
NUMBER
S_2_NULL
NUMBER
S_2_NULL_FORCED_STALE
NUMBER
SS_2_NULL
NUMBER
SS_2_RLS
NUMBER
OP_2_SS
NUMBER
NULL_2_X
NUMBER
S_2_X
NUMBER
SSX_2_X
NUMBER
NULL_2_S
NUMBER
NULL_2_SS
NUMBER
V$CLIENT_STATS: Synonym for V_$CLIENT_STATS
iSelfSchooling-SQL> desc V$CLIENT_STATS;
Name
Null?
Type
----------------------------- -------- --------------------
CLIENT_IDENTIFIER
VARCHAR2(64)
STAT_ID
NUMBER
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
V$CLUSTER_INTERCONNECTS: Synonym for V_$CLUSTER_INTERCONNECTS
iSelfSchooling-SQL> desc V$CLUSTER_INTERCONNECTS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(15)
IP_ADDRESS
VARCHAR2(16)
IS_PUBLIC
VARCHAR2(3)
SOURCE
VARCHAR2(31)
V$CONFIGURED_INTERCONNECTS: Synonym for V_$CONFIGURED_INTERCONNECTS
iSelfSchooling-SQL> desc V$CONFIGURED_INTERCONNECTS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(15)
IP_ADDRESS
VARCHAR2(16)
IS_PUBLIC
VARCHAR2(3)
SOURCE
VARCHAR2(31)
V$CONTEXT: Synonym for V_$CONTEXT
iSelfSchooling-SQL> desc V$CONTEXT;
Name
Null? Type
----------------------------- -------- --------------------
NAMESPACE
VARCHAR2(31)
ATTRIBUTE
VARCHAR2(31)
VALUE
VARCHAR2(4000)
V$CONTROLFILE: Synonym for V_$CONTROLFILE
iSelfSchooling-SQL> desc V$CONTROLFILE;
Name
Null? Type
----------------------------- -------- --------------------
STATUS
VARCHAR2(7)
NAME
VARCHAR2(513)
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
BLOCK_SIZE
NUMBER
FILE_SIZE_BLKS
NUMBER
V$CONTROLFILE_RECORD_SECTION: Synonym for
V_$CONTROLFILE_RECORD_SECTION
iSelfSchooling-SQL> desc V$CONTROLFILE_RECORD_SECTION;
Name
Null? Type
----------------------------- -------- --------------------
TYPE
VARCHAR2(28)
RECORD_SIZE
NUMBER
RECORDS_TOTAL
NUMBER
RECORDS_USED
NUMBER
FIRST_INDEX
NUMBER
LAST_INDEX
NUMBER
LAST_RECID
NUMBER
V$COPY_CORRUPTION: Synonym for V_$COPY_CORRUPTION
iSelfSchooling-SQL> desc V$COPY_CORRUPTION;
Name
Null? Type
----------------------------- -------- --------------------
RECID
NUMBER
STAMP
NUMBER
COPY_RECID
NUMBER
COPY_STAMP
NUMBER
FILE#
NUMBER
BLOCK#
NUMBER
BLOCKS
NUMBER
CORRUPTION_CHANGE#
NUMBER
MARKED_CORRUPT
VARCHAR2(3)
CORRUPTION_TYPE
VARCHAR2(9)
V$CR_BLOCK_SERVER: Synonym for V_$CR_BLOCK_SERVER
iSelfSchooling-SQL> desc V$CR_BLOCK_SERVER;
Name
Null? Type
----------------------------- -------- --------------------
CR_REQUESTS
NUMBER
CURRENT_REQUESTS
NUMBER
DATA_REQUESTS
NUMBER
UNDO_REQUESTS
NUMBER
TX_REQUESTS
NUMBER
CURRENT_RESULTS
NUMBER
PRIVATE_RESULTS
NUMBER
ZERO_RESULTS
NUMBER
DISK_READ_RESULTS
NUMBER
FAIL_RESULTS
NUMBER
FAIRNESS_DOWN_CONVERTS
NUMBER
FAIRNESS_CLEARS
NUMBER
FREE_GC_ELEMENTS
NUMBER
FLUSHES
NUMBER
FLUSHES_QUEUED
NUMBER
FLUSH_QUEUE_FULL
NUMBER
FLUSH_MAX_TIME
NUMBER
LIGHT_WORKS
NUMBER
ERRORS
NUMBER
V$CURRENT_BLOCK_SERVER: Synonym for V_$CURRENT_BLOCK_SERVER
iSelfSchooling-SQL> desc V$CURRENT_BLOCK_SERVER;
Name
Null? Type
----------------------------- -------- --------------------
PIN1
NUMBER
PIN10
NUMBER
PIN100
NUMBER
PIN1000
NUMBER
PIN10000
NUMBER
FLUSH1
NUMBER
FLUSH10
NUMBER
FLUSH100
NUMBER
FLUSH1000
NUMBER
FLUSH10000
NUMBER
WRITE1
NUMBER
WRITE10
NUMBER
WRITE100
NUMBER
WRITE1000
NUMBER
WRITE10000
NUMBER
V$DATABASE: Synonym for V_$DATABASE
iSelfSchooling-SQL> desc V$DATABASE;
Name
Null? Type
----------------------------- -------- --------------------
DBID
NUMBER
NAME
VARCHAR2(9)
CREATED
DATE
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
PRIOR_RESETLOGS_CHANGE#
NUMBER
PRIOR_RESETLOGS_TIME
DATE
LOG_MODE
VARCHAR2(12)
CHECKPOINT_CHANGE#
NUMBER
ARCHIVE_CHANGE#
NUMBER
CONTROLFILE_TYPE
VARCHAR2(7)
CONTROLFILE_CREATED
DATE
CONTROLFILE_SEQUENCE#
NUMBER
CONTROLFILE_CHANGE#
NUMBER
CONTROLFILE_TIME
DATE
OPEN_RESETLOGS
VARCHAR2(11)
VERSION_TIME
DATE
OPEN_MODE
VARCHAR2(10)
PROTECTION_MODE
VARCHAR2(20)
PROTECTION_LEVEL
VARCHAR2(20)
REMOTE_ARCHIVE
VARCHAR2(8)
ACTIVATION#
NUMBER
SWITCHOVER#
NUMBER
DATABASE_ROLE
VARCHAR2(16)
ARCHIVELOG_CHANGE#
NUMBER
ARCHIVELOG_COMPRESSION
VARCHAR2(8)
SWITCHOVER_STATUS
VARCHAR2(20)
DATAGUARD_BROKER
VARCHAR2(8)
GUARD_STATUS
VARCHAR2(7)
SUPPLEMENTAL_LOG_DATA_MIN
VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_PK
VARCHAR2(3)
SUPPLEMENTAL_LOG_DATA_UI
VARCHAR2(3)
FORCE_LOGGING
VARCHAR2(3)
PLATFORM_ID
NUMBER
PLATFORM_NAME
VARCHAR2(101)
RECOVERY_TARGET_INCARNATION# NUMBER
LAST_OPEN_INCARNATION#
NUMBER
CURRENT_SCN
NUMBER
FLASHBACK_ON
VARCHAR2(18)
SUPPLEMENTAL_LOG_DATA_FK
VARCHAR2(3)
SUPPLEMENTAL_LOG_DATA_ALL
VARCHAR2(3)
DB_UNIQUE_NAME
VARCHAR2(30)
STANDBY_BECAME_PRIMARY_SCN NUMBER
FS_FAILOVER_STATUS
VARCHAR2(21)
FS_FAILOVER_CURRENT_TARGET VARCHAR2(30)
FS_FAILOVER_THRESHOLD
NUMBER
FS_FAILOVER_OBSERVER_PRESENT VARCHAR2(7)
FS_FAILOVER_OBSERVER_HOST
VARCHAR2(512)
V$DATABASE_BLOCK_CORRUPTION: Synonym for
V_$DATABASE_BLOCK_CORRUPTION
iSelfSchooling-SQL> desc V$DATABASE_BLOCK_CORRUPTION;
Name
Null? Type
----------------------------- -------- --------------------
FILE#
NUMBER
BLOCK#
NUMBER
BLOCKS
NUMBER
CORRUPTION_CHANGE#
NUMBER
CORRUPTION_TYPE
VARCHAR2(9)
V$DATABASE_INCARNATION: Synonym for V_$DATABASE_INCARNATION
iSelfSchooling-SQL> desc V$DATABASE_INCARNATION;
Name
Null? Type
----------------------------- -------- --------------------
INCARNATION#
NUMBER
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
PRIOR_RESETLOGS_CHANGE#
NUMBER
PRIOR_RESETLOGS_TIME
DATE
STATUS
VARCHAR2(7)
RESETLOGS_ID
NUMBER
PRIOR_INCARNATION#
NUMBER
FLASHBACK_DATABASE_ALLOWED VARCHAR2(26)
V$DATAFILE: Synonym for V_$DATAFILE
iSelfSchooling-SQL> desc V$DATAFILE;
Name
Null? Type
----------------------------- -------- --------------------
FILE#
NUMBER
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
TS#
NUMBER
RFILE#
NUMBER
STATUS
VARCHAR2(7)
ENABLED
VARCHAR2(10)
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
UNRECOVERABLE_CHANGE#
NUMBER
UNRECOVERABLE_TIME
DATE
LAST_CHANGE#
NUMBER
LAST_TIME
DATE
OFFLINE_CHANGE#
NUMBER
ONLINE_CHANGE#
NUMBER
ONLINE_TIME
DATE
BYTES
NUMBER
BLOCKS
NUMBER
CREATE_BYTES
NUMBER
BLOCK_SIZE
NUMBER
NAME
VARCHAR2(513)
PLUGGED_IN
NUMBER
BLOCK1_OFFSET
NUMBER
AUX_NAME
VARCHAR2(513)
FIRST_NONLOGGED_SCN
NUMBER
FIRST_NONLOGGED_TIME
DATE
V$DATAFILE_COPY: Synonym for V_$DATAFILE_COPY
iSelfSchooling-SQL> desc V$DATAFILE_COPY;
Name
Null? Type
----------------------------- -------- --------------------
RECID
NUMBER
STAMP
NUMBER
NAME
VARCHAR2(513)
TAG
VARCHAR2(32)
FILE#
NUMBER
RFILE#
NUMBER
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
INCREMENTAL_LEVEL
NUMBER
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
ABSOLUTE_FUZZY_CHANGE#
NUMBER
RECOVERY_FUZZY_CHANGE#
NUMBER
RECOVERY_FUZZY_TIME
DATE
ONLINE_FUZZY
VARCHAR2(3)
BACKUP_FUZZY
VARCHAR2(3)
MARKED_CORRUPT
NUMBER
MEDIA_CORRUPT
NUMBER
LOGICALLY_CORRUPT
NUMBER
BLOCKS
NUMBER
BLOCK_SIZE
NUMBER
OLDEST_OFFLINE_RANGE
NUMBER
DELETED
VARCHAR2(3)
STATUS
VARCHAR2(1)
COMPLETION_TIME
DATE
CONTROLFILE_TYPE
VARCHAR2(1)
KEEP
VARCHAR2(3)
KEEP_UNTIL
DATE
KEEP_OPTIONS
VARCHAR2(10)
SCANNED
VARCHAR2(3)
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
RMAN_STATUS_RECID
NUMBER
RMAN_STATUS_STAMP
NUMBER
V$DATAFILE_HEADER: Synonym for V_$DATAFILE_HEADER
iSelfSchooling-SQL> desc V$DATAFILE_HEADER;
Name
Null? Type
----------------------------- -------- --------------------
FILE#
NUMBER
STATUS
VARCHAR2(7)
ERROR
VARCHAR2(18)
FORMAT
NUMBER
RECOVER
VARCHAR2(3)
FUZZY
VARCHAR2(3)
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
TABLESPACE_NAME
VARCHAR2(30)
TS#
NUMBER
RFILE#
NUMBER
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
CHECKPOINT_COUNT
NUMBER
BYTES
NUMBER
BLOCKS
NUMBER
NAME
VARCHAR2(513)
SPACE_HEADER
VARCHAR2(40)
LAST_DEALLOC_SCN
VARCHAR2(16)
V$DATAGUARD_CONFIG: Synonym for V_$DATAGUARD_CONFIG
iSelfSchooling-SQL> desc V$DATAGUARD_CONFIG;
Name
Null? Type
----------------------------- -------- --------------------
DB_UNIQUE_NAME
VARCHAR2(30)
V$DATAGUARD_STATS: Synonym for V_$DATAGUARD_STATS
iSelfSchooling-SQL> desc V$DATAGUARD_STATS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(32)
VALUE
VARCHAR2(64)
UNIT
VARCHAR2(30)
TIME_COMPUTED
VARCHAR2(30)
V$DATAGUARD_STATUS: Synonym for V_$DATAGUARD_STATUS
iSelfSchooling-SQL> desc V$DATAGUARD_STATUS;
Name
Null? Type
----------------------------- -------- --------------------
FACILITY
VARCHAR2(24)
SEVERITY
VARCHAR2(13)
DEST_ID
NUMBER
MESSAGE_NUM
NUMBER
ERROR_CODE
NUMBER
CALLOUT
VARCHAR2(3)
TIMESTAMP
DATE
MESSAGE
VARCHAR2(256)
V$DATAPUMP_JOB: Synonym for V_$DATAPUMP_JOB
iSelfSchooling-SQL> desc V$DATAPUMP_JOB;
Name
Null? Type
----------------------------- -------- --------------------
JOB_ID
RAW(16)
JOB_NAME
VARCHAR2(30)
OWNER_NAME
VARCHAR2(30)
MSG_CTRL_QUEUE
VARCHAR2(30)
STATUS_QUEUE
VARCHAR2(30)
OPERATION
VARCHAR2(30)
JOB_MODE
VARCHAR2(30)
MASTER_ID
NUMBER
STATE
VARCHAR2(30)
WORKERS
NUMBER
FLAGS
NUMBER
V$DATAPUMP_SESSION: Synonym for V_$DATAPUMP_SESSION
iSelfSchooling-SQL> desc V$DATAPUMP_SESSION;
Name
Null? Type
----------------------------- -------- --------------------
ATTACH_ID
NUMBER
JOB_ID
RAW(16)
SADDR
RAW(8)
TYPE
VARCHAR2(14)
V$DBFILE: Synonym for V_$DBFILE
iSelfSchooling-SQL> desc V$DBFILE;
Name
Null? Type
----------------------------- -------- --------------------
FILE#
NUMBER
NAME
VARCHAR2(513)
V$DBLINK: Synonym for V_$DBLINK
iSelfSchooling-SQL> desc V$DBLINK;
Name
Null? Type
----------------------------- -------- --------------------
DB_LINK
VARCHAR2(128)
OWNER_ID
NUMBER
LOGGED_ON
VARCHAR2(3)
HETEROGENEOUS
VARCHAR2(3)
PROTOCOL
VARCHAR2(6)
OPEN_CURSORS
NUMBER
IN_TRANSACTION
VARCHAR2(3)
UPDATE_SENT
VARCHAR2(3)
COMMIT_POINT_STRENGTH
NUMBER
V$DB_CACHE_ADVICE: Synonym for V_$DB_CACHE_ADVICE
iSelfSchooling-SQL> desc V$DB_CACHE_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
ID
NUMBER
NAME
VARCHAR2(20)
BLOCK_SIZE
NUMBER
ADVICE_STATUS
VARCHAR2(3)
SIZE_FOR_ESTIMATE
NUMBER
SIZE_FACTOR
NUMBER
BUFFERS_FOR_ESTIMATE
NUMBER
ESTD_PHYSICAL_READ_FACTOR
NUMBER
ESTD_PHYSICAL_READS
NUMBER
ESTD_PHYSICAL_READ_TIME
NUMBER
ESTD_PCT_OF_DB_TIME_FOR_READS NUMBER
ESTD_CLUSTER_READS
NUMBER
ESTD_CLUSTER_READ_TIME
NUMBER
V$DB_OBJECT_CACHE: Synonym for V_$DB_OBJECT_CACHE
iSelfSchooling-SQL> desc V$DB_OBJECT_CACHE;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(64)
NAME
VARCHAR2(1000)
DB_LINK
VARCHAR2(64)
NAMESPACE
VARCHAR2(28)
TYPE
VARCHAR2(28)
SHARABLE_MEM
NUMBER
LOADS
NUMBER
EXECUTIONS
NUMBER
LOCKS
NUMBER
PINS
NUMBER
KEPT
VARCHAR2(3)
CHILD_LATCH
NUMBER
INVALIDATIONS
NUMBER
V$DB_PIPES: Synonym for V_$DB_PIPES
iSelfSchooling-SQL> desc V$DB_PIPES;
Name
Null? Type
----------------------------- -------- --------------------
OWNERID
NUMBER
NAME
VARCHAR2(1000)
TYPE
VARCHAR2(7)
PIPE_SIZE
NUMBER
V$DB_TRANSPORTABLE_PLATFORM: Synonym for
V_$DB_TRANSPORTABLE_PLATFORM
iSelfSchooling-SQL> desc V$DB_TRANSPORTABLE_PLATFORM;
Name
Null?
Type
----------------------------- -------- --------------------
PLATFORM_ID
NUMBER
PLATFORM_NAME
VARCHAR2(101)
ENDIAN_FORMAT
VARCHAR2(14)
|