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$DELETED_OBJECT: Synonym for V_$DELETED_OBJECT

iSelfSchooling-SQL> desc V$DELETED_OBJECT;

Name Null? Type

----------------------------- -------- --------------------

RECID NUMBER

STAMP NUMBER

TYPE VARCHAR2(26)

OBJECT_RECID NUMBER

OBJECT_STAMP NUMBER

OBJECT_DATA NUMBER

V$DISPATCHER: Synonym for V_$DISPATCHER

iSelfSchooling-SQL> desc V$DISPATCHER;

Name Null? Type

----------------------------- -------- --------------------

NAME VARCHAR2(4)

NETWORK VARCHAR2(128)

PADDR RAW(8)

STATUS VARCHAR2(16)

ACCEPT VARCHAR2(3)

MESSAGES NUMBER

BYTES NUMBER

BREAKS NUMBER

OWNED NUMBER

CREATED NUMBER

IDLE NUMBER

BUSY NUMBER

LISTENER NUMBER

CONF_INDX NUMBER

V$DISPATCHER_CONFIG: Synonym for V_$DISPATCHER_CONFIG

iSelfSchooling-SQL> desc V$DISPATCHER_CONFIG;

Name Null? Type

----------------------------- -------- --------------------

CONF_INDX NUMBER

NETWORK VARCHAR2(128)

DISPATCHERS NUMBER

CONNECTIONS NUMBER

SESSIONS NUMBER

POOL VARCHAR2(4)

TICKS NUMBER

INBD_TIMOUT NUMBER

OUTBD_TIMOUT NUMBER

MULTIPLEX VARCHAR2(4)

LISTENER VARCHAR2(1200)

SERVICE VARCHAR2(512)

V$DISPATCHER_RATE: Synonym for V_$DISPATCHER_RATE

iSelfSchooling-SQL> desc V$DISPATCHER_RATE;

Name Null? Type

----------------------------- -------- --------------------

NAME VARCHAR2(4)

PADDR RAW(8)

CUR_LOOP_RATE NUMBER

CUR_EVENT_RATE NUMBER

CUR_EVENTS_PER_LOOP NUMBER

CUR_MSG_RATE NUMBER

CUR_SVR_BUF_RATE NUMBER

CUR_SVR_BYTE_RATE NUMBER

CUR_SVR_BYTE_PER_BUF NUMBER

CUR_CLT_BUF_RATE NUMBER

CUR_CLT_BYTE_RATE NUMBER

CUR_CLT_BYTE_PER_BUF NUMBER

CUR_BUF_RATE NUMBER

CUR_BYTE_RATE NUMBER

CUR_BYTE_PER_BUF NUMBER

CUR_IN_CONNECT_RATE NUMBER

CUR_OUT_CONNECT_RATE NUMBER

CUR_RECONNECT_RATE NUMBER

MAX_LOOP_RATE NUMBER

MAX_EVENT_RATE NUMBER

MAX_EVENTS_PER_LOOP NUMBER

MAX_MSG_RATE NUMBER

MAX_SVR_BUF_RATE NUMBER

MAX_SVR_BYTE_RATE NUMBER

MAX_SVR_BYTE_PER_BUF NUMBER

MAX_CLT_BUF_RATE NUMBER

MAX_CLT_BYTE_RATE NUMBER

MAX_CLT_BYTE_PER_BUF NUMBER

MAX_BUF_RATE NUMBER

MAX_BYTE_RATE NUMBER

MAX_BYTE_PER_BUF NUMBER

MAX_IN_CONNECT_RATE NUMBER

MAX_OUT_CONNECT_RATE NUMBER

MAX_RECONNECT_RATE NUMBER

AVG_LOOP_RATE NUMBER

AVG_EVENT_RATE NUMBER

AVG_EVENTS_PER_LOOP NUMBER

AVG_MSG_RATE NUMBER

AVG_SVR_BUF_RATE NUMBER

AVG_SVR_BYTE_RATE NUMBER

AVG_SVR_BYTE_PER_BUF NUMBER

AVG_CLT_BUF_RATE NUMBER

AVG_CLT_BYTE_RATE NUMBER

AVG_CLT_BYTE_PER_BUF NUMBER

AVG_BUF_RATE NUMBER

AVG_BYTE_RATE NUMBER

AVG_BYTE_PER_BUF NUMBER

AVG_IN_CONNECT_RATE NUMBER

AVG_OUT_CONNECT_RATE NUMBER

AVG_RECONNECT_RATE NUMBER

TTL_LOOPS NUMBER

TTL_MSG NUMBER

TTL_SVR_BUF NUMBER

TTL_CLT_BUF NUMBER

TTL_BUF NUMBER

TTL_IN_CONNECT NUMBER

TTL_OUT_CONNECT NUMBER

TTL_RECONNECT NUMBER

SCALE_LOOPS NUMBER

SCALE_MSG NUMBER

SCALE_SVR_BUF NUMBER

SCALE_CLT_BUF NUMBER

SCALE_BUF NUMBER

SCALE_IN_CONNECT NUMBER

SCALE_OUT_CONNECT NUMBER

SCALE_RECONNECT NUMBER

V$DLM_ALL_LOCKS: Synonym for V_$DLM_ALL_LOCKS

iSelfSchooling-SQL> desc V$DLM_ALL_LOCKS;

Name Null? Type

----------------------------- -------- --------------------

LOCKP RAW(8)

GRANT_LEVEL VARCHAR2(9)

REQUEST_LEVEL VARCHAR2(9)

RESOURCE_NAME1 VARCHAR2(30)

RESOURCE_NAME2 VARCHAR2(30)

PID NUMBER

TRANSACTION_ID0 NUMBER

TRANSACTION_ID1 NUMBER

GROUP_ID NUMBER

OPEN_OPT_DEADLOCK NUMBER

OPEN_OPT_PERSISTENT NUMBER

OPEN_OPT_PROCESS_OWNED NUMBER

OPEN_OPT_NO_XID NUMBER

CONVERT_OPT_GETVALUE NUMBER

CONVERT_OPT_PUTVALUE NUMBER

CONVERT_OPT_NOVALUE NUMBER

CONVERT_OPT_DUBVALUE NUMBER

CONVERT_OPT_NOQUEUE NUMBER

CONVERT_OPT_EXPRESS NUMBER

CONVERT_OPT_NODEADLOCKWAIT NUMBER

CONVERT_OPT_NODEADLOCKBLOCK NUMBER

WHICH_QUEUE NUMBER

LOCKSTATE VARCHAR2(64)

AST_EVENT0 NUMBER

OWNER_NODE NUMBER

BLOCKED NUMBER

BLOCKER NUMBER

V$DLM_CONVERT_LOCAL: Synonym for V_$DLM_CONVERT_LOCAL

iSelfSchooling-SQL> desc V$DLM_CONVERT_LOCAL;

Name Null? Type

----------------------------- -------- --------------------

INST_ID NUMBER

CONVERT_TYPE VARCHAR2(16)

AVERAGE_CONVERT_TIME NUMBER

CONVERT_COUNT NUMBER

V$DLM_CONVERT_REMOTE: Synonym for V_$DLM_CONVERT_REMOTE

iSelfSchooling-SQL> desc V$DLM_CONVERT_REMOTE;

Name Null? Type

----------------------------- -------- --------------------

INST_ID NUMBER

CONVERT_TYPE VARCHAR2(16)

AVERAGE_CONVERT_TIME NUMBER

CONVERT_COUNT NUMBER

V$DLM_LATCH: Synonym for V_$DLM_LATCH

iSelfSchooling-SQL> desc V$DLM_LATCH;

Name Null? Type

----------------------------- -------- --------------------

ADDR RAW(8)

LATCH# NUMBER

LEVEL# NUMBER

NAME VARCHAR2(50)

GETS NUMBER

MISSES NUMBER

SLEEPS NUMBER

IMMEDIATE_GETS NUMBER

IMMEDIATE_MISSES NUMBER

WAITERS_WOKEN NUMBER

WAITS_HOLDING_LATCH NUMBER

SPIN_GETS NUMBER

SLEEP1 NUMBER

SLEEP2 NUMBER

SLEEP3 NUMBER

SLEEP4 NUMBER

SLEEP5 NUMBER

SLEEP6 NUMBER

SLEEP7 NUMBER

SLEEP8 NUMBER

SLEEP9 NUMBER

SLEEP10 NUMBER

SLEEP11 NUMBER

WAIT_TIME NUMBER

V$DLM_LOCKS: Synonym for V_$DLM_LOCKS

iSelfSchooling-SQL> desc V$DLM_LOCKS;

Name Null? Type

----------------------------- -------- --------------------

LOCKP RAW(8)

GRANT_LEVEL VARCHAR2(9)

REQUEST_LEVEL VARCHAR2(9)

RESOURCE_NAME1 VARCHAR2(30)

RESOURCE_NAME2 VARCHAR2(30)

PID NUMBER

TRANSACTION_ID0 NUMBER

TRANSACTION_ID1 NUMBER

GROUP_ID NUMBER

OPEN_OPT_DEADLOCK NUMBER

OPEN_OPT_PERSISTENT NUMBER

OPEN_OPT_PROCESS_OWNED NUMBER

OPEN_OPT_NO_XID NUMBER

CONVERT_OPT_GETVALUE NUMBER

CONVERT_OPT_PUTVALUE NUMBER

CONVERT_OPT_NOVALUE NUMBER

CONVERT_OPT_DUBVALUE NUMBER

CONVERT_OPT_NOQUEUE NUMBER

CONVERT_OPT_EXPRESS NUMBER

CONVERT_OPT_NODEADLOCKWAIT NUMBER

CONVERT_OPT_NODEADLOCKBLOCK NUMBER

WHICH_QUEUE NUMBER

LOCKSTATE VARCHAR2(64)

AST_EVENT0 NUMBER

OWNER_NODE NUMBER

BLOCKED NUMBER

BLOCKER NUMBER

V$DLM_MISC: Synonym for V_$DLM_MISC

iSelfSchooling-SQL> desc V$DLM_MISC;

Name Null? Type

----------------------------- -------- --------------------

STATISTIC# NUMBER

NAME VARCHAR2(38)

VALUE NUMBER

V$DLM_RESS: Synonym for V_$DLM_RESS

iSelfSchooling-SQL> desc V$DLM_RESS;

Name Null? Type

----------------------------- -------- --------------------

RESP RAW(8)

RESOURCE_NAME VARCHAR2(30)

ON_CONVERT_Q NUMBER

ON_GRANT_Q NUMBER

PERSISTENT_RES NUMBER

MASTER_NODE NUMBER

NEXT_CVT_LEVEL VARCHAR2(9)

VALUE_BLK_STATE VARCHAR2(32)

VALUE_BLK VARCHAR2(64)

V$DLM_TRAFFIC_CONTROLLER: Synonym for V_$DLM_TRAFFIC_CONTROLLER

iSelfSchooling-SQL> desc V$DLM_TRAFFIC_CONTROLLER;

Name Null? Type

----------------------------- -------- --------------------

LOCAL_NID NUMBER

REMOTE_NID NUMBER

REMOTE_RID NUMBER

REMOTE_INC NUMBER

TCKT_AVAIL NUMBER

TCKT_LIMIT NUMBER

TCKT_RCVD NUMBER

TCKT_WAIT VARCHAR2(10)

SND_SEQ_NO NUMBER

RCV_SEQ_NO NUMBER

SND_Q_LEN NUMBER

SND_Q_MAX NUMBER

SND_Q_TOT NUMBER

SND_Q_TM_BASE NUMBER

SND_Q_TM_WRAP NUMBER

STATUS NUMBER

SND_PROXY NUMBER

V$ENABLEDPRIVS: Synonym for V_$ENABLEDPRIVS

iSelfSchooling-SQL> desc V$ENABLEDPRIVS;

Name Null? Type

----------------------------- -------- --------------------

PRIV_NUMBER NUMBER

V$ENQUEUE_LOCK: Synonym for V_$ENQUEUE_LOCK

iSelfSchooling-SQL> desc V$ENQUEUE_LOCK;

Name Null? Type

----------------------------- -------- --------------------

ADDR RAW(8)

KADDR RAW(8)

SID NUMBER

TYPE VARCHAR2(2)

ID1 NUMBER

ID2 NUMBER

LMODE NUMBER

REQUEST NUMBER

CTIME NUMBER

BLOCK NUMBER

V$ENQUEUE_STAT: Synonym for V_$ENQUEUE_STAT

iSelfSchooling-SQL> desc V$ENQUEUE_STAT;

Name Null? Type

----------------------------- -------- --------------------

INST_ID NUMBER

EQ_TYPE VARCHAR2(2)

TOTAL_REQ# NUMBER

TOTAL_WAIT# NUMBER

SUCC_REQ# NUMBER

FAILED_REQ# NUMBER

CUM_WAIT_TIME NUMBER

V$ENQUEUE_STATISTICS: Synonym for V_$ENQUEUE_STATISTICS

iSelfSchooling-SQL> desc V$ENQUEUE_STATISTICS;

Name Null? Type

----------------------------- -------- --------------------

EQ_NAME VARCHAR2(64)

EQ_TYPE VARCHAR2(2)

REQ_REASON VARCHAR2(64)

TOTAL_REQ# NUMBER

TOTAL_WAIT# NUMBER

SUCC_REQ# NUMBER

FAILED_REQ# NUMBER

CUM_WAIT_TIME NUMBER

REQ_DESCRIPTION VARCHAR2(4000)

EVENT# NUMBER

V$EVENTMETRIC: Synonym for V_$EVENTMETRIC

iSelfSchooling-SQL> desc V$EVENTMETRIC;

Name Null? Type

----------------------------- -------- --------------------

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

EVENT# NUMBER

EVENT_ID NUMBER

NUM_SESS_WAITING NUMBER

TIME_WAITED NUMBER

WAIT_COUNT NUMBER

V$EVENT_HISTOGRAM: Synonym for V_$EVENT_HISTOGRAM

iSelfSchooling-SQL> desc V$EVENT_HISTOGRAM;

Name Null? Type

----------------------------- -------- --------------------

EVENT# NUMBER

EVENT VARCHAR2(64)

WAIT_TIME_MILLI NUMBER

WAIT_COUNT NUMBER

V$EVENT_NAME: Synonym for V_$EVENT_NAME

iSelfSchooling-SQL> desc V$EVENT_NAME;

Name Null? Type

----------------------------- -------- --------------------

EVENT# NUMBER

EVENT_ID NUMBER

NAME VARCHAR2(64)

PARAMETER1 VARCHAR2(64)

PARAMETER2 VARCHAR2(64)

PARAMETER3 VARCHAR2(64)

WAIT_CLASS_ID NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS VARCHAR2(64)

V$EXECUTION: Synonym for V_$EXECUTION

iSelfSchooling-SQL> desc V$EXECUTION;

Name Null? Type

----------------------------- -------- --------------------

PID NUMBER

DEPTH NUMBER

FUNCTION VARCHAR2(10)

TYPE VARCHAR2(7)

NVALS NUMBER

VAL1 NUMBER

VAL2 NUMBER

SEQH NUMBER

SEQL NUMBER

V$FAST_START_SERVERS: Synonym for V_$FAST_START_SERVERS

iSelfSchooling-SQL> desc V$FAST_START_SERVERS;

Name Null? Type

----------------------------- -------- --------------------

STATE VARCHAR2(11)

UNDOBLOCKSDONE NUMBER

PID NUMBER

XID RAW(8)

V$FAST_START_TRANSACTIONS: Synonym for V_$FAST_START_TRANSACTIONS

iSelfSchooling-SQL> desc V$FAST_START_TRANSACTIONS;

Name Null? Type

----------------------------- -------- --------------------

USN NUMBER

SLT NUMBER

SEQ NUMBER

STATE VARCHAR2(16)

UNDOBLOCKSDONE NUMBER

UNDOBLOCKSTOTAL NUMBER

PID NUMBER

CPUTIME NUMBER

PARENTUSN NUMBER

PARENTSLT NUMBER

PARENTSEQ NUMBER

XID RAW(8)

PXID RAW(8)

RCVSERVERS NUMBER

V$FILEMETRIC: Synonym for V_$FILEMETRIC

iSelfSchooling-SQL> desc V$FILEMETRIC;

Name Null? Type

----------------------------- -------- --------------------

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

FILE_ID NUMBER

CREATION_TIME NUMBER

AVERAGE_READ_TIME NUMBER

AVERAGE_WRITE_TIME NUMBER

PHYSICAL_READS NUMBER

PHYSICAL_WRITES NUMBER

PHYSICAL_BLOCK_READS NUMBER

PHYSICAL_BLOCK_WRITES NUMBER

V$FILEMETRIC_HISTORY: Synonym for V_$FILEMETRIC_HISTORY

iSelfSchooling-SQL> desc V$FILEMETRIC_HISTORY;

Name Null? Type

----------------------------- -------- --------------------

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

FILE_ID NUMBER

CREATION_TIME NUMBER

AVERAGE_READ_TIME NUMBER

AVERAGE_WRITE_TIME NUMBER

PHYSICAL_READS NUMBER

PHYSICAL_WRITES NUMBER

PHYSICAL_BLOCK_READS NUMBER

PHYSICAL_BLOCK_WRITES NUMBER

V$FILESPACE_USAGE: Synonym for V_$FILESPACE_USAGE

iSelfSchooling-SQL> desc V$FILESPACE_USAGE;

Name Null? Type

----------------------------- -------- --------------------

TABLESPACE_ID NUMBER

RFNO NUMBER

ALLOCATED_SPACE NUMBER

FILE_SIZE NUMBER

FILE_MAXSIZE NUMBER

CHANGESCN_BASE NUMBER

CHANGESCN_WRAP NUMBER

FLAG NUMBER

V$FILESTAT: Synonym for V_$FILESTAT

iSelfSchooling-SQL> desc V$FILESTAT;

Name Null? Type

----------------------------- -------- --------------------

FILE# NUMBER

PHYRDS NUMBER

PHYWRTS NUMBER

PHYBLKRD NUMBER

PHYBLKWRT NUMBER

SINGLEBLKRDS NUMBER

READTIM NUMBER

WRITETIM NUMBER

SINGLEBLKRDTIM NUMBER

AVGIOTIM NUMBER

LSTIOTIM NUMBER

MINIOTIM NUMBER

MAXIORTM NUMBER

MAXIOWTM NUMBER

V$FILE_CACHE_TRANSFER: Synonym for V_$FILE_CACHE_TRANSFER

iSelfSchooling-SQL> desc V$FILE_CACHE_TRANSFER;

Name Null? Type

----------------------------- -------- --------------------

FILE_NUMBER NUMBER

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

RBR NUMBER

RBR_FORCED_WRITE NUMBER

RBR_FORCED_STALE NUMBER

NULL_2_X NUMBER

S_2_X NUMBER

NULL_2_S NUMBER

CR_TRANSFERS NUMBER

CUR_TRANSFERS NUMBER

V$FILE_HISTOGRAM: Synonym for V_$FILE_HISTOGRAM

iSelfSchooling-SQL> desc V$FILE_HISTOGRAM;

Name Null? Type

----------------------------- -------- --------------------

FILE# NUMBER

SINGLEBLKRDTIM_MILLI NUMBER

SINGLEBLKRDS NUMBER

V$FILE_PING: Synonym for V_$FILE_PING

iSelfSchooling-SQL> desc V$FILE_PING;

Name Null? Type

----------------------------- -------- --------------------

FILE_NUMBER NUMBER

FREQUENCY NUMBER

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

WRB NUMBER

WRB_FORCED_WRITE NUMBER

RBR NUMBER

RBR_FORCED_WRITE NUMBER

RBR_FORCED_STALE NUMBER

CBR NUMBER

CBR_FORCED_WRITE NUMBER

NULL_2_X NUMBER

S_2_X NUMBER

SSX_2_X NUMBER

NULL_2_S NUMBER

NULL_2_SS NUMBER

OP_2_SS NUMBER

V$FIXED_TABLE: Synonym for V_$FIXED_TABLE

iSelfSchooling-SQL> desc V$FIXED_TABLE;

Name Null? Type

----------------------------- -------- --------------------

NAME VARCHAR2(30)

OBJECT_ID NUMBER

TYPE VARCHAR2(5)

TABLE_NUM NUMBER

V$FIXED_VIEW_DEFINITION: Synonym for V_$FIXED_VIEW_DEFINITION

iSelfSchooling-SQL> desc V$FIXED_VIEW_DEFINITION;

Name Null? Type

----------------------------- -------- --------------------

VIEW_NAME VARCHAR2(30)

VIEW_DEFINITION VARCHAR2(4000)

V$FLASHBACK_DATABASE_LOG: Synonym for V_$FLASHBACK_DATABASE_LOG

iSelfSchooling-SQL> desc V$FLASHBACK_DATABASE_LOG;

Name Null? Type

----------------------------- -------- --------------------

OLDEST_FLASHBACK_SCN NUMBER

OLDEST_FLASHBACK_TIME DATE

RETENTION_TARGET NUMBER

FLASHBACK_SIZE NUMBER

ESTIMATED_FLASHBACK_SIZE NUMBER

V$FLASHBACK_DATABASE_LOGFILE: Synonym for V_$FLASHBACK_DATABASE_LOGFILE

iSelfSchooling-SQL> desc V$FLASHBACK_DATABASE_LOGFILE;

Name Null? Type

----------------------------- -------- --------------------

NAME VARCHAR2(513)

LOG# NUMBER

THREAD# NUMBER

SEQUENCE# NUMBER

BYTES NUMBER

FIRST_CHANGE# NUMBER

FIRST_TIME DATE

V$FLASHBACK_DATABASE_STAT: Synonym for V_$FLASHBACK_DATABASE_STAT

iSelfSchooling-SQL> desc V$FLASHBACK_DATABASE_STAT;

Name Null? Type

----------------------------- -------- --------------------

BEGIN_TIME DATE

END_TIME DATE

FLASHBACK_DATA NUMBER

DB_DATA NUMBER

REDO_DATA NUMBER

ESTIMATED_FLASHBACK_SIZE NUMBER