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$LOGMNR_SESSION: Synonym for GV_$LOGMNR_SESSION

iSelfSchooling-SQL> desc GV$LOGMNR_SESSION;

Name Null? Type

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

INST_ID NUMBER

SESSION_ID NUMBER

SESSION_NAME VARCHAR2(32)

SESSION_STATE VARCHAR2(9)

DB_NAME VARCHAR2(128)

DB_ID NUMBER

RESET_SCN NUMBER

RESET_TIMESTAMP NUMBER

NUM_PROCESS NUMBER

CHUNK_SIZE NUMBER

START_SCN NUMBER

END_SCN NUMBER

SPILL_SCN NUMBER

PROCESSED_SCN NUMBER

PREPARED_SCN NUMBER

READ_SCN NUMBER

LOW_MARK_SCN NUMBER

CONSUMED_SCN NUMBER

MAX_MEMORY_SIZE NUMBER

USED_MEMORY_SIZE NUMBER

PREPARED_WORK_SIZE NUMBER

AVAILABLE_WORK_SIZE NUMBER

AVAILABLE_TXN NUMBER

AVAILABLE_COMMITTED_TXN NUMBER

DELIVERED_TXN NUMBER

DELIVERED_COMMITTED_TXN NUMBER

PINNED_TXN NUMBER

PINNED_COMMITTED_TXN NUMBER

CHECKPOINT_INTERVAL NUMBER

GV$LOGMNR_STATS: Synonym for GV_$LOGMNR_STATS

iSelfSchooling-SQL> desc GV$LOGMNR_STATS;

Name Null? Type

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

INST_ID NUMBER

SESSION_ID NUMBER

NAME VARCHAR2(32)

VALUE VARCHAR2(21)

GV$LOGMNR_TRANSACTION: Synonym for GV_$LOGMNR_TRANSACTION

iSelfSchooling-SQL> desc GV$LOGMNR_TRANSACTION;

Name Null? Type

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

INST_ID NUMBER

SESSION_ID NUMBER

XID RAW(8)

XIDUSN NUMBER

XIDSLT NUMBER

XIDSQN NUMBER

PARENT_XID RAW(8)

PARENT_XIDUSN NUMBER

PARENT_XIDSLT NUMBER

PARENT_XIDSQN NUMBER

START_TIME DATE

START_SCN NUMBER

CHUNK# NUMBER

TOTAL_CHUNKS NUMBER

REDO_THREAD NUMBER

LOW_TIME DATE

LOW_SCN NUMBER

HIGH_TIME DATE

HIGH_SCN NUMBER

LCR_COUNT NUMBER

SPILLED_LCR_COUNT NUMBER

DFLAG NUMBER

MFLAG NUMBER

MFLAG2 NUMBER

STATE VARCHAR2(32)

TYPE VARCHAR2(32)

MINING_STATUS VARCHAR2(32)

QUEUE VARCHAR2(32)

GV$LOGSTDBY: Synonym for GV_$LOGSTDBY

iSelfSchooling-SQL> desc GV$LOGSTDBY;

Name Null? Type

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

INST_ID NUMBER

SERIAL# NUMBER

LOGSTDBY_ID NUMBER

PID VARCHAR2(12)

TYPE VARCHAR2(30)

STATUS_CODE NUMBER

STATUS VARCHAR2(256)

HIGH_SCN NUMBER

GV$LOGSTDBY_PROCESS: Synonym for GV_$LOGSTDBY_PROCESS

iSelfSchooling-SQL> desc GV$LOGSTDBY_PROCESS;

Name Null? Type

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

INST_ID NUMBER

SID NUMBER

SERIAL# NUMBER

LOGSTDBY_ID NUMBER

SPID VARCHAR2(12)

TYPE VARCHAR2(30)

STATUS_CODE NUMBER

STATUS VARCHAR2(256)

HIGH_SCN NUMBER

GV$LOGSTDBY_PROGRESS: Synonym for GV_$LOGSTDBY_PROGRESS

iSelfSchooling-SQL> desc GV$LOGSTDBY_PROGRESS;

Name Null? Type

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

INST_ID NUMBER

APPLIED_SCN NUMBER

APPLIED_TIME DATE

RESTART_SCN NUMBER

RESTART_TIME DATE

LATEST_SCN NUMBER

LATEST_TIME DATE

MINING_SCN NUMBER

MINING_TIME DATE

GV$LOGSTDBY_STATE: Synonym for GV_$LOGSTDBY_STATE

iSelfSchooling-SQL> desc GV$LOGSTDBY_STATE;

Name Null? Type

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

INST_ID NUMBER

PRIMARY_DBID NUMBER

SESSION_ID NUMBER

REALTIME_APPLY VARCHAR2(64)

STATE VARCHAR2(64)

GV$LOGSTDBY_STATS: Synonym for GV_$LOGSTDBY_STATS

iSelfSchooling-SQL> desc GV$LOGSTDBY_STATS;

Name Null? Type

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

INST_ID NUMBER

NAME VARCHAR2(64)

VALUE VARCHAR2(64)

GV$LOGSTDBY_TRANSACTION: Synonym for GV_$LOGSTDBY_TRANSACTION

iSelfSchooling-SQL> desc GV$LOGSTDBY_TRANSACTION;

Name Null? Type

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

INST_ID NUMBER

PRIMARY_XID RAW(8)

PRIMARY_START_SCN NUMBER

PRIMARY_START_TIME DATE

PRIMARY_PARENT_XID RAW(8)

MINING_STATUS VARCHAR2(32)

APPLY_STATUS VARCHAR2(6)

SID NUMBER

SERIAL# NUMBER

GV$LOG_HISTORY: Synonym for GV_$LOG_HISTORY

iSelfSchooling-SQL> desc GV$LOG_HISTORY;

Name Null? Type

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

INST_ID NUMBER

RECID NUMBER

STAMP NUMBER

THREAD# NUMBER

SEQUENCE# NUMBER

FIRST_CHANGE# NUMBER

FIRST_TIME DATE

NEXT_CHANGE# NUMBER

RESETLOGS_CHANGE# NUMBER

RESETLOGS_TIME DATE

GV$MANAGED_STANDBY: Synonym for GV_$MANAGED_STANDBY

iSelfSchooling-SQL> desc GV$MANAGED_STANDBY;

Name Null? Type

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

INST_ID NUMBER

PROCESS VARCHAR2(9)

PID NUMBER

STATUS VARCHAR2(12)

CLIENT_PROCESS VARCHAR2(8)

CLIENT_PID VARCHAR2(40)

CLIENT_DBID VARCHAR2(40)

GROUP# VARCHAR2(40)

RESETLOG_ID NUMBER

THREAD# NUMBER

SEQUENCE# NUMBER

BLOCK# NUMBER

BLOCKS NUMBER

DELAY_MINS NUMBER

KNOWN_AGENTS NUMBER

ACTIVE_AGENTS NUMBER

GV$MAP_COMP_LIST: Synonym for GV_$MAP_COMP_LIST

iSelfSchooling-SQL> desc GV$MAP_COMP_LIST;

Name Null? Type

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

INST_ID NUMBER

ELEM_IDX NUMBER

NUM_COMP NUMBER

COMP1_NAME VARCHAR2(256)

COMP1_VAL VARCHAR2(256)

COMP2_NAME VARCHAR2(256)

COMP2_VAL VARCHAR2(256)

COMP3_NAME VARCHAR2(256)

COMP3_VAL VARCHAR2(256)

COMP4_NAME VARCHAR2(256)

COMP4_VAL VARCHAR2(256)

COMP5_NAME VARCHAR2(256)

COMP5_VAL VARCHAR2(256)

GV$MAP_ELEMENT: Synonym for GV_$MAP_ELEMENT

iSelfSchooling-SQL> desc GV$MAP_ELEMENT;

Name Null? Type

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

INST_ID NUMBER

ELEM_NAME VARCHAR2(256)

ELEM_IDX NUMBER

ELEM_CFGID VARCHAR2(256)

ELEM_TYPE VARCHAR2(12)

ELEM_SIZE NUMBER

ELEM_NSUBELEM NUMBER

ELEM_DESCR VARCHAR2(256)

STRIPE_SIZE NUMBER

LIB_IDX NUMBER

GV$MAP_EXT_ELEMENT: Synonym for GV_$MAP_EXT_ELEMENT

iSelfSchooling-SQL> desc GV$MAP_EXT_ELEMENT;

Name Null? Type

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

INST_ID NUMBER

ELEM_IDX NUMBER

NUM_ATTRB NUMBER

ATTRB1_NAME VARCHAR2(256)

ATTRB1_VAL VARCHAR2(256)

ATTRB2_NAME VARCHAR2(256)

ATTRB2_VAL VARCHAR2(256)

ATTRB3_NAME VARCHAR2(256)

ATTRB3_VAL VARCHAR2(256)

ATTRB4_NAME VARCHAR2(256)

ATTRB4_VAL VARCHAR2(256)

ATTRB5_NAME VARCHAR2(256)

ATTRB5_VAL VARCHAR2(256)

GV$MAP_FILE: Synonym for GV_$MAP_FILE

iSelfSchooling-SQL> desc GV$MAP_FILE;

Name Null? Type

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

INST_ID NUMBER

FILE_MAP_IDX NUMBER

FILE_CFGID VARCHAR2(256)

FILE_STATUS VARCHAR2(7)

FILE_NAME VARCHAR2(256)

FILE_TYPE VARCHAR2(11)

FILE_STRUCTURE VARCHAR2(9)

FILE_SIZE NUMBER

FILE_NEXTS NUMBER

LIB_IDX NUMBER

GV$MAP_FILE_EXTENT: Synonym for GV_$MAP_FILE_EXTENT

iSelfSchooling-SQL> desc GV$MAP_FILE_EXTENT;

Name Null? Type

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

INST_ID NUMBER

FILE_MAP_IDX NUMBER

EXT_NUM NUMBER

EXT_ELEM_OFF NUMBER

EXT_SIZE NUMBER

EXT_FILE_OFF NUMBER

EXT_TYPE VARCHAR2(6)

ELEM_IDX NUMBER

GV$MAP_FILE_IO_STACK: Synonym for GV_$MAP_FILE_IO_STACK

iSelfSchooling-SQL> desc GV$MAP_FILE_IO_STACK;

Name Null? Type

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

INST_ID NUMBER

FILE_MAP_IDX NUMBER

DEPTH NUMBER

ELEM_IDX NUMBER

CU_SIZE NUMBER

STRIDE NUMBER

NUM_CU NUMBER

ELEM_OFFSET NUMBER

FILE_OFFSET NUMBER

DATA_TYPE VARCHAR2(15)

PARITY_POS NUMBER

PARITY_PERIOD NUMBER

ID NUMBER

PARENT_ID NUMBER

GV$MAP_LIBRARY: Synonym for GV_$MAP_LIBRARY

iSelfSchooling-SQL> desc GV$MAP_LIBRARY;

Name Null? Type

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

INST_ID NUMBER

LIB_IDX NUMBER

LIB_NAME VARCHAR2(256)

VENDOR_NAME VARCHAR2(64)

PROTOCOL_NUM NUMBER

VERSION_NUM VARCHAR2(32)

PATH_NAME VARCHAR2(1024)

MAP_FILE VARCHAR2(1)

FILE_CFGID VARCHAR2(13)

MAP_ELEM VARCHAR2(1)

ELEM_CFGID VARCHAR2(13)

MAP_SYNC VARCHAR2(1)

GV$MAP_SUBELEMENT: Synonym for GV_$MAP_SUBELEMENT

iSelfSchooling-SQL> desc GV$MAP_SUBELEMENT;

Name Null? Type

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

INST_ID NUMBER

CHILD_IDX NUMBER

PARENT_IDX NUMBER

SUB_NUM NUMBER

SUB_SIZE NUMBER

ELEM_OFFSET NUMBER

SUB_FLAGS NUMBER

GV$MAX_ACTIVE_SESS_TARGET_MTH: Synonym for GV_$MAX_ACTIVE_SESS_TARGET_MTH

iSelfSchooling-SQL> desc GV$MAX_ACTIVE_SESS_TARGET_MTH;

Name Null? Type

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

INST_ID NUMBER

NAME VARCHAR2(40)

GV$METRIC: Synonym for GV_$METRIC

iSelfSchooling-SQL> desc GV$METRIC;

Name Null? Type

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

INST_ID NUMBER

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

GROUP_ID NUMBER

ENTITY_ID NUMBER

ENTITY_SEQUENCE NUMBER

METRIC_ID NUMBER

METRIC_NAME VARCHAR2(64)

VALUE NUMBER

METRIC_UNIT VARCHAR2(64)

GV$METRICGROUP: Synonym for GV_$METRICGROUP

iSelfSchooling-SQL> desc GV$METRICGROUP;

Name Null? Type

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

INST_ID NUMBER

GROUP_ID NUMBER

NAME VARCHAR2(64)

INTERVAL_SIZE NUMBER

MAX_INTERVAL NUMBER

GV$METRICNAME: Synonym for GV_$METRICNAME

iSelfSchooling-SQL> desc GV$METRICNAME;

Name Null? Type

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

INST_ID NUMBER

GROUP_ID NUMBER

GROUP_NAME VARCHAR2(64)

METRIC_ID NUMBER

METRIC_NAME VARCHAR2(64)

METRIC_UNIT VARCHAR2(64)

GV$METRIC_HISTORY: Synonym for GV_$METRIC_HISTORY

iSelfSchooling-SQL> desc GV$METRIC_HISTORY;

Name Null? Type

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

INST_ID NUMBER

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

GROUP_ID NUMBER

ENTITY_ID NUMBER

ENTITY_SEQUENCE NUMBER

METRIC_ID NUMBER

METRIC_NAME VARCHAR2(64)

VALUE NUMBER

METRIC_UNIT VARCHAR2(64)

GV$MTTR_TARGET_ADVICE: Synonym for GV_$MTTR_TARGET_ADVICE

iSelfSchooling-SQL> desc GV$MTTR_TARGET_ADVICE;

Name Null? Type

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

INST_ID NUMBER

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

GV$MUTEX_SLEEP: Synonym for GV_$MUTEX_SLEEP

iSelfSchooling-SQL> desc GV$MUTEX_SLEEP;

Name Null? Type

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

INST_ID NUMBER

MUTEX_TYPE VARCHAR2(32)

LOCATION VARCHAR2(40)

SLEEPS NUMBER

WAIT_TIME NUMBER

GV$MUTEX_SLEEP_HISTORY: Synonym for GV_$MUTEX_SLEEP_HISTORY

iSelfSchooling-SQL> desc GV$MUTEX_SLEEP_HISTORY;

Name Null? Type

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

INST_ID NUMBER

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)

GV$MVREFRESH: Synonym for GV_$MVREFRESH

iSelfSchooling-SQL> desc GV$MVREFRESH;

Name Null? Type

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

INST_ID NUMBER

SID NUMBER

SERIAL# NUMBER

CURRMVOWNER VARCHAR2(31)

CURRMVNAME VARCHAR2(31)

GV$MYSTAT: Synonym for GV_$MYSTAT

iSelfSchooling-SQL> desc GV$MYSTAT;

Name Null? Type

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

INST_ID NUMBER

SID NUMBER

STATISTIC# NUMBER

VALUE NUMBER

GV$NLS_PARAMETERS: Synonym for GV_$NLS_PARAMETERS

iSelfSchooling-SQL> desc GV$NLS_PARAMETERS;

Name Null? Type

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

INST_ID NUMBER

PARAMETER VARCHAR2(64)

VALUE VARCHAR2(64)

GV$NLS_VALID_VALUES: Synonym for GV_$NLS_VALID_VALUES

iSelfSchooling-SQL> desc GV$NLS_VALID_VALUES;

Name Null? Type

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

INST_ID NUMBER

PARAMETER VARCHAR2(64)

VALUE VARCHAR2(64)

ISDEPRECATED VARCHAR2(5)

GV$OBJECT_DEPENDENCY: Synonym for GV_$OBJECT_DEPENDENCY

iSelfSchooling-SQL> desc GV$OBJECT_DEPENDENCY;

Name Null? Type

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

INST_ID NUMBER

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

GV$OBSOLETE_PARAMETER: Synonym for GV_$OBSOLETE_PARAMETER

iSelfSchooling-SQL> desc GV$OBSOLETE_PARAMETER;

Name Null? Type

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

INST_ID NUMBER

NAME VARCHAR2(64)

ISSPECIFIED VARCHAR2(5)

GV$OFFLINE_RANGE: Synonym for GV_$OFFLINE_RANGE

iSelfSchooling-SQL> desc GV$OFFLINE_RANGE;

Name Null? Type

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

INST_ID NUMBER

RECID NUMBER

STAMP NUMBER

FILE# NUMBER

OFFLINE_CHANGE# NUMBER

ONLINE_CHANGE# NUMBER

ONLINE_TIME DATE

RESETLOGS_CHANGE# NUMBER

RESETLOGS_TIME DATE

GV$OPEN_CURSOR: Synonym for GV_$OPEN_CURSOR

iSelfSchooling-SQL> desc GV$OPEN_CURSOR;

Name Null? Type

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

INST_ID NUMBER

SADDR RAW(8)

SID NUMBER

USER_NAME VARCHAR2(30)

ADDRESS RAW(8)

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

SQL_TEXT VARCHAR2(60)

GV$OPTION: Synonym for GV_$OPTION

iSelfSchooling-SQL> desc GV$OPTION;

Name Null? Type

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

INST_ID NUMBER

PARAMETER VARCHAR2(64)

VALUE VARCHAR2(64)

GV$OSSTAT: Synonym for GV_$OSSTAT

iSelfSchooling-SQL> desc GV$OSSTAT;

Name Null? Type

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

INST_ID NUMBER

STAT_NAME VARCHAR2(64)

VALUE NUMBER

OSSTAT_ID NUMBER

GV$PARALLEL_DEGREE_LIMIT_MTH: Synonym for GV_$PARALLEL_DEGREE_LIMIT_MTH

iSelfSchooling-SQL> desc GV$PARALLEL_DEGREE_LIMIT_MTH;

Name Null? Type

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

INST_ID NUMBER

NAME VARCHAR2(40)

GV$PARAMETER: Synonym for GV_$PARAMETER

iSelfSchooling-SQL> desc GV$PARAMETER;

Name Null? Type

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

INST_ID NUMBER

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

GV$PARAMETER2: Synonym for GV_$PARAMETER2

iSelfSchooling-SQL> desc GV$PARAMETER2;

Name Null? Type

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

INST_ID NUMBER

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)

GV$PARAMETER_VALID_VALUES: Synonym for GV_$PARAMETER_VALID_VALUES

iSelfSchooling-SQL> desc GV$PARAMETER_VALID_VALUES;

Name Null? Type

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

INST_ID NUMBER

NUM NUMBER

NAME VARCHAR2(64)

ORDINAL NUMBER

VALUE VARCHAR2(255)

ISDEFAULT VARCHAR2(64)