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... | DAT... | ENQ... | INS... | LOG... | PGA... | ROW... | SES... | SQL... | SYS...

GV$INSTANCE_RECOVERY: Synonym for GV_$INSTANCE_RECOVERY

iSelfSchooling-SQL> desc GV$INSTANCE_RECOVERY;

Name Null? Type

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

INST_ID NUMBER

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_BLK 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_SETTING NUMBER

WRITES_OTHER_SETTINGS NUMBER

WRITES_AUTOTUNE NUMBER

WRITES_FULL_THREAD_CKPT NUMBER

GV$JAVAPOOL: Synonym for GV_$JAVAPOOL

iSelfSchooling-SQL> desc GV$JAVAPOOL;

Name Null? Type

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

INST_ID NUMBER

CATEGORY VARCHAR2(16)

MEMUSED NUMBER

GV$JAVA_LIBRARY_CACHE_MEMORY: Synonym for GV_$JAVA_LIBRARY_CACHE_MEMORY

iSelfSchooling-SQL> desc GV$JAVA_LIBRARY_CACHE_MEMORY;

Name Null? Type

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

INST_ID NUMBER

LC_NAMESPACE VARCHAR2(15)

LC_INUSE_MEMORY_OBJECTS NUMBER

LC_INUSE_MEMORY_SIZE NUMBER

LC_FREEABLE_MEMORY_OBJECTS NUMBER

LC_FREEABLE_MEMORY_SIZE NUMBER

GV$JAVA_POOL_ADVICE: Synonym for GV_$JAVA_POOL_ADVICE

iSelfSchooling-SQL> desc GV$JAVA_POOL_ADVICE;

Name Null? Type

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

INST_ID NUMBER

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

GV$LATCH: Synonym for GV_$LATCH

iSelfSchooling-SQL> desc GV$LATCH;

Name Null? Type

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

INST_ID NUMBER

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

GV$LATCHHOLDER: Synonym for GV_$LATCHHOLDER

iSelfSchooling-SQL> desc GV$LATCHHOLDER;

Name Null? Type

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

INST_ID NUMBER

PID NUMBER

SID NUMBER

LADDR RAW(8)

NAME VARCHAR2(64)

GETS NUMBER

GV$LATCHNAME: Synonym for GV_$LATCHNAME

iSelfSchooling-SQL> desc GV$LATCHNAME;

Name Null? Type

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

INST_ID NUMBER

LATCH# NUMBER

NAME VARCHAR2(50)

HASH NUMBER

GV$LATCH_CHILDREN: Synonym for GV_$LATCH_CHILDREN

iSelfSchooling-SQL> desc GV$LATCH_CHILDREN;

Name Null? Type

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

INST_ID NUMBER

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

GV$LATCH_MISSES: Synonym for GV_$LATCH_MISSES

iSelfSchooling-SQL> desc GV$LATCH_MISSES;

Name Null? Type

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

INST_ID NUMBER

PARENT_NAME VARCHAR2(50)

WHERE VARCHAR2(64)

NWFAIL_COUNT NUMBER

SLEEP_COUNT NUMBER

WTR_SLP_COUNT NUMBER

LONGHOLD_COUNT NUMBER

LOCATION VARCHAR2(64)

GV$LATCH_PARENT: Synonym for GV_$LATCH_PARENT

iSelfSchooling-SQL> desc GV$LATCH_PARENT;

Name Null? Type

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

INST_ID NUMBER

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

GV$LIBRARYCACHE: Synonym for GV_$LIBRARYCACHE

iSelfSchooling-SQL> desc GV$LIBRARYCACHE;

Name Null? Type

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

INST_ID NUMBER

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

GV$LIBRARY_CACHE_MEMORY: Synonym for GV_$LIBRARY_CACHE_MEMORY

iSelfSchooling-SQL> desc GV$LIBRARY_CACHE_MEMORY;

Name Null? Type

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

INST_ID NUMBER

LC_NAMESPACE VARCHAR2(15)

LC_INUSE_MEMORY_OBJECTS NUMBER

LC_INUSE_MEMORY_SIZE NUMBER

LC_FREEABLE_MEMORY_OBJECTS NUMBER

LC_FREEABLE_MEMORY_SIZE NUMBER

GV$LICENSE: Synonym for GV_$LICENSE

iSelfSchooling-SQL> desc GV$LICENSE;

Name Null? Type

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

INST_ID NUMBER

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

GV$LOADISTAT: Synonym for GV_$LOADISTAT

iSelfSchooling-SQL> desc GV$LOADISTAT;

Name Null? Type

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

INST_ID NUMBER

OWNER VARCHAR2(31)

TABNAME VARCHAR2(31)

INDEXNAME VARCHAR2(31)

SUBNAME VARCHAR2(31)

MESSAGE_NUM NUMBER

MESSAGE VARCHAR2(4000)

GV$LOADPSTAT: Synonym for GV_$LOADPSTAT

iSelfSchooling-SQL> desc GV$LOADPSTAT;

Name Null? Type

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

INST_ID NUMBER

OWNER VARCHAR2(31)

TABNAME VARCHAR2(31)

PARTNAME VARCHAR2(31)

LOADED NUMBER

GV$LOCK: Synonym for GV_$LOCK

iSelfSchooling-SQL> desc GV$LOCK;

Name Null? Type

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

INST_ID NUMBER

ADDR RAW(8)

KADDR RAW(8)

SID NUMBER

TYPE VARCHAR2(2)

ID1 NUMBER

ID2 NUMBER

LMODE NUMBER

REQUEST NUMBER

CTIME NUMBER

BLOCK NUMBER

GV$LOCKED_OBJECT: Synonym for GV_$LOCKED_OBJECT

iSelfSchooling-SQL> desc GV$LOCKED_OBJECT;

Name Null? Type

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

INST_ID NUMBER

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

GV$LOCKS_WITH_COLLISIONS: Synonym for GV_$LOCKS_WITH_COLLISIONS

iSelfSchooling-SQL> desc GV$LOCKS_WITH_COLLISIONS;

Name Null? Type

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

INST_ID NUMBER

LOCK_ELEMENT_ADDR RAW(8)

GV$LOCK_ACTIVITY: Synonym for GV_$LOCK_ACTIVITY

iSelfSchooling-SQL> desc GV$LOCK_ACTIVITY;

Name Null? Type

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

INST_ID NUMBER

FROM_VAL CHAR(4)

TO_VAL CHAR(1)

ACTION_VAL CHAR(21)

COUNTER NUMBER

GV$LOCK_ELEMENT: Synonym for GV_$LOCK_ELEMENT

iSelfSchooling-SQL> desc GV$LOCK_ELEMENT;

Name Null? Type

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

INST_ID NUMBER

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

GV$LOCK_TYPE: Synonym for GV_$LOCK_TYPE

iSelfSchooling-SQL> desc GV$LOCK_TYPE;

Name Null? Type

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

INST_ID NUMBER

TYPE VARCHAR2(64)

NAME VARCHAR2(64)

ID1_TAG VARCHAR2(64)

ID2_TAG VARCHAR2(64)

IS_USER VARCHAR2(3)

DESCRIPTION VARCHAR2(4000)

GV$LOG: Synonym for GV_$LOG

iSelfSchooling-SQL> desc GV$LOG;

Name Null? Type

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

INST_ID NUMBER

GROUP# NUMBER

THREAD# NUMBER

SEQUENCE# NUMBER

BYTES NUMBER

MEMBERS NUMBER

ARCHIVED VARCHAR2(3)

STATUS VARCHAR2(16)

FIRST_CHANGE# NUMBER

FIRST_TIME DATE

GV$LOGFILE: Synonym for GV_$LOGFILE

iSelfSchooling-SQL> desc GV$LOGFILE;

Name Null? Type

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

INST_ID NUMBER

GROUP# NUMBER

STATUS VARCHAR2(7)

TYPE VARCHAR2(7)

MEMBER VARCHAR2(513)

IS_RECOVERY_DEST_FILE VARCHAR2(3)

GV$LOGHIST: Synonym for GV_$LOGHIST

iSelfSchooling-SQL> desc GV$LOGHIST;

Name Null? Type

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

INST_ID NUMBER

THREAD# NUMBER

SEQUENCE# NUMBER

FIRST_CHANGE# NUMBER

FIRST_TIME DATE

SWITCH_CHANGE# NUMBER

GV$LOGMNR_CALLBACK: Synonym for GV_$LOGMNR_CALLBACK

iSelfSchooling-SQL> desc GV$LOGMNR_CALLBACK;

Name Null? Type

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

INST_ID NUMBER

SESSION_ID NUMBER

FUNCTION_ID NUMBER

DESCRIPTION VARCHAR2(64)

TYPE VARCHAR2(15)

GV$LOGMNR_CONTENTS: Synonym for GV_$LOGMNR_CONTENTS

iSelfSchooling-SQL> desc GV$LOGMNR_CONTENTS;

Name Null? Type

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

INST_ID NUMBER

SCN NUMBER

CSCN NUMBER

TIMESTAMP DATE

COMMIT_TIMESTAMP DATE

THREAD# NUMBER

LOG_ID NUMBER

XIDUSN NUMBER

XIDSLT NUMBER

XIDSQN NUMBER

PXIDUSN NUMBER

PXIDSLT NUMBER

PXIDSQN NUMBER

RBASQN NUMBER

RBABLK NUMBER

RBABYTE NUMBER

UBAFIL NUMBER

UBABLK NUMBER

UBAREC NUMBER

UBASQN NUMBER

ABS_FILE# NUMBER

REL_FILE# NUMBER

DATA_BLK# NUMBER

DATA_OBJ# NUMBER

DATA_OBJD# NUMBER

SEG_OWNER VARCHAR2(32)

SEG_NAME VARCHAR2(256)

TABLE_NAME VARCHAR2(32)

SEG_TYPE NUMBER

SEG_TYPE_NAME VARCHAR2(32)

TABLE_SPACE VARCHAR2(32)

ROW_ID VARCHAR2(18)

SESSION# NUMBER

SERIAL# NUMBER

USERNAME VARCHAR2(30)

SESSION_INFO VARCHAR2(4000)

TX_NAME VARCHAR2(256)

ROLLBACK NUMBER

OPERATION VARCHAR2(32)

OPERATION_CODE NUMBER

SQL_REDO VARCHAR2(4000)

SQL_UNDO VARCHAR2(4000)

RS_ID VARCHAR2(32)

SEQUENCE# NUMBER

SSN NUMBER

CSF NUMBER

INFO VARCHAR2(32)

STATUS NUMBER

REDO_VALUE NUMBER

UNDO_VALUE NUMBER

SQL_COLUMN_TYPE VARCHAR2(30)

SQL_COLUMN_NAME VARCHAR2(30)

REDO_LENGTH NUMBER

REDO_OFFSET NUMBER

UNDO_LENGTH NUMBER

UNDO_OFFSET NUMBER

DATA_OBJV# NUMBER

SAFE_RESUME_SCN NUMBER

XID RAW(8)

PXID RAW(8)

AUDIT_SESSIONID NUMBER

GV$LOGMNR_DICTIONARY: Synonym for GV_$LOGMNR_DICTIONARY

iSelfSchooling-SQL> desc GV$LOGMNR_DICTIONARY;

Name Null? Type

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

INST_ID NUMBER

DB_NAME VARCHAR2(9)

DB_ID NUMBER

DB_CREATED DATE

TIMESTAMP DATE

RESET_SCN NUMBER

RESET_SCN_TIME DATE

DB_VERSION_TIME DATE

DB_CHARACTER_SET VARCHAR2(30)

DB_VERSION VARCHAR2(64)

DB_STATUS VARCHAR2(64)

DICTIONARY_SCN NUMBER

ENABLED_THREAD_MAP RAW(16)

DB_TXN_SCN NUMBER

FILENAME VARCHAR2(512)

INFO VARCHAR2(32)

STATUS NUMBER

GV$LOGMNR_DICTIONARY_LOAD: Synonym for GV_$LOGMNR_DICTIONARY_LOAD

iSelfSchooling-SQL> desc GV$LOGMNR_DICTIONARY_LOAD;

Name Null? Type

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

INST_ID NUMBER

SESSION_ID NUMBER

LOGMNR_UID NUMBER

ACTION# NUMBER

OPCODE NUMBER

COMMAND VARCHAR2(161)

CURRENT_STATE VARCHAR2(32)

COMPLETED_ACTIONS NUMBER

TOTAL_ACTIONS NUMBER

LOADED VARCHAR2(7)

PERCENT_DONE NUMBER

GV$LOGMNR_LATCH: Synonym for GV_$LOGMNR_LATCH

iSelfSchooling-SQL> desc GV$LOGMNR_LATCH;

Name Null? Type

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

INST_ID NUMBER

SESSION_ID NUMBER

NAME VARCHAR2(32)

CHILD_ADDR RAW(8)

STATE VARCHAR2(6)

GV$LOGMNR_LOGFILE: Synonym for GV_$LOGMNR_LOGFILE

iSelfSchooling-SQL> desc GV$LOGMNR_LOGFILE;

Name Null? Type

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

INST_ID NUMBER

LOG_ID NUMBER

FILENAME VARCHAR2(513)

LOW_TIME NUMBER

NEXT_TIME NUMBER

DB_ID NUMBER

DB_NAME VARCHAR2(8)

RESET_SCNWRP NUMBER

RESET_SCNBAS NUMBER

RESET_SCN_TIME NUMBER

THREAD_ID NUMBER

THREAD_SQN NUMBER

LOW_SCNWRP NUMBER

LOW_SCNBAS NUMBER

NEXT_SCNWRP NUMBER

NEXT_SCNBAS NUMBER

FILE_STATE VARCHAR2(13)

GV$LOGMNR_LOGS: Synonym for GV_$LOGMNR_LOGS

iSelfSchooling-SQL> desc GV$LOGMNR_LOGS;

Name Null? Type

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

INST_ID NUMBER

LOG_ID NUMBER

FILENAME VARCHAR2(512)

LOW_TIME DATE

HIGH_TIME DATE

DB_ID NUMBER

DB_NAME VARCHAR2(8)

RESET_SCN NUMBER

RESET_SCN_TIME DATE

THREAD_ID NUMBER

THREAD_SQN NUMBER

LOW_SCN NUMBER

NEXT_SCN NUMBER

DICTIONARY_BEGIN VARCHAR2(3)

DICTIONARY_END VARCHAR2(3)

TYPE VARCHAR2(7)

BLOCKSIZE NUMBER

FILESIZE NUMBER

INFO VARCHAR2(32)

STATUS NUMBER

GV$LOGMNR_PARAMETERS: Synonym for GV_$LOGMNR_PARAMETERS

iSelfSchooling-SQL> desc GV$LOGMNR_PARAMETERS;

Name Null? Type

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

INST_ID NUMBER

START_DATE DATE

REQUIRED_START_DATE DATE

END_DATE DATE

START_SCN NUMBER

REQUIRED_START_SCN NUMBER

END_SCN NUMBER

OPTIONS NUMBER

INFO VARCHAR2(32)

STATUS NUMBER

GV$LOGMNR_PROCESS: Synonym for GV_$LOGMNR_PROCESS

iSelfSchooling-SQL> desc GV$LOGMNR_PROCESS;

Name Null? Type

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

INST_ID NUMBER

SESSION_ID NUMBER

PID NUMBER

ROLE VARCHAR2(32)

WORK_MICROSEC VARCHAR2(21)

OVERHEAD_MICROSEC VARCHAR2(21)

SPID VARCHAR2(12)

USERNAME VARCHAR2(15)

LATCHWAIT VARCHAR2(16)

LATCHSPIN VARCHAR2(16)

SID NUMBER

SERIAL# NUMBER

GV$LOGMNR_REGION: Synonym for GV_$LOGMNR_REGION

iSelfSchooling-SQL> desc GV$LOGMNR_REGION;

Name Null? Type

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

INST_ID NUMBER

MEMSTATE NUMBER

STATE VARCHAR2(9)

OWNING_PROCESS NUMBER