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$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