iSelfSchooling.com Since 1999 References | Search more | Oracle Syntax | Free Online Oracle Training

Home .Services Login Start Learning Certification . .Share your BELIEF(s)...

. Online Accounting     .Copyright & User Agreement   |

    .Vision      .Biography     .Acknowledgement
.Contact Us      .Comments/Suggestions       Email2aFriend    |

Complete Syntax | Oracle Functions | PL/SQL Syntax | SQL Syntax | Tables

Oracle Dictionary Tables

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)