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

iSelfSchooling-SQL> desc V$SEGMENT_STATISTICS;

Name Null? Type

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

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

V$SEGSTAT: Synonym for V_$SEGSTAT

iSelfSchooling-SQL> desc V$SEGSTAT;

Name Null? Type

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

TS# NUMBER

OBJ# NUMBER

DATAOBJ# NUMBER

STATISTIC_NAME VARCHAR2(64)

STATISTIC# NUMBER

VALUE NUMBER

V$SEGSTAT_NAME: Synonym for V_$SEGSTAT_NAME

iSelfSchooling-SQL> desc V$SEGSTAT_NAME;

Name Null? Type

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

STATISTIC# NUMBER

NAME VARCHAR2(64)

SAMPLED VARCHAR2(3)

V$SERVICEMETRIC: Synonym for V_$SERVICEMETRIC

iSelfSchooling-SQL> desc V$SERVICEMETRIC;

Name Null? Type

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

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

V$SERVICEMETRIC_HISTORY: Synonym for V_$SERVICEMETRIC_HISTORY

iSelfSchooling-SQL> desc V$SERVICEMETRIC_HISTORY;

Name Null? Type

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

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

V$SERVICES: Synonym for V_$SERVICES

iSelfSchooling-SQL> desc V$SERVICES;

Name Null? Type

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

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)

V$SERVICE_EVENT: Synonym for V_$SERVICE_EVENT

iSelfSchooling-SQL> desc V$SERVICE_EVENT;

Name Null? Type

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

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

V$SERVICE_STATS: Synonym for V_$SERVICE_STATS

iSelfSchooling-SQL> desc V$SERVICE_STATS;

Name Null? Type

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

SERVICE_NAME_HASH NUMBER

SERVICE_NAME VARCHAR2(64)

STAT_ID NUMBER

STAT_NAME VARCHAR2(64)

VALUE NUMBER

V$SERVICE_WAIT_CLASS: Synonym for V_$SERVICE_WAIT_CLASS

iSelfSchooling-SQL> desc V$SERVICE_WAIT_CLASS;

Name Null? Type

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

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

V$SERV_MOD_ACT_STATS: Synonym for V_$SERV_MOD_ACT_STATS

iSelfSchooling-SQL> desc V$SERV_MOD_ACT_STATS;

Name Null? Type

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

AGGREGATION_TYPE VARCHAR2(21)

SERVICE_NAME VARCHAR2(64)

MODULE VARCHAR2(49)

ACTION VARCHAR2(33)

STAT_ID NUMBER

STAT_NAME VARCHAR2(64)

VALUE NUMBER

V$SESSION: Synonym for V_$SESSION

iSelfSchooling-SQL> desc V$SESSION;

Name Null? Type

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

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)

V$SESSION_CONNECT_INFO: Synonym for V_$SESSION_CONNECT_INFO

iSelfSchooling-SQL> desc V$SESSION_CONNECT_INFO;

Name Null? Type

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

SID NUMBER

AUTHENTICATION_TYPE VARCHAR2(26)

OSUSER VARCHAR2(30)

NETWORK_SERVICE_BANNER VARCHAR2(4000)

V$SESSION_CURSOR_CACHE: Synonym for V_$SESSION_CURSOR_CACHE

iSelfSchooling-SQL> desc V$SESSION_CURSOR_CACHE;

Name Null? Type

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

MAXIMUM NUMBER

COUNT NUMBER

OPENED_ONCE NUMBER

OPEN NUMBER

OPENS NUMBER

HITS NUMBER

HIT_RATIO NUMBER

V$SESSION_EVENT: Synonym for V_$SESSION_EVENT

iSelfSchooling-SQL> desc V$SESSION_EVENT;

Name Null? Type

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

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)

V$SESSION_LONGOPS: Synonym for V_$SESSION_LONGOPS

iSelfSchooling-SQL> desc V$SESSION_LONGOPS;

Name Null? Type

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

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

V$SESSION_OBJECT_CACHE: Synonym for V_$SESSION_OBJECT_CACHE

iSelfSchooling-SQL> desc V$SESSION_OBJECT_CACHE;

Name Null? Type

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

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

V$SESSION_WAIT: Synonym for V_$SESSION_WAIT

iSelfSchooling-SQL> desc V$SESSION_WAIT;

Name Null? Type

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

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)

V$SESSION_WAIT_CLASS: Synonym for V_$SESSION_WAIT_CLASS

iSelfSchooling-SQL> desc V$SESSION_WAIT_CLASS;

Name Null? Type

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

SID NUMBER

SERIAL# NUMBER

WAIT_CLASS_ID NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS VARCHAR2(64)

TOTAL_WAITS NUMBER

TIME_WAITED NUMBER

V$SESSION_WAIT_HISTORY: Synonym for V_$SESSION_WAIT_HISTORY

iSelfSchooling-SQL> desc V$SESSION_WAIT_HISTORY;

Name Null? Type

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

SID NUMBER

SEQ# NUMBER

EVENT# NUMBER

EVENT VARCHAR2(64)

P1TEXT VARCHAR2(64)

P1 NUMBER

P2TEXT VARCHAR2(64)

P2 NUMBER

P3TEXT VARCHAR2(64)

P3 NUMBER

WAIT_TIME NUMBER

WAIT_COUNT NUMBER

V$SESSMETRIC: Synonym for V_$SESSMETRIC

iSelfSchooling-SQL> desc V$SESSMETRIC;

Name Null? Type

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

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

SESSION_ID NUMBER

SESSION_SERIAL_NUM NUMBER

CPU NUMBER

PHYSICAL_READS NUMBER

LOGICAL_READS NUMBER

PGA_MEMORY NUMBER

HARD_PARSES NUMBER

SOFT_PARSES NUMBER

PHYSICAL_READ_PCT NUMBER

LOGICAL_READ_PCT NUMBER

V$SESSTAT: Synonym for V_$SESSTAT

iSelfSchooling-SQL> desc V$SESSTAT;

Name Null? Type

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

SID NUMBER

STATISTIC# NUMBER

VALUE NUMBER

V$SESS_IO: Synonym for V_$SESS_IO

iSelfSchooling-SQL> desc V$SESS_IO;

Name Null? Type

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

SID NUMBER

BLOCK_GETS NUMBER

CONSISTENT_GETS NUMBER

PHYSICAL_READS NUMBER

BLOCK_CHANGES NUMBER

CONSISTENT_CHANGES NUMBER

V$SESS_TIME_MODEL: Synonym for V_$SESS_TIME_MODEL

iSelfSchooling-SQL> desc V$SESS_TIME_MODEL;

Name Null? Type

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

SID NUMBER

STAT_ID NUMBER

STAT_NAME VARCHAR2(64)

VALUE NUMBER

V$SES_OPTIMIZER_ENV: Synonym for V_$SES_OPTIMIZER_ENV

iSelfSchooling-SQL> desc V$SES_OPTIMIZER_ENV;

Name Null? Type

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

SID NUMBER

ID NUMBER

NAME VARCHAR2(40)

ISDEFAULT VARCHAR2(3)

VALUE VARCHAR2(25)

V$SGA: Synonym for V_$SGA

iSelfSchooling-SQL> desc V$SGA;

Name Null? Type

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

NAME VARCHAR2(20)

VALUE NUMBER

V$SGAINFO: Synonym for V_$SGAINFO

iSelfSchooling-SQL> desc V$SGAINFO;

Name Null? Type

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

NAME VARCHAR2(32)

BYTES NUMBER

RESIZEABLE VARCHAR2(3)

V$SGASTAT: Synonym for V_$SGASTAT

iSelfSchooling-SQL> desc V$SGASTAT;

Name Null? Type

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

POOL VARCHAR2(12)

NAME VARCHAR2(26)

BYTES NUMBER

V$SGA_CURRENT_RESIZE_OPS: Synonym for V_$SGA_CURRENT_RESIZE_OPS

iSelfSchooling-SQL> desc V$SGA_CURRENT_RESIZE_OPS;

Name Null? Type

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

COMPONENT VARCHAR2(64)

OPER_TYPE VARCHAR2(13)

OPER_MODE VARCHAR2(9)

PARAMETER VARCHAR2(80)

INITIAL_SIZE NUMBER

TARGET_SIZE NUMBER

CURRENT_SIZE NUMBER

START_TIME DATE

LAST_UPDATE_TIME DATE

V$SGA_DYNAMIC_COMPONENTS: Synonym for V_$SGA_DYNAMIC_COMPONENTS

iSelfSchooling-SQL> desc V$SGA_DYNAMIC_COMPONENTS;

Name Null? Type

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

COMPONENT VARCHAR2(64)

CURRENT_SIZE NUMBER

MIN_SIZE NUMBER

MAX_SIZE NUMBER

USER_SPECIFIED_SIZE NUMBER

OPER_COUNT NUMBER

LAST_OPER_TYPE VARCHAR2(13)

LAST_OPER_MODE VARCHAR2(9)

LAST_OPER_TIME DATE

GRANULE_SIZE NUMBER

V$SGA_DYNAMIC_FREE_MEMORY: Synonym for V_$SGA_DYNAMIC_FREE_MEMORY

iSelfSchooling-SQL> desc V$SGA_DYNAMIC_FREE_MEMORY;

Name Null? Type

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

CURRENT_SIZE NUMBER

V$SGA_RESIZE_OPS: Synonym for V_$SGA_RESIZE_OPS

iSelfSchooling-SQL> desc V$SGA_RESIZE_OPS;

Name Null? Type

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

COMPONENT VARCHAR2(64)

OPER_TYPE VARCHAR2(13)

OPER_MODE VARCHAR2(9)

PARAMETER VARCHAR2(80)

INITIAL_SIZE NUMBER

TARGET_SIZE NUMBER

FINAL_SIZE NUMBER

STATUS VARCHAR2(9)

START_TIME DATE

END_TIME DATE

V$SGA_TARGET_ADVICE: Synonym for V_$SGA_TARGET_ADVICE

iSelfSchooling-SQL> desc V$SGA_TARGET_ADVICE;

Name Null? Type

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

SGA_SIZE NUMBER

SGA_SIZE_FACTOR NUMBER

ESTD_DB_TIME NUMBER

ESTD_DB_TIME_FACTOR NUMBER

ESTD_PHYSICAL_READS NUMBER

V$SHARED_POOL_ADVICE: Synonym for V_$SHARED_POOL_ADVICE

iSelfSchooling-SQL> desc V$SHARED_POOL_ADVICE;

Name Null? Type

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

SHARED_POOL_SIZE_FOR_ESTIMATE NUMBER

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

iSelfSchooling-SQL> desc V$SHARED_POOL_RESERVED;

Name Null? Type

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

FREE_SPACE NUMBER

AVG_FREE_SIZE NUMBER

FREE_COUNT NUMBER

MAX_FREE_SIZE NUMBER

USED_SPACE NUMBER

AVG_USED_SIZE NUMBER

USED_COUNT NUMBER

MAX_USED_SIZE NUMBER

REQUESTS NUMBER

REQUEST_MISSES NUMBER

LAST_MISS_SIZE NUMBER

MAX_MISS_SIZE NUMBER

REQUEST_FAILURES NUMBER

LAST_FAILURE_SIZE NUMBER

ABORTED_REQUEST_THRESHOLD NUMBER

ABORTED_REQUESTS NUMBER

LAST_ABORTED_SIZE NUMBER

V$SHARED_SERVER: Synonym for V_$SHARED_SERVER

iSelfSchooling-SQL> desc V$SHARED_SERVER;

Name Null? Type

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

NAME VARCHAR2(4)

PADDR RAW(8)

STATUS VARCHAR2(16)

MESSAGES NUMBER

BYTES NUMBER

BREAKS NUMBER

CIRCUIT RAW(8)

IDLE NUMBER

BUSY NUMBER

REQUESTS NUMBER

V$SHARED_SERVER_MONITOR: Synonym for V_$SHARED_SERVER_MONITOR

iSelfSchooling-SQL> desc V$SHARED_SERVER_MONITOR;

Name Null? Type

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

MAXIMUM_CONNECTIONS NUMBER

MAXIMUM_SESSIONS NUMBER

SERVERS_STARTED NUMBER

SERVERS_TERMINATED NUMBER

SERVERS_HIGHWATER NUMBER

V$SORT_SEGMENT: Synonym for V_$SORT_SEGMENT

iSelfSchooling-SQL> desc V$SORT_SEGMENT;

Name Null? Type

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

TABLESPACE_NAME VARCHAR2(31)

SEGMENT_FILE NUMBER

SEGMENT_BLOCK NUMBER

EXTENT_SIZE NUMBER

CURRENT_USERS NUMBER

TOTAL_EXTENTS NUMBER

TOTAL_BLOCKS NUMBER

USED_EXTENTS NUMBER

USED_BLOCKS NUMBER

FREE_EXTENTS NUMBER

FREE_BLOCKS NUMBER

ADDED_EXTENTS NUMBER

EXTENT_HITS NUMBER

FREED_EXTENTS NUMBER

FREE_REQUESTS NUMBER

MAX_SIZE NUMBER

MAX_BLOCKS NUMBER

MAX_USED_SIZE NUMBER

MAX_USED_BLOCKS NUMBER

MAX_SORT_SIZE NUMBER

MAX_SORT_BLOCKS NUMBER

RELATIVE_FNO NUMBER