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

iSelfSchooling-SQL> desc V$FLASH_RECOVERY_AREA_USAGE;

Name Null? Type

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

FILE_TYPE VARCHAR2(12)

PERCENT_SPACE_USED NUMBER

PERCENT_SPACE_RECLAIMABLE NUMBER

NUMBER_OF_FILES NUMBER

V$GCSHVMASTER_INFO: Synonym for V_$GCSHVMASTER_INFO

iSelfSchooling-SQL> desc V$GCSHVMASTER_INFO;

Name Null? Type

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

HV_ID NUMBER

CURRENT_MASTER NUMBER

PREVIOUS_MASTER NUMBER

REMASTER_CNT NUMBER

V$GCSPFMASTER_INFO: Synonym for V_$GCSPFMASTER_INFO

iSelfSchooling-SQL> desc V$GCSPFMASTER_INFO;

Name Null? Type

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

FILE_ID NUMBER

OBJECT_ID NUMBER

CURRENT_MASTER NUMBER

PREVIOUS_MASTER NUMBER

REMASTER_CNT NUMBER

V$GC_ELEMENT: Synonym for V_$GC_ELEMENT

iSelfSchooling-SQL> desc V$GC_ELEMENT;

Name Null? Type

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

GC_ELEMENT_ADDR RAW(8)

INDX NUMBER

CLASS NUMBER

GC_ELEMENT_NAME NUMBER

MODE_HELD NUMBER

BLOCK_COUNT NUMBER

RELEASING NUMBER

ACQUIRING NUMBER

WRITING NUMBER

RECOVERING NUMBER

LOCAL NUMBER

FLAGS NUMBER

V$GC_ELEMENTS_WITH_COLLISIONS: Synonym for V_$GC_ELEMENTS_W_COLLISIONS

iSelfSchooling-SQL> desc V$GC_ELEMENTS_WITH_COLLISIONS;

Name Null? Type

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

GC_ELEMENT_ADDR RAW(8)

V$GES_BLOCKING_ENQUEUE: Synonym for V_$GES_BLOCKING_ENQUEUE

iSelfSchooling-SQL> desc V$GES_BLOCKING_ENQUEUE;

Name Null? Type

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

HANDLE 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

STATE VARCHAR2(64)

AST_EVENT0 NUMBER

OWNER_NODE NUMBER

BLOCKED NUMBER

BLOCKER NUMBER

V$GES_ENQUEUE: Synonym for V_$GES_ENQUEUE

iSelfSchooling-SQL> desc V$GES_ENQUEUE;

Name Null? Type

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

HANDLE 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

STATE VARCHAR2(64)

AST_EVENT0 NUMBER

OWNER_NODE NUMBER

BLOCKED NUMBER

BLOCKER NUMBER

V$GLOBALCONTEXT: Synonym for V_$GLOBALCONTEXT

iSelfSchooling-SQL> desc V$GLOBALCONTEXT;

Name Null? Type

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

NAMESPACE VARCHAR2(31)

ATTRIBUTE VARCHAR2(31)

VALUE VARCHAR2(4000)

USERNAME VARCHAR2(31)

CLIENTIDENTIFIER VARCHAR2(65)

V$GLOBAL_BLOCKED_LOCKS: Synonym for V_$GLOBAL_BLOCKED_LOCKS

iSelfSchooling-SQL> desc V$GLOBAL_BLOCKED_LOCKS;

Name Null? Type

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

ADDR RAW(8)

KADDR RAW(8)

SID NUMBER

TYPE VARCHAR2(2)

ID1 NUMBER

ID2 NUMBER

LMODE NUMBER

REQUEST NUMBER

CTIME NUMBER

V$GLOBAL_TRANSACTION: Synonym for V_$GLOBAL_TRANSACTION

iSelfSchooling-SQL> desc V$GLOBAL_TRANSACTION;

Name Null? Type

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

FORMATID NUMBER

GLOBALID RAW(64)

BRANCHID RAW(64)

BRANCHES NUMBER

REFCOUNT NUMBER

PREPARECOUNT NUMBER

STATE VARCHAR2(18)

FLAGS NUMBER

COUPLING VARCHAR2(15)

V$HS_AGENT: Synonym for V_$HS_AGENT

iSelfSchooling-SQL> desc V$HS_AGENT;

Name Null? Type

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

AGENT_ID NUMBER

MACHINE VARCHAR2(64)

PROCESS VARCHAR2(9)

PROGRAM VARCHAR2(48)

OSUSER VARCHAR2(30)

STARTTIME DATE

AGENT_TYPE NUMBER

FDS_CLASS_ID NUMBER

FDS_INST_ID NUMBER

V$HS_PARAMETER: Synonym for V_$HS_PARAMETER

iSelfSchooling-SQL> desc V$HS_PARAMETER;

Name Null? Type

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

HS_SESSION_ID NUMBER

PARAMETER VARCHAR2(30)

VALUE VARCHAR2(64)

SOURCE VARCHAR2(1)

ENV VARCHAR2(1)

V$HS_SESSION: Synonym for V_$HS_SESSION

iSelfSchooling-SQL> desc V$HS_SESSION;

Name Null? Type

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

HS_SESSION_ID NUMBER

AGENT_ID NUMBER

SID NUMBER

DB_LINK VARCHAR2(128)

DB_LINK_OWNER NUMBER

STARTTIME DATE

V$HVMASTER_INFO: Synonym for V_$HVMASTER_INFO

iSelfSchooling-SQL> desc V$HVMASTER_INFO;

Name Null? Type

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

HV_ID NUMBER

CURRENT_MASTER NUMBER

PREVIOUS_MASTER NUMBER

REMASTER_CNT NUMBER

V$INDEXED_FIXED_COLUMN: Synonym for V_$INDEXED_FIXED_COLUMN

iSelfSchooling-SQL> desc V$INDEXED_FIXED_COLUMN;

Name Null? Type

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

TABLE_NAME VARCHAR2(30)

INDEX_NUMBER NUMBER

COLUMN_NAME VARCHAR2(30)

COLUMN_POSITION NUMBER

V$INSTANCE: Synonym for V_$INSTANCE

iSelfSchooling-SQL> desc V$INSTANCE;

Name Null? Type

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

INSTANCE_NUMBER NUMBER

INSTANCE_NAME VARCHAR2(16)

HOST_NAME VARCHAR2(64)

VERSION VARCHAR2(17)

STARTUP_TIME DATE

STATUS VARCHAR2(12)

PARALLEL VARCHAR2(3)

THREAD# NUMBER

ARCHIVER VARCHAR2(7)

LOG_SWITCH_WAIT VARCHAR2(15)

LOGINS VARCHAR2(10)

SHUTDOWN_PENDING VARCHAR2(3)

DATABASE_STATUS VARCHAR2(17)

INSTANCE_ROLE VARCHAR2(18)

ACTIVE_STATE VARCHAR2(9)

BLOCKED VARCHAR2(3)

V$INSTANCE_CACHE_TRANSFER: Synonym for V_$INSTANCE_CACHE_TRANSFER

iSelfSchooling-SQL> desc V$INSTANCE_CACHE_TRANSFER;

Name Null? Type

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

INSTANCE NUMBER

CLASS VARCHAR2(18)

CR_BLOCK NUMBER

CR_BUSY NUMBER

CR_CONGESTED NUMBER

CURRENT_BLOCK NUMBER

CURRENT_BUSY NUMBER

CURRENT_CONGESTED NUMBER

V$INSTANCE_LOG_GROUP: Synonym for V_$INSTANCE_LOG_GROUP

iSelfSchooling-SQL> desc V$INSTANCE_LOG_GROUP;

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

V$INSTANCE_RECOVERY: Synonym for V_$INSTANCE_RECOVERY

iSelfSchooling-SQL> desc V$INSTANCE_RECOVERY;

Name Null? Type

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

RECOVERY_ESTIMATED_IOS NUMBER

ACTUAL_REDO_BLKS NUMBER

TARGET_REDO_BLKS NUMBER

LOG_FILE_SIZE_REDO_BLKS NUMBER

LOG_CHKPT_TIMEOUT_REDO_BLKS NUMBER

LOG_CHKPT_INTERVAL_REDO_BLKS NUMBER

FAST_START_IO_TARGET_REDO_BLKS NUMBER

TARGET_MTTR NUMBER

ESTIMATED_MTTR NUMBER

CKPT_BLOCK_WRITES NUMBER

OPTIMAL_LOGFILE_SIZE NUMBER

ESTD_CLUSTER_AVAILABLE_TIME NUMBER

WRITES_MTTR NUMBER

WRITES_LOGFILE_SIZE NUMBER

WRITES_LOG_CHECKPOINT_SETTINGS NUMBER

WRITES_OTHER_SETTINGS NUMBER

WRITES_AUTOTUNE NUMBER

WRITES_FULL_THREAD_CKPT NUMBER

V$JAVAPOOL: Synonym for V_$JAVAPOOL

iSelfSchooling-SQL> desc V$JAVAPOOL;

Name Null? Type

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

CATEGORY VARCHAR2(16)

MEMUSED NUMBER

V$JAVA_LIBRARY_CACHE_MEMORY: Synonym for V_$JAVA_LIBRARY_CACHE_MEMORY

iSelfSchooling-SQL> desc V$JAVA_LIBRARY_CACHE_MEMORY;

Name Null? Type

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

LC_NAMESPACE VARCHAR2(15)

LC_INUSE_MEMORY_OBJECTS NUMBER

LC_INUSE_MEMORY_SIZE NUMBER

LC_FREEABLE_MEMORY_OBJECTS NUMBER

LC_FREEABLE_MEMORY_SIZE NUMBER

V$JAVA_POOL_ADVICE: Synonym for V_$JAVA_POOL_ADVICE

iSelfSchooling-SQL> desc V$JAVA_POOL_ADVICE;

Name Null? Type

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

JAVA_POOL_SIZE_FOR_ESTIMATE NUMBER

JAVA_POOL_SIZE_FACTOR NUMBER

ESTD_LC_SIZE NUMBER

ESTD_LC_MEMORY_OBJECTS NUMBER

ESTD_LC_TIME_SAVED NUMBER

ESTD_LC_TIME_SAVED_FACTOR NUMBER

ESTD_LC_LOAD_TIME NUMBER

ESTD_LC_LOAD_TIME_FACTOR NUMBER

ESTD_LC_MEMORY_OBJECT_HITS NUMBER

V$LATCH: Synonym for V_$LATCH

iSelfSchooling-SQL> desc V$LATCH;

Name Null? Type

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

ADDR RAW(8)

LATCH# NUMBER

LEVEL# NUMBER

NAME VARCHAR2(50)

HASH NUMBER

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

iSelfSchooling-SQL> desc V$LATCHHOLDER;

Name Null? Type

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

PID NUMBER

SID NUMBER

LADDR RAW(8)

NAME VARCHAR2(64)

GETS NUMBER

V$LATCHNAME: Synonym for V_$LATCHNAME

iSelfSchooling-SQL> desc V$LATCHNAME;

Name Null? Type

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

LATCH# NUMBER

NAME VARCHAR2(50)

HASH NUMBER

V$LATCH_CHILDREN: Synonym for V_$LATCH_CHILDREN

iSelfSchooling-SQL> desc V$LATCH_CHILDREN;

Name Null? Type

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

ADDR RAW(8)

LATCH# NUMBER

CHILD# NUMBER

LEVEL# NUMBER

NAME VARCHAR2(50)

HASH NUMBER

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

iSelfSchooling-SQL> desc V$LATCH_MISSES;

Name Null? Type

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

PARENT_NAME VARCHAR2(50)

WHERE VARCHAR2(64)

NWFAIL_COUNT NUMBER

SLEEP_COUNT NUMBER

WTR_SLP_COUNT NUMBER

LONGHOLD_COUNT NUMBER

LOCATION VARCHAR2(64)

V$LATCH_PARENT: Synonym for V_$LATCH_PARENT

iSelfSchooling-SQL> desc V$LATCH_PARENT;

Name Null? Type

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

ADDR RAW(8)

LATCH# NUMBER

LEVEL# NUMBER

NAME VARCHAR2(50)

HASH NUMBER

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

iSelfSchooling-SQL> desc V$LIBRARYCACHE;

Name Null? Type

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

NAMESPACE VARCHAR2(15)

GETS NUMBER

GETHITS NUMBER

GETHITRATIO NUMBER

PINS NUMBER

PINHITS NUMBER

PINHITRATIO NUMBER

RELOADS NUMBER

INVALIDATIONS NUMBER

DLM_LOCK_REQUESTS NUMBER

DLM_PIN_REQUESTS NUMBER

DLM_PIN_RELEASES NUMBER

DLM_INVALIDATION_REQUESTS NUMBER

DLM_INVALIDATIONS NUMBER

V$LIBRARY_CACHE_MEMORY: Synonym for V_$LIBRARY_CACHE_MEMORY

iSelfSchooling-SQL> desc V$LIBRARY_CACHE_MEMORY;

Name Null? Type

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

LC_NAMESPACE VARCHAR2(15)

LC_INUSE_MEMORY_OBJECTS NUMBER

LC_INUSE_MEMORY_SIZE NUMBER

LC_FREEABLE_MEMORY_OBJECTS NUMBER

LC_FREEABLE_MEMORY_SIZE NUMBER

V$LICENSE: Synonym for V_$LICENSE

iSelfSchooling-SQL> desc V$LICENSE;

Name Null? Type

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

SESSIONS_MAX NUMBER

SESSIONS_WARNING NUMBER

SESSIONS_CURRENT NUMBER

SESSIONS_HIGHWATER NUMBER

USERS_MAX NUMBER

CPU_COUNT_CURRENT NUMBER

CPU_CORE_COUNT_CURRENT NUMBER

CPU_SOCKET_COUNT_CURRENT NUMBER

CPU_COUNT_HIGHWATER NUMBER

CPU_CORE_COUNT_HIGHWATER NUMBER

CPU_SOCKET_COUNT_HIGHWATER NUMBER

V$LOADISTAT: Synonym for V_$LOADISTAT

iSelfSchooling-SQL> desc V$LOADISTAT;

Name Null? Type

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

OWNER VARCHAR2(31)

TABNAME VARCHAR2(31)

INDEXNAME VARCHAR2(31)

SUBNAME VARCHAR2(31)

MESSAGE_NUM NUMBER

MESSAGE VARCHAR2(4000)

V$LOADPSTAT: Synonym for V_$LOADPSTAT

iSelfSchooling-SQL> desc V$LOADPSTAT;

Name Null? Type

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

OWNER VARCHAR2(31)

TABNAME VARCHAR2(31)

PARTNAME VARCHAR2(31)

LOADED NUMBER

V$LOCK: Synonym for V_$LOCK

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

iSelfSchooling-SQL> desc V$LOCKED_OBJECT;

Name Null? Type

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

XIDUSN NUMBER

XIDSLOT NUMBER

XIDSQN NUMBER

OBJECT_ID NUMBER

SESSION_ID NUMBER

ORACLE_USERNAME VARCHAR2(30)

OS_USER_NAME VARCHAR2(30)

PROCESS VARCHAR2(12)

LOCKED_MODE NUMBER

V$LOCKS_WITH_COLLISIONS: Synonym for V_$LOCKS_WITH_COLLISIONS

iSelfSchooling-SQL> desc V$LOCKS_WITH_COLLISIONS;

Name Null? Type

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

LOCK_ELEMENT_ADDR RAW(8)

V$LOCK_ACTIVITY: Synonym for V_$LOCK_ACTIVITY

iSelfSchooling-SQL> desc V$LOCK_ACTIVITY;

Name Null? Type

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

FROM_VAL CHAR(4)

TO_VAL CHAR(1)

ACTION_VAL CHAR(21)

COUNTER NUMBER

V$LOCK_ELEMENT: Synonym for V_$LOCK_ELEMENT

iSelfSchooling-SQL> desc V$LOCK_ELEMENT;

Name Null? Type

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

LOCK_ELEMENT_ADDR RAW(8)

INDX NUMBER

CLASS NUMBER

LOCK_ELEMENT_NAME NUMBER

MODE_HELD NUMBER

BLOCK_COUNT NUMBER

RELEASING NUMBER

ACQUIRING NUMBER

INVALID NUMBER

FLAGS NUMBER

V$LOCK_TYPE: Synonym for V_$LOCK_TYPE

iSelfSchooling-SQL> desc V$LOCK_TYPE;

Name Null? Type

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

TYPE VARCHAR2(64)

NAME VARCHAR2(64)

ID1_TAG VARCHAR2(64)

ID2_TAG VARCHAR2(64)

IS_USER VARCHAR2(3)

DESCRIPTION VARCHAR2(4000)