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

iSelfSchooling-SQL> desc GV$ENQUEUE_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$ENQUEUE_STAT: Synonym for GV_$ENQUEUE_STAT

iSelfSchooling-SQL> desc GV$ENQUEUE_STAT;

Name Null? Type

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

INST_ID NUMBER

EQ_TYPE VARCHAR2(2)

TOTAL_REQ# NUMBER

TOTAL_WAIT# NUMBER

SUCC_REQ# NUMBER

FAILED_REQ# NUMBER

CUM_WAIT_TIME NUMBER

GV$ENQUEUE_STATISTICS: Synonym for GV_$ENQUEUE_STATISTICS

iSelfSchooling-SQL> desc GV$ENQUEUE_STATISTICS;

Name Null? Type

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

INST_ID NUMBER

EQ_NAME VARCHAR2(64)

EQ_TYPE VARCHAR2(2)

REQ_REASON VARCHAR2(64)

TOTAL_REQ# NUMBER

TOTAL_WAIT# NUMBER

SUCC_REQ# NUMBER

FAILED_REQ# NUMBER

CUM_WAIT_TIME NUMBER

REQ_DESCRIPTION VARCHAR2(4000)

EVENT# NUMBER

GV$EVENTMETRIC: Synonym for GV_$EVENTMETRIC

iSelfSchooling-SQL> desc GV$EVENTMETRIC;

Name Null? Type

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

INST_ID NUMBER

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

EVENT# NUMBER

EVENT_ID NUMBER

NUM_SESS_WAITING NUMBER

TIME_WAITED NUMBER

WAIT_COUNT NUMBER

GV$EVENT_HISTOGRAM: Synonym for GV_$EVENT_HISTOGRAM

iSelfSchooling-SQL> desc GV$EVENT_HISTOGRAM;

Name Null? Type

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

INST_ID NUMBER

EVENT# NUMBER

EVENT VARCHAR2(64)

WAIT_TIME_MILLI NUMBER

WAIT_COUNT NUMBER

GV$EVENT_NAME: Synonym for GV_$EVENT_NAME

iSelfSchooling-SQL> desc GV$EVENT_NAME;

Name Null? Type

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

INST_ID NUMBER

EVENT# NUMBER

EVENT_ID NUMBER

NAME VARCHAR2(64)

PARAMETER1 VARCHAR2(64)

PARAMETER2 VARCHAR2(64)

PARAMETER3 VARCHAR2(64)

WAIT_CLASS_ID NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS VARCHAR2(64)

GV$EXECUTION: Synonym for GV_$EXECUTION

iSelfSchooling-SQL> desc GV$EXECUTION;

Name Null? Type

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

INST_ID NUMBER

PID NUMBER

DEPTH NUMBER

FUNCTION VARCHAR2(10)

TYPE VARCHAR2(7)

NVALS NUMBER

VAL1 NUMBER

VAL2 NUMBER

SEQH NUMBER

SEQL NUMBER

GV$FAST_START_SERVERS: Synonym for GV_$FAST_START_SERVERS

iSelfSchooling-SQL> desc GV$FAST_START_SERVERS;

Name Null? Type

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

INST_ID NUMBER

STATE VARCHAR2(11)

UNDOBLOCKSDONE NUMBER

PID NUMBER

XID RAW(8)

GV$FAST_START_TRANSACTIONS: Synonym for GV_$FAST_START_TRANSACTIONS

iSelfSchooling-SQL> desc GV$FAST_START_TRANSACTIONS;

Name Null? Type

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

INST_ID NUMBER

USN NUMBER

SLT NUMBER

SEQ NUMBER

STATE VARCHAR2(16)

UNDOBLOCKSDONE NUMBER

UNDOBLOCKSTOTAL NUMBER

PID NUMBER

CPUTIME NUMBER

PARENTUSN NUMBER

PARENTSLT NUMBER

PARENTSEQ NUMBER

XID RAW(8)

PXID RAW(8)

RCVSERVERS NUMBER

GV$FILEMETRIC: Synonym for GV_$FILEMETRIC

iSelfSchooling-SQL> desc GV$FILEMETRIC;

Name Null? Type

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

INST_ID NUMBER

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

FILE_ID NUMBER

CREATION_TIME NUMBER

AVERAGE_READ_TIME NUMBER

AVERAGE_WRITE_TIME NUMBER

PHYSICAL_READS NUMBER

PHYSICAL_WRITES NUMBER

PHYSICAL_BLOCK_READS NUMBER

PHYSICAL_BLOCK_WRITES NUMBER

GV$FILEMETRIC_HISTORY: Synonym for GV_$FILEMETRIC_HISTORY

iSelfSchooling-SQL> desc GV$FILEMETRIC_HISTORY;

Name Null? Type

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

INST_ID NUMBER

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

FILE_ID NUMBER

CREATION_TIME NUMBER

AVERAGE_READ_TIME NUMBER

AVERAGE_WRITE_TIME NUMBER

PHYSICAL_READS NUMBER

PHYSICAL_WRITES NUMBER

PHYSICAL_BLOCK_READS NUMBER

PHYSICAL_BLOCK_WRITES NUMBER

GV$FILESPACE_USAGE: Synonym for GV_$FILESPACE_USAGE

iSelfSchooling-SQL> desc GV$FILESPACE_USAGE;

Name Null? Type

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

INST_ID NUMBER

TABLESPACE_ID NUMBER

RFNO NUMBER

ALLOCATED_SPACE NUMBER

FILE_SIZE NUMBER

FILE_MAXSIZE NUMBER

CHANGESCN_BASE NUMBER

CHANGESCN_WRAP NUMBER

FLAG NUMBER

GV$FILESTAT: Synonym for GV_$FILESTAT

iSelfSchooling-SQL> desc GV$FILESTAT;

Name Null? Type

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

INST_ID NUMBER

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

GV$FILE_CACHE_TRANSFER: Synonym for GV_$FILE_CACHE_TRANSFER

iSelfSchooling-SQL> desc GV$FILE_CACHE_TRANSFER;

Name Null? Type

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

INST_ID NUMBER

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

RBR_FORCED_STALE NUMBER

NULL_2_X NUMBER

S_2_X NUMBER

NULL_2_S NUMBER

CR_TRANSFERS NUMBER

CUR_TRANSFERS NUMBER

GV$FILE_HISTOGRAM: Synonym for GV_$FILE_HISTOGRAM

iSelfSchooling-SQL> desc GV$FILE_HISTOGRAM;

Name Null? Type

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

INST_ID NUMBER

FILE# NUMBER

SINGLEBLKRDTIM_MILLI NUMBER

SINGLEBLKRDS NUMBER

GV$FILE_PING: Synonym for GV_$FILE_PING

iSelfSchooling-SQL> desc GV$FILE_PING;

Name Null? Type

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

INST_ID NUMBER

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

GV$FIXED_TABLE: Synonym for GV_$FIXED_TABLE

iSelfSchooling-SQL> desc GV$FIXED_TABLE;

Name Null? Type

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

INST_ID NUMBER

NAME VARCHAR2(30)

OBJECT_ID NUMBER

TYPE VARCHAR2(5)

TABLE_NUM NUMBER

GV$FIXED_VIEW_DEFINITION: Synonym for GV_$FIXED_VIEW_DEFINITION

iSelfSchooling-SQL> desc GV$FIXED_VIEW_DEFINITION;

Name Null? Type

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

INST_ID NUMBER

VIEW_NAME VARCHAR2(30)

VIEW_DEFINITION VARCHAR2(4000)

GV$FLASHBACK_DATABASE_LOG: Synonym for GV_$FLASHBACK_DATABASE_LOG

iSelfSchooling-SQL> desc GV$FLASHBACK_DATABASE_LOG;

Name Null? Type

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

INST_ID NUMBER

OLDEST_FLASHBACK_SCN NUMBER

OLDEST_FLASHBACK_TIME DATE

RETENTION_TARGET NUMBER

FLASHBACK_SIZE NUMBER

ESTIMATED_FLASHBACK_SIZE NUMBER

GV$FLASHBACK_DATABASE_LOGFILE: Synonym for GV_$FLASHBACK_DATABASE_LOGFILE

iSelfSchooling-SQL> desc GV$FLASHBACK_DATABASE_LOGFILE;

Name Null? Type

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

INST_ID NUMBER

NAME VARCHAR2(513)

LOG# NUMBER

THREAD# NUMBER

SEQUENCE# NUMBER

BYTES NUMBER

FIRST_CHANGE# NUMBER

FIRST_TIME DATE

GV$FLASHBACK_DATABASE_STAT: Synonym for GV_$FLASHBACK_DATABASE_STAT

iSelfSchooling-SQL> desc GV$FLASHBACK_DATABASE_STAT;

Name Null? Type

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

INST_ID NUMBER

BEGIN_TIME DATE

END_TIME DATE

FLASHBACK_DATA NUMBER

DB_DATA NUMBER

REDO_DATA NUMBER

ESTIMATED_FLASHBACK_SIZE NUMBER

GV$GCSHVMASTER_INFO: Synonym for GV_$GCSHVMASTER_INFO

iSelfSchooling-SQL> desc GV$GCSHVMASTER_INFO;

Name Null? Type

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

INST_ID NUMBER

HV_ID NUMBER

CURRENT_MASTER NUMBER

PREVIOUS_MASTER NUMBER

REMASTER_CNT NUMBER

GV$GCSPFMASTER_INFO: Synonym for GV_$GCSPFMASTER_INFO

iSelfSchooling-SQL> desc GV$GCSPFMASTER_INFO;

Name Null? Type

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

INST_ID NUMBER

FILE_ID NUMBER

OBJECT_ID NUMBER

CURRENT_MASTER NUMBER

PREVIOUS_MASTER NUMBER

REMASTER_CNT NUMBER

GV$GC_ELEMENT: Synonym for GV_$GC_ELEMENT

iSelfSchooling-SQL> desc GV$GC_ELEMENT;

Name Null? Type

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

INST_ID NUMBER

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

GV$GC_ELEMENTS_WITH_COLLISIONS: Synonym for GV_$GC_ELEMENTS_W_COLLISIONS

iSelfSchooling-SQL> desc GV$GC_ELEMENTS_WITH_COLLISIONS;

Name Null? Type

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

INST_ID NUMBER

GC_ELEMENT_ADDR RAW(8)

GV$GES_BLOCKING_ENQUEUE: Synonym for GV_$GES_BLOCKING_ENQUEUE

iSelfSchooling-SQL> desc GV$GES_BLOCKING_ENQUEUE;

Name Null? Type

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

INST_ID NUMBER

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

GV$GES_ENQUEUE: Synonym for GV_$GES_ENQUEUE

iSelfSchooling-SQL> desc GV$GES_ENQUEUE;

Name Null? Type

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

INST_ID NUMBER

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

GV$GLOBALCONTEXT: Synonym for GV_$GLOBALCONTEXT

iSelfSchooling-SQL> desc GV$GLOBALCONTEXT;

Name Null? Type

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

NAMESPACE VARCHAR2(31)

ATTRIBUTE VARCHAR2(31)

VALUE VARCHAR2(4000)

USERNAME VARCHAR2(31)

CLIENTIDENTIFIER VARCHAR2(65)

GV$GLOBAL_BLOCKED_LOCKS: Synonym for GV_$GLOBAL_BLOCKED_LOCKS

iSelfSchooling-SQL> desc GV$GLOBAL_BLOCKED_LOCKS;

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

GV$GLOBAL_TRANSACTION: Synonym for GV_$GLOBAL_TRANSACTION

iSelfSchooling-SQL> desc GV$GLOBAL_TRANSACTION;

Name Null? Type

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

INST_ID NUMBER

FORMATID NUMBER

GLOBALID RAW(64)

BRANCHID RAW(64)

BRANCHES NUMBER

REFCOUNT NUMBER

PREPARECOUNT NUMBER

STATE VARCHAR2(18)

FLAGS NUMBER

COUPLING VARCHAR2(15)

GV$HS_AGENT: Synonym for GV_$HS_AGENT

iSelfSchooling-SQL> desc GV$HS_AGENT;

Name Null? Type

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

INST_ID NUMBER

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

GV$HS_PARAMETER: Synonym for GV_$HS_PARAMETER

iSelfSchooling-SQL> desc GV$HS_PARAMETER;

Name Null? Type

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

INST_ID NUMBER

HS_SESSION_ID NUMBER

PARAMETER VARCHAR2(30)

VALUE VARCHAR2(64)

SOURCE VARCHAR2(1)

ENV VARCHAR2(1)

GV$HS_SESSION: Synonym for GV_$HS_SESSION

iSelfSchooling-SQL> desc GV$HS_SESSION;

Name Null? Type

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

INST_ID NUMBER

HS_SESSION_ID NUMBER

AGENT_ID NUMBER

SID NUMBER

DB_LINK VARCHAR2(128)

DB_LINK_OWNER NUMBER

STARTTIME DATE

GV$HVMASTER_INFO: Synonym for GV_$HVMASTER_INFO

iSelfSchooling-SQL> desc GV$HVMASTER_INFO;

Name Null? Type

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

INST_ID NUMBER

HV_ID NUMBER

CURRENT_MASTER NUMBER

PREVIOUS_MASTER NUMBER

REMASTER_CNT NUMBER

GV$INDEXED_FIXED_COLUMN: Synonym for GV_$INDEXED_FIXED_COLUMN

iSelfSchooling-SQL> desc GV$INDEXED_FIXED_COLUMN;

Name Null? Type

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

INST_ID NUMBER

TABLE_NAME VARCHAR2(30)

INDEX_NUMBER NUMBER

COLUMN_NAME VARCHAR2(30)

COLUMN_POSITION NUMBER

GV$INSTANCE: Synonym for GV_$INSTANCE

iSelfSchooling-SQL> desc GV$INSTANCE;

Name Null? Type

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

INST_ID NUMBER

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)

GV$INSTANCE_CACHE_TRANSFER: Synonym for GV_$INSTANCE_CACHE_TRANSFER

iSelfSchooling-SQL> desc GV$INSTANCE_CACHE_TRANSFER;

Name Null? Type

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

INST_ID NUMBER

INSTANCE NUMBER

CLASS VARCHAR2(18)

CR_BLOCK NUMBER

CR_BUSY NUMBER

CR_CONGESTED NUMBER

CURRENT_BLOCK NUMBER

CURRENT_BUSY NUMBER

CURRENT_CONGESTED NUMBER

GV$INSTANCE_LOG_GROUP: Synonym for GV_$INSTANCE_LOG_GROUP

iSelfSchooling-SQL> desc GV$INSTANCE_LOG_GROUP;

Name Null? Type

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

INST_ID NUMBER

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