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

iSelfSchooling-SQL> desc V$TEMPSEG_USAGE;

Name Null? Type

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

USERNAME VARCHAR2(30)

USER VARCHAR2(30)

SESSION_ADDR RAW(8)

SESSION_NUM NUMBER

SQLADDR RAW(8)

SQLHASH NUMBER

SQL_ID VARCHAR2(13)

TABLESPACE VARCHAR2(31)

CONTENTS VARCHAR2(9)

SEGTYPE VARCHAR2(9)

SEGFILE# NUMBER

SEGBLK# NUMBER

EXTENTS NUMBER

BLOCKS NUMBER

SEGRFNO# NUMBER

V$TEMPSTAT: Synonym for V_$TEMPSTAT

iSelfSchooling-SQL> desc V$TEMPSTAT;

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

iSelfSchooling-SQL> desc V$TEMP_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

NULL_2_X NUMBER

S_2_X NUMBER

NULL_2_S NUMBER

V$TEMP_EXTENT_MAP: Synonym for V_$TEMP_EXTENT_MAP

iSelfSchooling-SQL> desc V$TEMP_EXTENT_MAP;

Name Null? Type

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

TABLESPACE_NAME NOT NULL VARCHAR2(30)

FILE_ID NUMBER

BLOCK_ID NUMBER

BYTES NUMBER

BLOCKS NUMBER

OWNER NUMBER

RELATIVE_FNO NUMBER

V$TEMP_EXTENT_POOL: Synonym for V_$TEMP_EXTENT_POOL

iSelfSchooling-SQL> desc V$TEMP_EXTENT_POOL;

Name Null? Type

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

TABLESPACE_NAME NOT NULL VARCHAR2(30)

FILE_ID NUMBER

EXTENTS_CACHED NUMBER

EXTENTS_USED NUMBER

BLOCKS_CACHED NUMBER

BLOCKS_USED NUMBER

BYTES_CACHED NUMBER

BYTES_USED NUMBER

RELATIVE_FNO NUMBER

V$TEMP_HISTOGRAM: Synonym for V_$TEMP_HISTOGRAM

iSelfSchooling-SQL> desc V$TEMP_HISTOGRAM;

Name Null? Type

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

FILE# NUMBER

SINGLEBLKRDTIM_MILLI NUMBER

SINGLEBLKRDS NUMBER

V$TEMP_PING: Synonym for V_$TEMP_PING

iSelfSchooling-SQL> desc V$TEMP_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$TEMP_SPACE_HEADER: Synonym for V_$TEMP_SPACE_HEADER

iSelfSchooling-SQL> desc V$TEMP_SPACE_HEADER;

Name Null? Type

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

TABLESPACE_NAME NOT NULL VARCHAR2(30)

FILE_ID NUMBER

BYTES_USED NUMBER

BLOCKS_USED NUMBER

BYTES_FREE NUMBER

BLOCKS_FREE NUMBER

RELATIVE_FNO NUMBER

V$THREAD: Synonym for V_$THREAD

iSelfSchooling-SQL> desc V$THREAD;

Name Null? Type

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

THREAD# NUMBER

STATUS VARCHAR2(6)

ENABLED VARCHAR2(8)

GROUPS NUMBER

INSTANCE VARCHAR2(80)

OPEN_TIME DATE

CURRENT_GROUP# NUMBER

SEQUENCE# NUMBER

CHECKPOINT_CHANGE# NUMBER

CHECKPOINT_TIME DATE

ENABLE_CHANGE# NUMBER

ENABLE_TIME DATE

DISABLE_CHANGE# NUMBER

DISABLE_TIME DATE

LAST_REDO_SEQUENCE# NUMBER

LAST_REDO_BLOCK NUMBER

LAST_REDO_CHANGE# NUMBER

LAST_REDO_TIME DATE

V$THRESHOLD_TYPES: Synonym for V_$THRESHOLD_TYPES

iSelfSchooling-SQL> desc V$THRESHOLD_TYPES;

Name Null? Type

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

METRICS_ID NUMBER

METRICS_GROUP_ID NUMBER

OPERATOR_MASK NUMBER

OBJECT_TYPE VARCHAR2(64)

ALERT_REASON_ID NUMBER

METRIC_VALUE_TYPE NUMBER

V$TIMER: Synonym for V_$TIMER

iSelfSchooling-SQL> desc V$TIMER;

Name Null? Type

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

HSECS NUMBER

V$TIMEZONE_FILE: Synonym for V_$TIMEZONE_FILE

iSelfSchooling-SQL> desc V$TIMEZONE_FILE;

Name Null? Type

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

FILENAME VARCHAR2(12)

VERSION NUMBER

V$TIMEZONE_NAMES: Synonym for V_$TIMEZONE_NAMES

iSelfSchooling-SQL> desc V$TIMEZONE_NAMES;

Name Null? Type

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

TZNAME VARCHAR2(64)

TZABBREV VARCHAR2(64)

V$TRANSACTION: Synonym for V_$TRANSACTION

iSelfSchooling-SQL> desc V$TRANSACTION;

Name Null? Type

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

ADDR RAW(8)

XIDUSN NUMBER

XIDSLOT NUMBER

XIDSQN NUMBER

UBAFIL NUMBER

UBABLK NUMBER

UBASQN NUMBER

UBAREC NUMBER

STATUS VARCHAR2(16)

START_TIME VARCHAR2(20)

START_SCNB NUMBER

START_SCNW NUMBER

START_UEXT NUMBER

START_UBAFIL NUMBER

START_UBABLK NUMBER

START_UBASQN NUMBER

START_UBAREC NUMBER

SES_ADDR RAW(8)

FLAG NUMBER

SPACE VARCHAR2(3)

RECURSIVE VARCHAR2(3)

NOUNDO VARCHAR2(3)

PTX VARCHAR2(3)

NAME VARCHAR2(256)

PRV_XIDUSN NUMBER

PRV_XIDSLT NUMBER

PRV_XIDSQN NUMBER

PTX_XIDUSN NUMBER

PTX_XIDSLT NUMBER

PTX_XIDSQN NUMBER

DSCN-B NUMBER

DSCN-W NUMBER

USED_UBLK NUMBER

USED_UREC NUMBER

LOG_IO NUMBER

PHY_IO NUMBER

CR_GET NUMBER

CR_CHANGE NUMBER

START_DATE DATE

DSCN_BASE NUMBER

DSCN_WRAP NUMBER

START_SCN NUMBER

DEPENDENT_SCN NUMBER

XID RAW(8)

PRV_XID RAW(8)

PTX_XID RAW(8)

V$TRANSACTION_ENQUEUE: Synonym for V_$TRANSACTION_ENQUEUE

iSelfSchooling-SQL> desc V$TRANSACTION_ENQUEUE;

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

iSelfSchooling-SQL> desc V$TRANSPORTABLE_PLATFORM;

Name Null? Type

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

PLATFORM_ID NUMBER

PLATFORM_NAME VARCHAR2(101)

ENDIAN_FORMAT VARCHAR2(14)

V$TSM_SESSIONS: Synonym for V_$TSM_SESSIONS

iSelfSchooling-SQL> desc V$TSM_SESSIONS;

Name Null? Type

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

SID NUMBER

SERIAL# NUMBER

STATE VARCHAR2(24)

MIGRATABLE VARCHAR2(3)

MIGRATION_ALLOWED VARCHAR2(3)

TRANSFERABLE VARCHAR2(3)

MIGRATION_BOUNDARY VARCHAR2(3)

NONMIGRATABILITY_REASON VARCHAR2(4000)

NONMIGRATABILITY_INFO VARCHAR2(4000)

NONTRANSFERABILITY_REASON VARCHAR2(4000)

NONTRANSFERABILITY_INFO VARCHAR2(4000)

STATELESS VARCHAR2(11)

PRESERVE_STATE VARCHAR2(3)

COST NUMBER

DESTINATION VARCHAR2(4000)

ROUNDTRIPS NUMBER

BLOCKING_COMPONENT VARCHAR2(4000)

START_TIME DATE

SEQUENCE_NUMBER NUMBER

V$TYPE_SIZE: Synonym for V_$TYPE_SIZE

iSelfSchooling-SQL> desc V$TYPE_SIZE;

Name Null? Type

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

COMPONENT VARCHAR2(8)

TYPE VARCHAR2(8)

DESCRIPTION VARCHAR2(32)

TYPE_SIZE NUMBER

V$UNDOSTAT: Synonym for V_$UNDOSTAT

iSelfSchooling-SQL> desc V$UNDOSTAT;

Name Null? Type

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

BEGIN_TIME DATE

END_TIME DATE

UNDOTSN NUMBER

UNDOBLKS NUMBER

TXNCOUNT NUMBER

MAXQUERYLEN NUMBER

MAXQUERYID VARCHAR2(13)

MAXCONCURRENCY NUMBER

UNXPSTEALCNT NUMBER

UNXPBLKRELCNT NUMBER

UNXPBLKREUCNT NUMBER

EXPSTEALCNT NUMBER

EXPBLKRELCNT NUMBER

EXPBLKREUCNT NUMBER

SSOLDERRCNT NUMBER

NOSPACEERRCNT NUMBER

ACTIVEBLKS NUMBER

UNEXPIREDBLKS NUMBER

EXPIREDBLKS NUMBER

TUNED_UNDORETENTION NUMBER

V$UNUSABLE_BACKUPFILE_DETAILS: Synonym for V_$UNUSABLE_BACKUPFILE_DETAILS

iSelfSchooling-SQL> desc V$UNUSABLE_BACKUPFILE_DETAILS;

Name Null? Type

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

SESSION_KEY NUMBER

SESSION_RECID NUMBER

SESSION_STAMP NUMBER

RMAN_STATUS_RECID NUMBER

RMAN_STATUS_STAMP NUMBER

BTYPE CHAR(9)

BTYPE_KEY NUMBER

ID1 NUMBER

ID2 NUMBER

FILETYPE VARCHAR2(15)

FILETYPE_KEY NUMBER

STATUS VARCHAR2(1)

FILESIZE NUMBER

DEVICE_TYPE VARCHAR2(17)

FILENAME VARCHAR2(513)

MEDIA VARCHAR2(65)

MEDIA_POOL NUMBER

V$VERSION: Synonym for V_$VERSION

iSelfSchooling-SQL> desc V$VERSION;

Name Null? Type

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

BANNER VARCHAR2(64)

V$VPD_POLICY: Synonym for V_$VPD_POLICY

iSelfSchooling-SQL> desc V$VPD_POLICY;

Name Null? Type

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

ADDRESS RAW(8)

PARADDR RAW(8)

SQL_HASH NUMBER

SQL_ID VARCHAR2(13)

CHILD_NUMBER NUMBER

OBJECT_OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(30)

POLICY_GROUP VARCHAR2(30)

POLICY VARCHAR2(30)

POLICY_FUNCTION_OWNER VARCHAR2(30)

PREDICATE VARCHAR2(4000)

V$WAITCLASSMETRIC: Synonym for V_$WAITCLASSMETRIC

iSelfSchooling-SQL> desc V$WAITCLASSMETRIC;

Name Null? Type

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

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS_ID NUMBER

AVERAGE_WAITER_COUNT NUMBER

DBTIME_IN_WAIT NUMBER

TIME_WAITED NUMBER

WAIT_COUNT NUMBER

V$WAITCLASSMETRIC_HISTORY: Synonym for V_$WAITCLASSMETRIC_HISTORY

iSelfSchooling-SQL> desc V$WAITCLASSMETRIC_HISTORY;

Name Null? Type

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

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS_ID NUMBER

AVERAGE_WAITER_COUNT NUMBER

DBTIME_IN_WAIT NUMBER

TIME_WAITED NUMBER

WAIT_COUNT NUMBER

V$WAITSTAT: Synonym for V_$WAITSTAT

iSelfSchooling-SQL> desc V$WAITSTAT;

Name Null? Type

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

CLASS VARCHAR2(18)

COUNT NUMBER

TIME NUMBER

V$WALLET: Synonym for V_$WALLET

iSelfSchooling-SQL> desc V$WALLET;

Name Null? Type

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

CERT_ID VARCHAR2(52)

DN VARCHAR2(255)

SERIAL_NUM VARCHAR2(40)

ISSUER VARCHAR2(255)

KEYSIZE NUMBER

STATUS VARCHAR2(16)

V$XML_AUDIT_TRAIL: Synonym for V_$XML_AUDIT_TRAIL

iSelfSchooling-SQL> desc V$XML_AUDIT_TRAIL;

Name Null? Type

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

AUDIT_TYPE NUMBER

SESSION_ID NUMBER

PROXY_SESSIONID NUMBER

STATEMENTID NUMBER

ENTRYID NUMBER

EXTENDED_TIMESTAMP TIMESTAMP(6)

GLOBAL_UID VARCHAR2(32)

DB_USER VARCHAR2(30)

CLIENTIDENTIFIER VARCHAR2(64)

EXT_NAME VARCHAR2(1024)

OS_USER VARCHAR2(30)

OS_HOST VARCHAR2(128)

OS_PROCESS VARCHAR2(16)

TERMINAL VARCHAR2(30)

INSTANCE_NUMBER NUMBER

OBJECT_SCHEMA VARCHAR2(30)

OBJECT_NAME VARCHAR2(30)

POLICY_NAME VARCHAR2(30)

NEW_OWNER VARCHAR2(30)

NEW_NAME VARCHAR2(30)

ACTION NUMBER

STATEMENT_TYPE NUMBER

TRANSACTIONID RAW(8)

RETURNCODE NUMBER

SCN NUMBER

COMMENT_TEXT VARCHAR2(4000)

AUTH_PRIVILEGES VARCHAR2(16)

GRANTEE VARCHAR2(30)

PRIV_USED NUMBER

SES_ACTIONS VARCHAR2(16)

OS_PRIVILEGE VARCHAR2(7)

ECONTEXT_ID VARCHAR2(64)

SQL_BIND VARCHAR2(4000)

SQL_TEXT VARCHAR2(4000)

V$_LOCK: Synonym for V_$_LOCK

iSelfSchooling-SQL> desc V$_LOCK;

Name Null? Type

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

LADDR RAW(8)

KADDR RAW(8)

SADDR RAW(8)

RADDR RAW(8)

LMODE NUMBER

REQUEST NUMBER

CTIME NUMBER

BLOCK NUMBER