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

iSelfSchooling-SQL> desc V$SORT_USAGE;

Name Null? Type

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

USERNAME VARCHAR2(30)

USER VARCHAR2(30)

SESSION_ADDR RAW(8)

SESSION_NUM NUMBER

SQLADDR RAW(8)

SQLHASH NUMBER

SQL_ID VARCHAR2(13)

TABLESPACE VARCHAR2(31)

CONTENTS VARCHAR2(9)

SEGTYPE VARCHAR2(9)

SEGFILE# NUMBER

SEGBLK# NUMBER

EXTENTS NUMBER

BLOCKS NUMBER

SEGRFNO# NUMBER

V$SPPARAMETER: Synonym for V_$SPPARAMETER

iSelfSchooling-SQL> desc V$SPPARAMETER;

Name Null? Type

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

SID VARCHAR2(80)

NAME VARCHAR2(80)

VALUE VARCHAR2(255)

DISPLAY_VALUE VARCHAR2(255)

ISSPECIFIED VARCHAR2(6)

ORDINAL NUMBER

UPDATE_COMMENT VARCHAR2(255)

V$SQL: Synonym for V_$SQL

iSelfSchooling-SQL> desc V$SQL;

Name Null? Type

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

SQL_TEXT VARCHAR2(1000)

SQL_FULLTEXT CLOB

SQL_ID VARCHAR2(13)

SHARABLE_MEM NUMBER

PERSISTENT_MEM NUMBER

RUNTIME_MEM NUMBER

SORTS NUMBER

LOADED_VERSIONS NUMBER

OPEN_VERSIONS NUMBER

USERS_OPENING NUMBER

FETCHES NUMBER

EXECUTIONS NUMBER

PX_SERVERS_EXECUTIONS NUMBER

END_OF_FETCH_COUNT NUMBER

USERS_EXECUTING NUMBER

LOADS NUMBER

FIRST_LOAD_TIME VARCHAR2(19)

INVALIDATIONS NUMBER

PARSE_CALLS NUMBER

DISK_READS NUMBER

DIRECT_WRITES NUMBER

BUFFER_GETS NUMBER

APPLICATION_WAIT_TIME NUMBER

CONCURRENCY_WAIT_TIME NUMBER

CLUSTER_WAIT_TIME NUMBER

USER_IO_WAIT_TIME NUMBER

PLSQL_EXEC_TIME NUMBER

JAVA_EXEC_TIME NUMBER

ROWS_PROCESSED NUMBER

COMMAND_TYPE NUMBER

OPTIMIZER_MODE VARCHAR2(10)

OPTIMIZER_COST NUMBER

OPTIMIZER_ENV RAW(797)

OPTIMIZER_ENV_HASH_VALUE NUMBER

PARSING_USER_ID NUMBER

PARSING_SCHEMA_ID NUMBER

PARSING_SCHEMA_NAME VARCHAR2(30)

KEPT_VERSIONS NUMBER

ADDRESS RAW(8)

TYPE_CHK_HEAP RAW(8)

HASH_VALUE NUMBER

OLD_HASH_VALUE NUMBER

PLAN_HASH_VALUE NUMBER

CHILD_NUMBER NUMBER

SERVICE VARCHAR2(64)

SERVICE_HASH NUMBER

MODULE VARCHAR2(64)

MODULE_HASH NUMBER

ACTION VARCHAR2(64)

ACTION_HASH NUMBER

SERIALIZABLE_ABORTS NUMBER

OUTLINE_CATEGORY VARCHAR2(64)

CPU_TIME NUMBER

ELAPSED_TIME NUMBER

OUTLINE_SID NUMBER

CHILD_ADDRESS RAW(8)

SQLTYPE NUMBER

REMOTE VARCHAR2(1)

OBJECT_STATUS VARCHAR2(19)

LITERAL_HASH_VALUE NUMBER

LAST_LOAD_TIME VARCHAR2(19)

IS_OBSOLETE VARCHAR2(1)

CHILD_LATCH NUMBER

SQL_PROFILE VARCHAR2(64)

PROGRAM_ID NUMBER

PROGRAM_LINE# NUMBER

EXACT_MATCHING_SIGNATURE NUMBER

FORCE_MATCHING_SIGNATURE NUMBER

LAST_ACTIVE_TIME DATE

BIND_DATA RAW(2000)

V$SQLAREA: Synonym for V_$SQLAREA

iSelfSchooling-SQL> desc V$SQLAREA;

Name Null? Type

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

SQL_TEXT VARCHAR2(1000)

SQL_FULLTEXT CLOB

SQL_ID VARCHAR2(13)

SHARABLE_MEM NUMBER

PERSISTENT_MEM NUMBER

RUNTIME_MEM NUMBER

SORTS NUMBER

VERSION_COUNT NUMBER

LOADED_VERSIONS NUMBER

OPEN_VERSIONS NUMBER

USERS_OPENING NUMBER

FETCHES NUMBER

EXECUTIONS NUMBER

PX_SERVERS_EXECUTIONS NUMBER

END_OF_FETCH_COUNT NUMBER

USERS_EXECUTING NUMBER

LOADS NUMBER

FIRST_LOAD_TIME VARCHAR2(19)

INVALIDATIONS NUMBER

PARSE_CALLS NUMBER

DISK_READS NUMBER

DIRECT_WRITES NUMBER

BUFFER_GETS NUMBER

APPLICATION_WAIT_TIME NUMBER

CONCURRENCY_WAIT_TIME NUMBER

CLUSTER_WAIT_TIME NUMBER

USER_IO_WAIT_TIME NUMBER

PLSQL_EXEC_TIME NUMBER

JAVA_EXEC_TIME NUMBER

ROWS_PROCESSED NUMBER

COMMAND_TYPE NUMBER

OPTIMIZER_MODE VARCHAR2(10)

OPTIMIZER_COST NUMBER

OPTIMIZER_ENV RAW(797)

OPTIMIZER_ENV_HASH_VALUE NUMBER

PARSING_USER_ID NUMBER

PARSING_SCHEMA_ID NUMBER

PARSING_SCHEMA_NAME VARCHAR2(30)

KEPT_VERSIONS NUMBER

ADDRESS RAW(8)

HASH_VALUE NUMBER

OLD_HASH_VALUE NUMBER

PLAN_HASH_VALUE NUMBER

MODULE VARCHAR2(64)

MODULE_HASH NUMBER

ACTION VARCHAR2(64)

ACTION_HASH NUMBER

SERIALIZABLE_ABORTS NUMBER

OUTLINE_CATEGORY VARCHAR2(64)

CPU_TIME NUMBER

ELAPSED_TIME NUMBER

OUTLINE_SID VARCHAR2(40)

LAST_ACTIVE_CHILD_ADDRESS RAW(8)

REMOTE VARCHAR2(1)

OBJECT_STATUS VARCHAR2(19)

LITERAL_HASH_VALUE NUMBER

LAST_LOAD_TIME DATE

IS_OBSOLETE VARCHAR2(1)

CHILD_LATCH NUMBER

SQL_PROFILE VARCHAR2(64)

PROGRAM_ID NUMBER

PROGRAM_LINE# NUMBER

EXACT_MATCHING_SIGNATURE NUMBER

FORCE_MATCHING_SIGNATURE NUMBER

LAST_ACTIVE_TIME DATE

BIND_DATA RAW(2000)

V$SQLAREA_PLAN_HASH: Synonym for V_$SQLAREA_PLAN_HASH

iSelfSchooling-SQL> desc V$SQLAREA_PLAN_HASH;

Name Null? Type

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

SQL_TEXT VARCHAR2(1000)

SQL_FULLTEXT CLOB

ADDRESS RAW(8)

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

PLAN_HASH_VALUE NUMBER

VERSION_COUNT NUMBER

LAST_ACTIVE_CHILD_ADDRESS RAW(8)

SHARABLE_MEM NUMBER

PERSISTENT_MEM NUMBER

RUNTIME_MEM NUMBER

SORTS NUMBER

LOADED_VERSIONS NUMBER

OPEN_VERSIONS NUMBER

USERS_OPENING NUMBER

USERS_EXECUTING NUMBER

FETCHES NUMBER

EXECUTIONS NUMBER

PX_SERVERS_EXECUTIONS NUMBER

END_OF_FETCH_COUNT NUMBER

LOADS NUMBER

FIRST_LOAD_TIME DATE

LAST_LOAD_TIME DATE

LAST_ACTIVE_TIME DATE

INVALIDATIONS NUMBER

PARSE_CALLS NUMBER

DISK_READS NUMBER

DIRECT_WRITES NUMBER

BUFFER_GETS NUMBER

CPU_TIME NUMBER

ELAPSED_TIME NUMBER

APPLICATION_WAIT_TIME NUMBER

CONCURRENCY_WAIT_TIME NUMBER

CLUSTER_WAIT_TIME NUMBER

USER_IO_WAIT_TIME NUMBER

PLSQL_EXEC_TIME NUMBER

JAVA_EXEC_TIME NUMBER

ROWS_PROCESSED NUMBER

COMMAND_TYPE NUMBER

OPTIMIZER_MODE VARCHAR2(10)

OPTIMIZER_COST NUMBER

OPTIMIZER_ENV RAW(797)

OPTIMIZER_ENV_HASH_VALUE NUMBER

PARSING_USER_ID NUMBER

PARSING_SCHEMA_ID NUMBER

PARSING_SCHEMA_NAME VARCHAR2(30)

KEPT_VERSIONS NUMBER

MODULE VARCHAR2(64)

MODULE_HASH NUMBER

ACTION VARCHAR2(64)

ACTION_HASH NUMBER

SERIALIZABLE_ABORTS NUMBER

OUTLINE_CATEGORY VARCHAR2(64)

OUTLINE_SID VARCHAR2(40)

REMOTE VARCHAR2(1)

OBJECT_STATUS VARCHAR2(19)

LITERAL_HASH_VALUE NUMBER

SQL_PROFILE VARCHAR2(64)

PROGRAM_ID NUMBER

PROGRAM_LINE# NUMBER

EXACT_MATCHING_SIGNATURE NUMBER

FORCE_MATCHING_SIGNATURE NUMBER

BIND_DATA RAW(2000)

V$SQLSTATS: Synonym for V_$SQLSTATS

iSelfSchooling-SQL> desc V$SQLSTATS;

Name Null? Type

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

SQL_TEXT VARCHAR2(1000)

SQL_FULLTEXT CLOB

SQL_ID VARCHAR2(13)

LAST_ACTIVE_TIME DATE

LAST_ACTIVE_CHILD_ADDRESS RAW(8)

PLAN_HASH_VALUE NUMBER

PARSE_CALLS NUMBER

DISK_READS NUMBER

DIRECT_WRITES NUMBER

BUFFER_GETS NUMBER

ROWS_PROCESSED NUMBER

SERIALIZABLE_ABORTS NUMBER

FETCHES NUMBER

EXECUTIONS NUMBER

END_OF_FETCH_COUNT NUMBER

LOADS NUMBER

VERSION_COUNT NUMBER

INVALIDATIONS NUMBER

PX_SERVERS_EXECUTIONS NUMBER

CPU_TIME NUMBER

ELAPSED_TIME NUMBER

APPLICATION_WAIT_TIME NUMBER

CONCURRENCY_WAIT_TIME NUMBER

CLUSTER_WAIT_TIME NUMBER

USER_IO_WAIT_TIME NUMBER

PLSQL_EXEC_TIME NUMBER

JAVA_EXEC_TIME NUMBER

SORTS NUMBER

SHARABLE_MEM NUMBER

TOTAL_SHARABLE_MEM NUMBER

V$SQLTEXT: Synonym for V_$SQLTEXT

iSelfSchooling-SQL> desc V$SQLTEXT;

Name Null? Type

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

ADDRESS RAW(8)

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

COMMAND_TYPE NUMBER

PIECE NUMBER

SQL_TEXT VARCHAR2(64)

V$SQLTEXT_WITH_NEWLINES: Synonym for V_$SQLTEXT_WITH_NEWLINES

iSelfSchooling-SQL> desc V$SQLTEXT_WITH_NEWLINES;

Name Null? Type

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

ADDRESS RAW(8)

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

COMMAND_TYPE NUMBER

PIECE NUMBER

SQL_TEXT VARCHAR2(64)

V$SQL_BIND_CAPTURE: Synonym for V_$SQL_BIND_CAPTURE

iSelfSchooling-SQL> desc V$SQL_BIND_CAPTURE;

Name Null? Type

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

ADDRESS RAW(8)

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

CHILD_ADDRESS RAW(8)

CHILD_NUMBER NUMBER

NAME VARCHAR2(30)

POSITION NUMBER

DUP_POSITION NUMBER

DATATYPE NUMBER

DATATYPE_STRING VARCHAR2(15)

CHARACTER_SID NUMBER

PRECISION NUMBER

SCALE NUMBER

MAX_LENGTH NUMBER

WAS_CAPTURED VARCHAR2(3)

LAST_CAPTURED DATE

VALUE_STRING VARCHAR2(4000)

VALUE_ANYDATA ANYDATA

V$SQL_BIND_DATA: Synonym for V_$SQL_BIND_DATA

iSelfSchooling-SQL> desc V$SQL_BIND_DATA;

Name Null? Type

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

CURSOR_NUM NUMBER

POSITION NUMBER

DATATYPE NUMBER

SHARED_MAX_LEN NUMBER

PRIVATE_MAX_LEN NUMBER

ARRAY_SIZE NUMBER

PRECISION NUMBER

SCALE NUMBER

SHARED_FLAG NUMBER

SHARED_FLAG2 NUMBER

BUF_ADDRESS RAW(8)

BUF_LENGTH NUMBER

VAL_LENGTH NUMBER

BUF_FLAG NUMBER

INDICATOR NUMBER

VALUE VARCHAR2(4000)

V$SQL_BIND_METADATA: Synonym for V_$SQL_BIND_METADATA

iSelfSchooling-SQL> desc V$SQL_BIND_METADATA;

Name Null? Type

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

ADDRESS RAW(8)

POSITION NUMBER

DATATYPE NUMBER

MAX_LENGTH NUMBER

ARRAY_LEN NUMBER

BIND_NAME VARCHAR2(30)

V$SQL_CURSOR: Synonym for V_$SQL_CURSOR

iSelfSchooling-SQL> desc V$SQL_CURSOR;

Name Null? Type

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

CURNO NUMBER

FLAG NUMBER

STATUS VARCHAR2(9)

PARENT_HANDLE RAW(8)

PARENT_LOCK RAW(8)

CHILD_LOCK RAW(8)

CHILD_PIN RAW(8)

PERS_HEAP_MEM NUMBER

WORK_HEAP_MEM NUMBER

BIND_VARS NUMBER

DEFINE_VARS NUMBER

BIND_MEM_LOC VARCHAR2(64)

INST_FLAG VARCHAR2(64)

INST_FLAG2 VARCHAR2(64)

CHILD_HANDLE RAW(8)

V$SQL_JOIN_FILTER: Synonym for V_$SQL_JOIN_FILTER

iSelfSchooling-SQL> desc V$SQL_JOIN_FILTER;

Name Null? Type

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

QC_SESSION_ID NUMBER

QC_INSTANCE_ID NUMBER

SQL_PLAN_HASH_VALUE NUMBER

LENGTH NUMBER

BITS_SET NUMBER

FILTERED NUMBER

PROBED NUMBER

ACTIVE NUMBER

V$SQL_OPTIMIZER_ENV: Synonym for V_$SQL_OPTIMIZER_ENV

iSelfSchooling-SQL> desc V$SQL_OPTIMIZER_ENV;

Name Null? Type

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

ADDRESS RAW(8)

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

CHILD_ADDRESS RAW(8)

CHILD_NUMBER NUMBER

ID NUMBER

NAME VARCHAR2(40)

ISDEFAULT VARCHAR2(3)

VALUE VARCHAR2(25)

V$SQL_PLAN: Synonym for V_$SQL_PLAN

iSelfSchooling-SQL> desc V$SQL_PLAN;

Name Null? Type

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

ADDRESS RAW(8)

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

PLAN_HASH_VALUE NUMBER

CHILD_ADDRESS RAW(8)

CHILD_NUMBER NUMBER

TIMESTAMP DATE

OPERATION VARCHAR2(30)

OPTIONS VARCHAR2(30)

OBJECT_NODE VARCHAR2(40)

OBJECT# NUMBER

OBJECT_OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(30)

OBJECT_ALIAS VARCHAR2(65)

OBJECT_TYPE VARCHAR2(20)

OPTIMIZER VARCHAR2(20)

ID NUMBER

PARENT_ID NUMBER

DEPTH NUMBER

POSITION NUMBER

SEARCH_COLUMNS NUMBER

COST NUMBER

CARDINALITY NUMBER

BYTES NUMBER

OTHER_TAG VARCHAR2(35)

PARTITION_START VARCHAR2(5)

PARTITION_STOP VARCHAR2(5)

PARTITION_ID NUMBER

OTHER VARCHAR2(4000)

DISTRIBUTION VARCHAR2(20)

CPU_COST NUMBER

IO_COST NUMBER

TEMP_SPACE NUMBER

ACCESS_PREDICATES VARCHAR2(4000)

FILTER_PREDICATES VARCHAR2(4000)

PROJECTION VARCHAR2(4000)

TIME NUMBER

QBLOCK_NAME VARCHAR2(30)

REMARKS VARCHAR2(4000)

OTHER_XML CLOB

V$SQL_PLAN_STATISTICS: Synonym for V_$SQL_PLAN_STATISTICS

iSelfSchooling-SQL> desc V$SQL_PLAN_STATISTICS;

Name Null? Type

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

ADDRESS RAW(8)

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

PLAN_HASH_VALUE NUMBER

CHILD_ADDRESS RAW(8)

CHILD_NUMBER NUMBER

OPERATION_ID NUMBER

EXECUTIONS NUMBER

LAST_STARTS NUMBER

STARTS NUMBER

LAST_OUTPUT_ROWS NUMBER

OUTPUT_ROWS NUMBER

LAST_CR_BUFFER_GETS NUMBER

CR_BUFFER_GETS NUMBER

LAST_CU_BUFFER_GETS NUMBER

CU_BUFFER_GETS NUMBER

LAST_DISK_READS NUMBER

DISK_READS NUMBER

LAST_DISK_WRITES NUMBER

DISK_WRITES NUMBER

LAST_ELAPSED_TIME NUMBER

ELAPSED_TIME NUMBER

V$SQL_PLAN_STATISTICS_ALL: Synonym for V_$SQL_PLAN_STATISTICS_ALL

iSelfSchooling-SQL> desc V$SQL_PLAN_STATISTICS_ALL;

Name Null? Type

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

ADDRESS RAW(8)

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

PLAN_HASH_VALUE NUMBER

CHILD_ADDRESS RAW(8)

CHILD_NUMBER NUMBER

TIMESTAMP DATE

OPERATION VARCHAR2(30)

OPTIONS VARCHAR2(30)

OBJECT_NODE VARCHAR2(40)

OBJECT# NUMBER

OBJECT_OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(30)

OBJECT_ALIAS VARCHAR2(65)

OBJECT_TYPE VARCHAR2(20)

OPTIMIZER VARCHAR2(20)

ID NUMBER

PARENT_ID NUMBER

DEPTH NUMBER

POSITION NUMBER

SEARCH_COLUMNS NUMBER

COST NUMBER

CARDINALITY NUMBER

BYTES NUMBER

OTHER_TAG VARCHAR2(35)

PARTITION_START VARCHAR2(5)

PARTITION_STOP VARCHAR2(5)

PARTITION_ID NUMBER

OTHER VARCHAR2(4000)

DISTRIBUTION VARCHAR2(20)

CPU_COST NUMBER

IO_COST NUMBER

TEMP_SPACE NUMBER

ACCESS_PREDICATES VARCHAR2(4000)

FILTER_PREDICATES VARCHAR2(4000)

PROJECTION VARCHAR2(4000)

TIME NUMBER

QBLOCK_NAME VARCHAR2(30)

REMARKS VARCHAR2(4000)

OTHER_XML CLOB

EXECUTIONS NUMBER

LAST_STARTS NUMBER

STARTS NUMBER

LAST_OUTPUT_ROWS NUMBER

OUTPUT_ROWS NUMBER

LAST_CR_BUFFER_GETS NUMBER

CR_BUFFER_GETS NUMBER

LAST_CU_BUFFER_GETS NUMBER

CU_BUFFER_GETS NUMBER

LAST_DISK_READS NUMBER

DISK_READS NUMBER

LAST_DISK_WRITES NUMBER

DISK_WRITES NUMBER

LAST_ELAPSED_TIME NUMBER

ELAPSED_TIME NUMBER

POLICY VARCHAR2(10)

ESTIMATED_OPTIMAL_SIZE NUMBER

ESTIMATED_ONEPASS_SIZE NUMBER

LAST_MEMORY_USED NUMBER

LAST_EXECUTION VARCHAR2(10)

LAST_DEGREE NUMBER

TOTAL_EXECUTIONS NUMBER

OPTIMAL_EXECUTIONS NUMBER

ONEPASS_EXECUTIONS NUMBER

MULTIPASSES_EXECUTIONS NUMBER

ACTIVE_TIME NUMBER

MAX_TEMPSEG_SIZE NUMBER

LAST_TEMPSEG_SIZE NUMBER