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

iSelfSchooling-SQL> desc GV$ROWCACHE;

Name Null? Type

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

INST_ID NUMBER

CACHE# NUMBER

TYPE VARCHAR2(11)

SUBORDINATE# NUMBER

PARAMETER VARCHAR2(32)

COUNT NUMBER

USAGE NUMBER

FIXED NUMBER

GETS NUMBER

GETMISSES NUMBER

SCANS NUMBER

SCANMISSES NUMBER

SCANCOMPLETES NUMBER

MODIFICATIONS NUMBER

FLUSHES NUMBER

DLM_REQUESTS NUMBER

DLM_CONFLICTS NUMBER

DLM_RELEASES NUMBER

GV$ROWCACHE_PARENT: Synonym for GV_$ROWCACHE_PARENT

iSelfSchooling-SQL> desc GV$ROWCACHE_PARENT;

Name Null? Type

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

INST_ID NUMBER

INDX NUMBER

HASH NUMBER

ADDRESS RAW(8)

CACHE# NUMBER

CACHE_NAME VARCHAR2(64)

EXISTENT VARCHAR2(1)

LOCK_MODE NUMBER

LOCK_REQUEST NUMBER

TXN RAW(8)

SADDR RAW(8)

INST_LOCK_REQUEST NUMBER

INST_LOCK_RELEASE NUMBER

INST_LOCK_TYPE VARCHAR2(2)

INST_LOCK_ID1 RAW(4)

INST_LOCK_ID2 RAW(4)

KEY RAW(100)

GV$ROWCACHE_SUBORDINATE: Synonym for GV_$ROWCACHE_SUBORDINATE

iSelfSchooling-SQL> desc GV$ROWCACHE_SUBORDINATE;

Name Null? Type

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

INST_ID NUMBER

INDX NUMBER

HASH NUMBER

ADDRESS RAW(8)

CACHE# NUMBER

SUBCACHE# NUMBER

SUBCACHE_NAME VARCHAR2(64)

EXISTENT VARCHAR2(1)

PARENT RAW(8)

KEY RAW(100)

GV$RSRC_CONSUMER_GROUP: Synonym for GV_$RSRC_CONSUMER_GROUP

iSelfSchooling-SQL> desc GV$RSRC_CONSUMER_GROUP;

Name Null? Type

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

INST_ID NUMBER

NAME VARCHAR2(32)

ID NUMBER

ACTIVE_SESSIONS NUMBER

EXECUTION_WAITERS NUMBER

REQUESTS NUMBER

CPU_WAIT_TIME NUMBER

CPU_WAITS NUMBER

CONSUMED_CPU_TIME NUMBER

YIELDS NUMBER

QUEUE_LENGTH NUMBER

CURRENT_UNDO_CONSUMPTION NUMBER

ACTIVE_SESSION_LIMIT_HIT NUMBER

SESSION_SWITCHES_IN NUMBER

SESSION_SWITCHES_OUT NUMBER

UNDO_LIMIT_HIT NUMBER

SQL_CANCELED NUMBER

ACTIVE_SESSIONS_KILLED NUMBER

IDLE_SESSIONS_KILLED NUMBER

IDLE_BLKR_SESSIONS_KILLED NUMBER

QUEUED_TIME NUMBER

QUEUE_TIME_OUTS NUMBER

GV$RSRC_CONSUMER_GROUP_CPU_MTH: Synonym for GV_$RSRC_CONSUME_GROUP_CPU_MTH

iSelfSchooling-SQL> desc GV$RSRC_CONSUMER_GROUP_CPU_MTH;

Name Null? Type

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

INST_ID NUMBER

NAME VARCHAR2(40)

GV$RSRC_CONS_GROUP_HISTORY: Synonym for GV_$RSRC_CONS_GROUP_HISTORY

iSelfSchooling-SQL> desc GV$RSRC_CONS_GROUP_HISTORY;

Name Null? Type

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

INST_ID NUMBER

SEQUENCE# NUMBER

ID NUMBER

NAME VARCHAR2(30)

REQUESTS NUMBER

CPU_WAIT_TIME NUMBER

CPU_WAITS NUMBER

CONSUMED_CPU_TIME NUMBER

YIELDS NUMBER

ACTIVE_SESS_LIMIT_HIT NUMBER

UNDO_LIMIT_HIT NUMBER

SESSION_SWITCHES_IN NUMBER

SESSION_SWITCHES_OUT NUMBER

SQL_CANCELED NUMBER

ACTIVE_SESS_KILLED NUMBER

IDLE_SESS_KILLED NUMBER

IDLE_BLKR_SESS_KILLED NUMBER

QUEUED_TIME NUMBER

QUEUE_TIME_OUTS NUMBER

GV$RSRC_PLAN: Synonym for GV_$RSRC_PLAN

iSelfSchooling-SQL> desc GV$RSRC_PLAN;

Name Null? Type

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

INST_ID NUMBER

ID NUMBER

NAME VARCHAR2(32)

IS_TOP_PLAN VARCHAR2(5)

GV$RSRC_PLAN_CPU_MTH: Synonym for GV_$RSRC_PLAN_CPU_MTH

iSelfSchooling-SQL> desc GV$RSRC_PLAN_CPU_MTH;

Name Null? Type

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

INST_ID NUMBER

NAME VARCHAR2(40)

GV$RSRC_PLAN_HISTORY: Synonym for GV_$RSRC_PLAN_HISTORY

iSelfSchooling-SQL> desc GV$RSRC_PLAN_HISTORY;

Name Null? Type

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

INST_ID NUMBER

SEQUENCE# NUMBER

ID NUMBER

NAME VARCHAR2(30)

START_TIME DATE

END_TIME DATE

ENABLED_BY_SCHEDULER VARCHAR2(5)

WINDOW_NAME VARCHAR2(30)

ALLOWED_AUTOMATED_SWITCHES VARCHAR2(5)

GV$RSRC_SESSION_INFO: Synonym for GV_$RSRC_SESSION_INFO

iSelfSchooling-SQL> desc GV$RSRC_SESSION_INFO;

Name Null? Type

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

INST_ID NUMBER

SID NUMBER

CURRENT_CONSUMER_GROUP_ID VARCHAR2(40)

ORIG_CONSUMER_GROUP_ID VARCHAR2(40)

MAPPING_ATTRIBUTE VARCHAR2(32)

MAPPED_CONSUMER_GROUP VARCHAR2(32)

STATE VARCHAR2(32)

ACTIVE VARCHAR2(5)

CURRENT_IDLE_TIME NUMBER

CURRENT_CPU_WAIT_TIME NUMBER

CPU_WAIT_TIME NUMBER

CURRENT_CPU_WAITS NUMBER

CPU_WAITS NUMBER

CURRENT_CONSUMED_CPU_TIME NUMBER

CONSUMED_CPU_TIME NUMBER

CURRENT_ACTIVE_TIME NUMBER

ACTIVE_TIME NUMBER

CURRENT_QUEUED_TIME NUMBER

QUEUED_TIME NUMBER

CURRENT_YIELDS NUMBER

YIELDS NUMBER

CURRENT_UNDO_CONSUMPTION NUMBER

MAX_UNDO_CONSUMPTION NUMBER

SQL_CANCELED NUMBER

QUEUE_TIME_OUTS NUMBER

ESTIMATED_EXECUTION_LIMIT_HIT NUMBER

GV$RULE: Synonym for GV_$RULE

iSelfSchooling-SQL> desc GV$RULE;

Name Null? Type

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

INST_ID NUMBER

RULE_SET_OBJECT_ID NUMBER

EVALUATION_CONTEXT_OBJECT_ID NUMBER

RULE_OWNER VARCHAR2(30)

RULE_NAME VARCHAR2(30)

RULE_CONDITION VARCHAR2(200)

TRUE_HITS NUMBER

MAYBE_HITS NUMBER

SQL_EVALUATIONS NUMBER

GV$RULE_SET: Synonym for GV_$RULE_SET

iSelfSchooling-SQL> desc GV$RULE_SET;

Name Null? Type

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

INST_ID NUMBER

OWNER VARCHAR2(30)

NAME VARCHAR2(30)

CPU_TIME NUMBER

ELAPSED_TIME NUMBER

FIRST_LOAD_TIME DATE

LAST_LOAD_TIME DATE

LAST_LOADING_TIME NUMBER

SHARABLE_MEM NUMBER

RELOADS NUMBER

INVALIDATIONS NUMBER

EVALUATIONS NUMBER

FIRST_HIT_EVALUATIONS NUMBER

SIMPLE_RULES_ONLY_EVALUATIONS NUMBER

SQL_FREE_EVALUATIONS NUMBER

SQL_EXECUTIONS NUMBER

CONDITIONS_PROCESSED NUMBER

TRUE_RULES NUMBER

MAYBE_RULES NUMBER

VARIABLE_VALUE_FUNCTION_CALLS NUMBER

VARIABLE_METHOD_FUNCTION_CALL NUMBER

EVALUATION_FUNCTION_CALLS NUMBER

GV$RULE_SET_AGGREGATE_STATS: Synonym for GV_$RULE_SET_AGGREGATE_STATS

iSelfSchooling-SQL> desc GV$RULE_SET_AGGREGATE_STATS;

Name Null? Type

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

INST_ID NUMBER

NAME VARCHAR2(80)

VALUE NUMBER

GV$SCHEDULER_RUNNING_JOBS: Synonym for GV_$SCHEDULER_RUNNING_JOBS

iSelfSchooling-SQL> desc GV$SCHEDULER_RUNNING_JOBS;

Name Null? Type

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

INST_ID NUMBER

SESSION_ID NUMBER

SESSION_SERIAL_NUM NUMBER

JOB_ID NUMBER

PADDR RAW(8)

OS_PROCESS_ID VARCHAR2(12)

SESSION_STAT_CPU INTERVAL DAY(2)

GV$SEGMENT_STATISTICS: Synonym for GV_$SEGMENT_STATISTICS

iSelfSchooling-SQL> desc GV$SEGMENT_STATISTICS;

Name Null? Type

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

INST_ID NUMBER

OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(30)

SUBOBJECT_NAME VARCHAR2(30)

TABLESPACE_NAME VARCHAR2(30)

TS# NUMBER

OBJ# NUMBER

DATAOBJ# NUMBER

OBJECT_TYPE VARCHAR2(18)

STATISTIC_NAME VARCHAR2(64)

STATISTIC# NUMBER

VALUE NUMBER

GV$SEGSTAT: Synonym for GV_$SEGSTAT

iSelfSchooling-SQL> desc GV$SEGSTAT;

Name Null? Type

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

INST_ID NUMBER

TS# NUMBER

OBJ# NUMBER

DATAOBJ# NUMBER

STATISTIC_NAME VARCHAR2(64)

STATISTIC# NUMBER

VALUE NUMBER

GV$SEGSTAT_NAME: Synonym for GV_$SEGSTAT_NAME

iSelfSchooling-SQL> desc GV$SEGSTAT_NAME;

Name Null? Type

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

INST_ID NUMBER

STATISTIC# NUMBER

NAME VARCHAR2(64)

SAMPLED VARCHAR2(3)

GV$SERVICEMETRIC: Synonym for GV_$SERVICEMETRIC

iSelfSchooling-SQL> desc GV$SERVICEMETRIC;

Name Null? Type

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

INST_ID NUMBER

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

GROUP_ID NUMBER

SERVICE_NAME_HASH NUMBER

SERVICE_NAME VARCHAR2(64)

CTMHASH NUMBER

ELAPSEDPERCALL NUMBER

CPUPERCALL NUMBER

DBTIMEPERCALL NUMBER

CALLSPERSEC NUMBER

DBTIMEPERSEC NUMBER

GOODNESS NUMBER

DELTA NUMBER

FLAGS NUMBER

GV$SERVICEMETRIC_HISTORY: Synonym for GV_$SERVICEMETRIC_HISTORY

iSelfSchooling-SQL> desc GV$SERVICEMETRIC_HISTORY;

Name Null? Type

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

INST_ID NUMBER

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

GROUP_ID NUMBER

SERVICE_NAME_HASH NUMBER

SERVICE_NAME VARCHAR2(64)

CTMHASH NUMBER

ELAPSEDPERCALL NUMBER

CPUPERCALL NUMBER

DBTIMEPERCALL NUMBER

CALLSPERSEC NUMBER

DBTIMEPERSEC NUMBER

GV$SERVICES: Synonym for GV_$SERVICES

iSelfSchooling-SQL> desc GV$SERVICES;

Name Null? Type

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

INST_ID NUMBER

SERVICE_ID NUMBER

NAME VARCHAR2(64)

NAME_HASH NUMBER

NETWORK_NAME VARCHAR2(512)

CREATION_DATE DATE

CREATION_DATE_HASH NUMBER

GOAL VARCHAR2(12)

DTP VARCHAR2(1)

AQ_HA_NOTIFICATION VARCHAR2(3)

CLB_GOAL VARCHAR2(5)

GV$SERVICE_EVENT: Synonym for GV_$SERVICE_EVENT

iSelfSchooling-SQL> desc GV$SERVICE_EVENT;

Name Null? Type

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

INST_ID NUMBER

SERVICE_NAME VARCHAR2(64)

SERVICE_NAME_HASH NUMBER

EVENT VARCHAR2(64)

EVENT_ID NUMBER

TOTAL_WAITS NUMBER

TOTAL_TIMEOUTS NUMBER

TIME_WAITED NUMBER

AVERAGE_WAIT NUMBER

MAX_WAIT NUMBER

TIME_WAITED_MICRO NUMBER

GV$SERVICE_STATS: Synonym for GV_$SERVICE_STATS

iSelfSchooling-SQL> desc GV$SERVICE_STATS;

Name Null? Type

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

INST_ID NUMBER

SERVICE_NAME_HASH NUMBER

SERVICE_NAME VARCHAR2(64)

STAT_ID NUMBER

STAT_NAME VARCHAR2(64)

VALUE NUMBER

GV$SERVICE_WAIT_CLASS: Synonym for GV_$SERVICE_WAIT_CLASS

iSelfSchooling-SQL> desc GV$SERVICE_WAIT_CLASS;

Name Null? Type

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

INST_ID NUMBER

SERVICE_NAME VARCHAR2(64)

SERVICE_NAME_HASH NUMBER

WAIT_CLASS_ID NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS VARCHAR2(64)

TOTAL_WAITS NUMBER

TIME_WAITED NUMBER

GV$SERV_MOD_ACT_STATS: Synonym for GV_$SERV_MOD_ACT_STATS

iSelfSchooling-SQL> desc GV$SERV_MOD_ACT_STATS;

Name Null? Type

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

INST_ID NUMBER

AGGREGATION_TYPE VARCHAR2(21)

SERVICE_NAME VARCHAR2(64)

MODULE VARCHAR2(49)

ACTION VARCHAR2(33)

STAT_ID NUMBER

STAT_NAME VARCHAR2(64)

VALUE NUMBER

GV$SESSION: Synonym for GV_$SESSION

iSelfSchooling-SQL> desc GV$SESSION;

Name Null? Type

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

INST_ID NUMBER

SADDR RAW(8)

SID NUMBER

SERIAL# NUMBER

AUDSID NUMBER

PADDR RAW(8)

USER# NUMBER

USERNAME VARCHAR2(30)

COMMAND NUMBER

OWNERID NUMBER

TADDR VARCHAR2(16)

LOCKWAIT VARCHAR2(16)

STATUS VARCHAR2(8)

SERVER VARCHAR2(9)

SCHEMA# NUMBER

SCHEMANAME VARCHAR2(30)

OSUSER VARCHAR2(30)

PROCESS VARCHAR2(12)

MACHINE VARCHAR2(64)

TERMINAL VARCHAR2(30)

PROGRAM VARCHAR2(48)

TYPE VARCHAR2(10)

SQL_ADDRESS RAW(8)

SQL_HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

SQL_CHILD_NUMBER NUMBER

PREV_SQL_ADDR RAW(8)

PREV_HASH_VALUE NUMBER

PREV_SQL_ID VARCHAR2(13)

PREV_CHILD_NUMBER NUMBER

MODULE VARCHAR2(48)

MODULE_HASH NUMBER

ACTION VARCHAR2(32)

ACTION_HASH NUMBER

CLIENT_INFO VARCHAR2(64)

FIXED_TABLE_SEQUENCE NUMBER

ROW_WAIT_OBJ# NUMBER

ROW_WAIT_FILE# NUMBER

ROW_WAIT_BLOCK# NUMBER

ROW_WAIT_ROW# NUMBER

LOGON_TIME DATE

LAST_CALL_ET NUMBER

PDML_ENABLED VARCHAR2(3)

FAILOVER_TYPE VARCHAR2(13)

FAILOVER_METHOD VARCHAR2(10)

FAILED_OVER VARCHAR2(3)

RESOURCE_CONSUMER_GROUP VARCHAR2(32)

PDML_STATUS VARCHAR2(8)

PDDL_STATUS VARCHAR2(8)

PQ_STATUS VARCHAR2(8)

CURRENT_QUEUE_DURATION NUMBER

CLIENT_IDENTIFIER VARCHAR2(64)

BLOCKING_SESSION_STATUS VARCHAR2(11)

BLOCKING_INSTANCE NUMBER

BLOCKING_SESSION NUMBER

SEQ# NUMBER

EVENT# NUMBER

EVENT VARCHAR2(64)

P1TEXT VARCHAR2(64)

P1 NUMBER

P1RAW RAW(8)

P2TEXT VARCHAR2(64)

P2 NUMBER

P2RAW RAW(8)

P3TEXT VARCHAR2(64)

P3 NUMBER

P3RAW RAW(8)

WAIT_CLASS_ID NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS VARCHAR2(64)

WAIT_TIME NUMBER

SECONDS_IN_WAIT NUMBER

STATE VARCHAR2(19)

SERVICE_NAME VARCHAR2(64)

SQL_TRACE VARCHAR2(8)

SQL_TRACE_WAITS VARCHAR2(5)

SQL_TRACE_BINDS VARCHAR2(5)

GV$SESSION_CONNECT_INFO: Synonym for GV_$SESSION_CONNECT_INFO

iSelfSchooling-SQL> desc GV$SESSION_CONNECT_INFO;

Name Null? Type

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

INST_ID NUMBER

SID NUMBER

AUTHENTICATION_TYPE VARCHAR2(26)

OSUSER VARCHAR2(30)

NETWORK_SERVICE_BANNER VARCHAR2(4000)

GV$SESSION_CURSOR_CACHE: Synonym for GV_$SESSION_CURSOR_CACHE

iSelfSchooling-SQL> desc GV$SESSION_CURSOR_CACHE;

Name Null? Type

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

INST_ID NUMBER

MAXIMUM NUMBER

COUNT NUMBER

OPENED_ONCE NUMBER

OPEN NUMBER

OPENS NUMBER

HITS NUMBER

HIT_RATIO NUMBER

GV$SESSION_EVENT: Synonym for GV_$SESSION_EVENT

iSelfSchooling-SQL> desc GV$SESSION_EVENT;

Name Null? Type

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

INST_ID NUMBER

SID NUMBER

EVENT VARCHAR2(64)

TOTAL_WAITS NUMBER

TOTAL_TIMEOUTS NUMBER

TIME_WAITED NUMBER

AVERAGE_WAIT NUMBER

MAX_WAIT NUMBER

TIME_WAITED_MICRO NUMBER

EVENT_ID NUMBER

WAIT_CLASS_ID NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS VARCHAR2(64)

GV$SESSION_LONGOPS: Synonym for GV_$SESSION_LONGOPS

iSelfSchooling-SQL> desc GV$SESSION_LONGOPS;

Name Null? Type

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

INST_ID NUMBER

SID NUMBER

SERIAL# NUMBER

OPNAME VARCHAR2(64)

TARGET VARCHAR2(64)

TARGET_DESC VARCHAR2(32)

SOFAR NUMBER

TOTALWORK NUMBER

UNITS VARCHAR2(32)

START_TIME DATE

LAST_UPDATE_TIME DATE

TIMESTAMP DATE

TIME_REMAINING NUMBER

ELAPSED_SECONDS NUMBER

CONTEXT NUMBER

MESSAGE VARCHAR2(512)

USERNAME VARCHAR2(30)

SQL_ADDRESS RAW(8)

SQL_HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

QCSID NUMBER

GV$SESSION_OBJECT_CACHE: Synonym for GV_$SESSION_OBJECT_CACHE

iSelfSchooling-SQL> desc GV$SESSION_OBJECT_CACHE;

Name Null? Type

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

INST_ID NUMBER

PINS NUMBER

HITS NUMBER

TRUE_HITS NUMBER

HIT_RATIO NUMBER

TRUE_HIT_RATIO NUMBER

OBJECT_REFRESHES NUMBER

CACHE_REFRESHES NUMBER

OBJECT_FLUSHES NUMBER

CACHE_FLUSHES NUMBER

CACHE_SHRINKS NUMBER

CACHED_OBJECTS NUMBER

PINNED_OBJECTS NUMBER

CACHE_SIZE NUMBER

OPTIMAL_SIZE NUMBER

MAXIMUM_SIZE NUMBER

GV$SESSION_WAIT: Synonym for GV_$SESSION_WAIT

iSelfSchooling-SQL> desc GV$SESSION_WAIT;

Name Null? Type

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

INST_ID NUMBER

SID NUMBER

SEQ# NUMBER

EVENT VARCHAR2(64)

P1TEXT VARCHAR2(64)

P1 NUMBER

P1RAW RAW(8)

P2TEXT VARCHAR2(64)

P2 NUMBER

P2RAW RAW(8)

P3TEXT VARCHAR2(64)

P3 NUMBER

P3RAW RAW(8)

WAIT_CLASS_ID NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS VARCHAR2(64)

WAIT_TIME NUMBER

SECONDS_IN_WAIT NUMBER

STATE VARCHAR2(19)

GV$SESSION_WAIT_CLASS: Synonym for GV_$SESSION_WAIT_CLASS

iSelfSchooling-SQL> desc GV$SESSION_WAIT_CLASS;

Name Null? Type

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

INST_ID NUMBER

SID NUMBER

SERIAL# NUMBER

WAIT_CLASS_ID NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS VARCHAR2(64)

TOTAL_WAITS NUMBER

TIME_WAITED NUMBER