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

iSelfSchooling-SQL> desc V$PX_SESSTAT;

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

STATISTIC# NUMBER

VALUE NUMBER

V$QUEUE: Synonym for V_$QUEUE

iSelfSchooling-SQL> desc V$QUEUE;

Name Null? Type

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

PADDR RAW(8)

TYPE VARCHAR2(10)

QUEUED NUMBER

WAIT NUMBER

TOTALQ NUMBER

V$QUEUEING_MTH: Synonym for V_$QUEUEING_MTH

iSelfSchooling-SQL> desc V$QUEUEING_MTH;

Name Null? Type

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

NAME VARCHAR2(40)

V$RECOVERY_FILE_DEST: Synonym for V_$RECOVERY_FILE_DEST

iSelfSchooling-SQL> desc V$RECOVERY_FILE_DEST;

Name Null? Type

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

NAME VARCHAR2(513)

SPACE_LIMIT NUMBER

SPACE_USED NUMBER

SPACE_RECLAIMABLE NUMBER

NUMBER_OF_FILES NUMBER

V$RECOVERY_FILE_STATUS: Synonym for V_$RECOVERY_FILE_STATUS

iSelfSchooling-SQL> desc V$RECOVERY_FILE_STATUS;

Name Null? Type

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

FILENUM NUMBER

FILENAME VARCHAR2(513)

STATUS VARCHAR2(13)

V$RECOVERY_LOG: Synonym for V_$RECOVERY_LOG

iSelfSchooling-SQL> desc V$RECOVERY_LOG;

Name Null? Type

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

THREAD# NUMBER

SEQUENCE# NUMBER

TIME DATE

ARCHIVE_NAME VARCHAR2(513)

V$RECOVERY_PROGRESS: Synonym for V_$RECOVERY_PROGRESS

iSelfSchooling-SQL> desc V$RECOVERY_PROGRESS;

Name Null? Type

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

START_TIME DATE

TYPE VARCHAR2(64)

ITEM VARCHAR2(32)

UNITS VARCHAR2(32)

SOFAR NUMBER

TOTAL NUMBER

TIMESTAMP DATE

V$RECOVERY_STATUS: Synonym for V_$RECOVERY_STATUS

iSelfSchooling-SQL> desc V$RECOVERY_STATUS;

Name Null? Type

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

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)

V$RECOVER_FILE: Synonym for V_$RECOVER_FILE

iSelfSchooling-SQL> desc V$RECOVER_FILE;

Name Null? Type

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

FILE# NUMBER

ONLINE VARCHAR2(7)

ONLINE_STATUS VARCHAR2(7)

ERROR VARCHAR2(18)

CHANGE# NUMBER

TIME DATE

V$REPLPROP: Synonym for V_$REPLPROP

iSelfSchooling-SQL> desc V$REPLPROP;

Name Null? Type

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

SID NUMBER

SERIAL# NUMBER

NAME VARCHAR2(71)

DBLINK VARCHAR2(128)

STATE VARCHAR2(12)

XID VARCHAR2(22)

SEQUENCE NUMBER

V$REPLQUEUE: Synonym for V_$REPLQUEUE

iSelfSchooling-SQL> desc V$REPLQUEUE;

Name Null? Type

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

TXNS_ENQUEUED NUMBER

CALLS_ENQUEUED NUMBER

TXNS_PURGED NUMBER

LAST_ENQUEUE_TIME DATE

LAST_PURGE_TIME DATE

V$REQDIST: Synonym for V_$REQDIST

iSelfSchooling-SQL> desc V$REQDIST;

Name Null? Type

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

BUCKET NUMBER

COUNT NUMBER

V$RESERVED_WORDS: Synonym for V_$RESERVED_WORDS

iSelfSchooling-SQL> desc V$RESERVED_WORDS;

Name Null? Type

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

KEYWORD VARCHAR2(30)

LENGTH NUMBER

RESERVED VARCHAR2(1)

RES_TYPE VARCHAR2(1)

RES_ATTR VARCHAR2(1)

RES_SEMI VARCHAR2(1)

DUPLICATE VARCHAR2(1)

V$RESOURCE: Synonym for V_$RESOURCE

iSelfSchooling-SQL> desc V$RESOURCE;

Name Null? Type

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

ADDR RAW(8)

TYPE VARCHAR2(2)

ID1 NUMBER

ID2 NUMBER

V$RESOURCE_LIMIT: Synonym for V_$RESOURCE_LIMIT

iSelfSchooling-SQL> desc V$RESOURCE_LIMIT;

Name Null? Type

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

RESOURCE_NAME VARCHAR2(30)

CURRENT_UTILIZATION NUMBER

MAX_UTILIZATION NUMBER

INITIAL_ALLOCATION VARCHAR2(10)

LIMIT_VALUE VARCHAR2(10)

V$RESTORE_POINT: Synonym for V_$RESTORE_POINT

iSelfSchooling-SQL> desc V$RESTORE_POINT;

Name Null? Type

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

SCN NUMBER

DATABASE_INCARNATION# NUMBER

GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3)

STORAGE_SIZE NUMBER

TIME TIMESTAMP(9)

NAME VARCHAR2(128)

V$RESUMABLE: Synonym for V_$RESUMABLE

iSelfSchooling-SQL> desc V$RESUMABLE;

Name Null? Type

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

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)

V$RFS_THREAD: Synonym for V_$RFS_THREAD

iSelfSchooling-SQL> desc V$RFS_THREAD;

Name Null? Type

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

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

V$RMAN_BACKUP_JOB_DETAILS: Synonym for V_$RMAN_BACKUP_JOB_DETAILS

iSelfSchooling-SQL> desc V$RMAN_BACKUP_JOB_DETAILS;

Name Null? Type

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

SESSION_KEY NUMBER

SESSION_RECID NUMBER

SESSION_STAMP NUMBER

COMMAND_ID VARCHAR2(33)

START_TIME DATE

END_TIME DATE

INPUT_BYTES NUMBER

OUTPUT_BYTES NUMBER

STATUS_WEIGHT NUMBER

OPTIMIZED_WEIGHT NUMBER

OBJECT_TYPE_WEIGHT NUMBER

OUTPUT_DEVICE_TYPE VARCHAR2(17)

AUTOBACKUP_COUNT NUMBER

AUTOBACKUP_DONE VARCHAR2(3)

STATUS VARCHAR2(23)

INPUT_TYPE VARCHAR2(13)

OPTIMIZED VARCHAR2(3)

ELAPSED_SECONDS NUMBER

COMPRESSION_RATIO NUMBER

INPUT_BYTES_PER_SEC NUMBER

OUTPUT_BYTES_PER_SEC NUMBER

INPUT_BYTES_DISPLAY VARCHAR2(4000)

OUTPUT_BYTES_DISPLAY VARCHAR2(4000)

INPUT_BYTES_PER_SEC_DISPLAY VARCHAR2(4000)

OUTPUT_BYTES_PER_SEC_DISPLAY VARCHAR2(4000)

TIME_TAKEN_DISPLAY VARCHAR2(4000)

V$RMAN_BACKUP_SUBJOB_DETAILS: Synonym for V_$RMAN_BACKUP_SUBJOB_DETAILS

iSelfSchooling-SQL> desc V$RMAN_BACKUP_SUBJOB_DETAILS;

Name Null? Type

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

SESSION_KEY NUMBER

SESSION_RECID NUMBER

SESSION_STAMP NUMBER

OPERATION VARCHAR2(33)

COMMAND_ID VARCHAR2(33)

START_TIME DATE

END_TIME DATE

INPUT_BYTES NUMBER

OUTPUT_BYTES NUMBER

STATUS_WEIGHT NUMBER

OBJECT_TYPE_WEIGHT NUMBER

OPTIMIZED_WEIGHT NUMBER

OUTPUT_DEVICE_TYPE VARCHAR2(17)

AUTOBACKUP_DONE VARCHAR2(3)

STATUS VARCHAR2(23)

INPUT_TYPE VARCHAR2(13)

OPTIMIZED VARCHAR2(3)

AUTOBACKUP_COUNT NUMBER

COMPRESSION_RATIO NUMBER

INPUT_BYTES_DISPLAY VARCHAR2(4000)

OUTPUT_BYTES_DISPLAY VARCHAR2(4000)

V$RMAN_BACKUP_TYPE: Synonym for V_$RMAN_BACKUP_TYPE

iSelfSchooling-SQL> desc V$RMAN_BACKUP_TYPE;

Name Null? Type

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

WEIGHT NUMBER

INPUT_TYPE VARCHAR2(13)

V$RMAN_CONFIGURATION: Synonym for V_$RMAN_CONFIGURATION

iSelfSchooling-SQL> desc V$RMAN_CONFIGURATION;

Name Null? Type

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

CONF# NUMBER

NAME VARCHAR2(65)

VALUE VARCHAR2(1025)

V$RMAN_OUTPUT: Synonym for V_$RMAN_OUTPUT

iSelfSchooling-SQL> desc V$RMAN_OUTPUT;

Name Null? Type

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

SID NUMBER

RECID NUMBER

STAMP NUMBER

SESSION_RECID NUMBER

SESSION_STAMP NUMBER

OUTPUT VARCHAR2(130)

RMAN_STATUS_RECID NUMBER

RMAN_STATUS_STAMP NUMBER

SESSION_KEY NUMBER

V$RMAN_STATUS: Synonym for V_$RMAN_STATUS

iSelfSchooling-SQL> desc V$RMAN_STATUS;

Name Null? Type

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

SID NUMBER

RECID NUMBER

STAMP NUMBER

PARENT_RECID NUMBER

PARENT_STAMP NUMBER

SESSION_RECID NUMBER

SESSION_STAMP NUMBER

ROW_LEVEL NUMBER

ROW_TYPE VARCHAR2(19)

COMMAND_ID VARCHAR2(33)

OPERATION VARCHAR2(33)

STATUS VARCHAR2(23)

MBYTES_PROCESSED NUMBER

START_TIME DATE

END_TIME DATE

INPUT_BYTES NUMBER

OUTPUT_BYTES NUMBER

OPTIMIZED VARCHAR2(3)

OBJECT_TYPE VARCHAR2(13)

OUTPUT_DEVICE_TYPE VARCHAR2(17)

V$ROLLNAME: Synonym for V_$ROLLNAME

iSelfSchooling-SQL> desc V$ROLLNAME;

Name Null? Type

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

USN NUMBER

NAME NOT NULL VARCHAR2(30)

V$ROLLSTAT: Synonym for V_$ROLLSTAT

iSelfSchooling-SQL> desc V$ROLLSTAT;

Name Null? Type

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

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

V$ROWCACHE: Synonym for V_$ROWCACHE

iSelfSchooling-SQL> desc V$ROWCACHE;

Name Null? Type

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

CACHE# NUMBER

TYPE VARCHAR2(11)

SUBORDINATE# NUMBER

PARAMETER VARCHAR2(32)

COUNT NUMBER

USAGE NUMBER

FIXED NUMBER

GETS NUMBER

GETMISSES NUMBER

SCANS NUMBER

SCANMISSES NUMBER

SCANCOMPLETES NUMBER

MODIFICATIONS NUMBER

FLUSHES NUMBER

DLM_REQUESTS NUMBER

DLM_CONFLICTS NUMBER

DLM_RELEASES NUMBER

V$ROWCACHE_PARENT: Synonym for V_$ROWCACHE_PARENT

iSelfSchooling-SQL> desc V$ROWCACHE_PARENT;

Name Null? Type

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

INDX NUMBER

HASH NUMBER

ADDRESS RAW(8)

CACHE# NUMBER

CACHE_NAME VARCHAR2(64)

EXISTENT VARCHAR2(1)

LOCK_MODE NUMBER

LOCK_REQUEST NUMBER

TXN RAW(8)

SADDR RAW(8)

INST_LOCK_REQUEST NUMBER

INST_LOCK_RELEASE NUMBER

INST_LOCK_TYPE VARCHAR2(2)

INST_LOCK_ID1 RAW(4)

INST_LOCK_ID2 RAW(4)

KEY RAW(100)

V$ROWCACHE_SUBORDINATE: Synonym for V_$ROWCACHE_SUBORDINATE

iSelfSchooling-SQL> desc V$ROWCACHE_SUBORDINATE;

Name Null? Type

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

INDX NUMBER

HASH NUMBER

ADDRESS RAW(8)

CACHE# NUMBER

SUBCACHE# NUMBER

SUBCACHE_NAME VARCHAR2(64)

EXISTENT VARCHAR2(1)

PARENT RAW(8)

KEY RAW(100)

V$RSRC_CONSUMER_GROUP: Synonym for V_$RSRC_CONSUMER_GROUP

iSelfSchooling-SQL> desc V$RSRC_CONSUMER_GROUP;

Name Null? Type

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

ID NUMBER

NAME VARCHAR2(32)

ACTIVE_SESSIONS NUMBER

EXECUTION_WAITERS NUMBER

REQUESTS NUMBER

CPU_WAIT_TIME NUMBER

CPU_WAITS NUMBER

CONSUMED_CPU_TIME NUMBER

YIELDS NUMBER

QUEUE_LENGTH NUMBER

CURRENT_UNDO_CONSUMPTION NUMBER

ACTIVE_SESSION_LIMIT_HIT NUMBER

SESSION_SWITCHES_IN NUMBER

SESSION_SWITCHES_OUT NUMBER

UNDO_LIMIT_HIT NUMBER

SQL_CANCELED NUMBER

ACTIVE_SESSIONS_KILLED NUMBER

IDLE_SESSIONS_KILLED NUMBER

IDLE_BLKR_SESSIONS_KILLED NUMBER

QUEUED_TIME NUMBER

QUEUE_TIME_OUTS NUMBER

V$RSRC_CONSUMER_GROUP_CPU_MTH: Synonym for V_$RSRC_CONSUMER_GROUP_CPU_MTH

iSelfSchooling-SQL> desc V$RSRC_CONSUMER_GROUP_CPU_MTH;

Name Null? Type

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

NAME VARCHAR2(40)

V$RSRC_CONS_GROUP_HISTORY: Synonym for V_$RSRC_CONS_GROUP_HISTORY

iSelfSchooling-SQL> desc V$RSRC_CONS_GROUP_HISTORY;

Name Null? Type

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

SEQUENCE# NUMBER

ID NUMBER

NAME VARCHAR2(30)

REQUESTS NUMBER

CPU_WAIT_TIME NUMBER

CPU_WAITS NUMBER

CONSUMED_CPU_TIME NUMBER

YIELDS NUMBER

ACTIVE_SESS_LIMIT_HIT NUMBER

UNDO_LIMIT_HIT NUMBER

SESSION_SWITCHES_IN NUMBER

SESSION_SWITCHES_OUT NUMBER

SQL_CANCELED NUMBER

ACTIVE_SESS_KILLED NUMBER

IDLE_SESS_KILLED NUMBER

IDLE_BLKR_SESS_KILLED NUMBER

QUEUED_TIME NUMBER

QUEUE_TIME_OUTS NUMBER

V$RSRC_PLAN: Synonym for V_$RSRC_PLAN

iSelfSchooling-SQL> desc V$RSRC_PLAN;

Name Null? Type

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

ID NUMBER

NAME VARCHAR2(32)

IS_TOP_PLAN VARCHAR2(5)

V$RSRC_PLAN_CPU_MTH: Synonym for V_$RSRC_PLAN_CPU_MTH

iSelfSchooling-SQL> desc V$RSRC_PLAN_CPU_MTH;

Name Null? Type

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

NAME VARCHAR2(40)

V$RSRC_PLAN_HISTORY: Synonym for V_$RSRC_PLAN_HISTORY

iSelfSchooling-SQL> desc V$RSRC_PLAN_HISTORY;

Name Null? Type

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

SEQUENCE# NUMBER

ID NUMBER

NAME VARCHAR2(30)

START_TIME DATE

END_TIME DATE

ENABLED_BY_SCHEDULER VARCHAR2(5)

WINDOW_NAME VARCHAR2(30)

ALLOWED_AUTOMATED_SWITCHES VARCHAR2(5)

V$RSRC_SESSION_INFO: Synonym for V_$RSRC_SESSION_INFO

iSelfSchooling-SQL> desc V$RSRC_SESSION_INFO;

Name Null? Type

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

SID NUMBER

CURRENT_CONSUMER_GROUP_ID VARCHAR2(40)

ORIG_CONSUMER_GROUP_ID VARCHAR2(40)

MAPPING_ATTRIBUTE VARCHAR2(32)

MAPPED_CONSUMER_GROUP VARCHAR2(32)

STATE VARCHAR2(32)

ACTIVE VARCHAR2(5)

CURRENT_IDLE_TIME NUMBER

CURRENT_CPU_WAIT_TIME NUMBER

CPU_WAIT_TIME NUMBER

CURRENT_CPU_WAITS NUMBER

CPU_WAITS NUMBER

CURRENT_CONSUMED_CPU_TIME NUMBER

CONSUMED_CPU_TIME NUMBER

CURRENT_ACTIVE_TIME NUMBER

ACTIVE_TIME NUMBER

CURRENT_QUEUED_TIME NUMBER

QUEUED_TIME NUMBER

CURRENT_YIELDS NUMBER

YIELDS NUMBER

CURRENT_UNDO_CONSUMPTION NUMBER

MAX_UNDO_CONSUMPTION NUMBER

SQL_CANCELED NUMBER

QUEUE_TIME_OUTS NUMBER

ESTIMATED_EXECUTION_LIMIT_HIT NUMBER

V$RULE: Synonym for V_$RULE

iSelfSchooling-SQL> desc V$RULE;

Name Null? Type

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

RULE_SET_OBJECT_ID NUMBER

EVALUATION_CONTEXT_OBJECT_ID NUMBER

RULE_OWNER VARCHAR2(30)

RULE_NAME VARCHAR2(30)

RULE_CONDITION VARCHAR2(200)

TRUE_HITS NUMBER

MAYBE_HITS NUMBER

SQL_EVALUATIONS NUMBER

V$RULE_SET: Synonym for V_$RULE_SET

iSelfSchooling-SQL> desc V$RULE_SET;

Name Null? Type

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

OWNER VARCHAR2(30)

NAME VARCHAR2(30)

CPU_TIME NUMBER

ELAPSED_TIME NUMBER

FIRST_LOAD_TIME DATE

LAST_LOAD_TIME DATE

LAST_LOADING_TIME NUMBER

SHARABLE_MEM NUMBER

RELOADS NUMBER

INVALIDATIONS NUMBER

EVALUATIONS NUMBER

FIRST_HIT_EVALUATIONS NUMBER

SIMPLE_RULES_ONLY_EVALUATIONS NUMBER

SQL_FREE_EVALUATIONS NUMBER

SQL_EXECUTIONS NUMBER

CONDITIONS_PROCESSED NUMBER

TRUE_RULES NUMBER

MAYBE_RULES NUMBER

VARIABLE_VALUE_FUNCTION_CALLS NUMBER

VARIABLE_METHOD_FUNCTION_CALLS NUMBER

EVALUATION_FUNCTION_CALLS NUMBER

V$RULE_SET_AGGREGATE_STATS: Synonym for V_$RULE_SET_AGGREGATE_STATS

iSelfSchooling-SQL> desc V$RULE_SET_AGGREGATE_STATS;

Name Null? Type

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

NAME VARCHAR2(80)

VALUE NUMBER

V$SCHEDULER_RUNNING_JOBS: Synonym for V_$SCHEDULER_RUNNING_JOBS

iSelfSchooling-SQL> desc V$SCHEDULER_RUNNING_JOBS;

Name Null? Type

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

SESSION_ID NUMBER

SESSION_SERIAL_NUM NUMBER

JOB_ID NUMBER

PADDR RAW(8)

OS_PROCESS_ID VARCHAR2(12)

SESSION_STAT_CPU INTERVAL DAY(2)