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

iSelfSchooling-SQL> desc V$SQL_REDIRECTION;

Name Null? Type

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

ADDRESS RAW(8)

PARENT_HANDLE RAW(8)

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

CHILD_NUMBER NUMBER

PARSING_USER_ID NUMBER

PARSING_SCHEMA_ID NUMBER

COMMAND_TYPE NUMBER

REASON VARCHAR2(14)

ERROR_CODE NUMBER

POSITION NUMBER

SQL_TEXT_PIECE VARCHAR2(1000)

ERROR_MESSAGE VARCHAR2(1000)

V$SQL_SHARED_CURSOR: Synonym for V_$SQL_SHARED_CURSOR

iSelfSchooling-SQL> desc V$SQL_SHARED_CURSOR;

Name Null? Type

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

SQL_ID VARCHAR2(13)

ADDRESS RAW(8)

CHILD_ADDRESS RAW(8)

CHILD_NUMBER NUMBER

UNBOUND_CURSOR VARCHAR2(1)

SQL_TYPE_MISMATCH VARCHAR2(1)

OPTIMIZER_MISMATCH VARCHAR2(1)

OUTLINE_MISMATCH VARCHAR2(1)

STATS_ROW_MISMATCH VARCHAR2(1)

LITERAL_MISMATCH VARCHAR2(1)

SEC_DEPTH_MISMATCH VARCHAR2(1)

EXPLAIN_PLAN_CURSOR VARCHAR2(1)

BUFFERED_DML_MISMATCH VARCHAR2(1)

PDML_ENV_MISMATCH VARCHAR2(1)

INST_DRTLD_MISMATCH VARCHAR2(1)

SLAVE_QC_MISMATCH VARCHAR2(1)

TYPECHECK_MISMATCH VARCHAR2(1)

AUTH_CHECK_MISMATCH VARCHAR2(1)

BIND_MISMATCH VARCHAR2(1)

DESCRIBE_MISMATCH VARCHAR2(1)

LANGUAGE_MISMATCH VARCHAR2(1)

TRANSLATION_MISMATCH VARCHAR2(1)

ROW_LEVEL_SEC_MISMATCH VARCHAR2(1)

INSUFF_PRIVS VARCHAR2(1)

INSUFF_PRIVS_REM VARCHAR2(1)

REMOTE_TRANS_MISMATCH VARCHAR2(1)

LOGMINER_SESSION_MISMATCH VARCHAR2(1)

INCOMP_LTRL_MISMATCH VARCHAR2(1)

OVERLAP_TIME_MISMATCH VARCHAR2(1)

SQL_REDIRECT_MISMATCH VARCHAR2(1)

MV_QUERY_GEN_MISMATCH VARCHAR2(1)

USER_BIND_PEEK_MISMATCH VARCHAR2(1)

TYPCHK_DEP_MISMATCH VARCHAR2(1)

NO_TRIGGER_MISMATCH VARCHAR2(1)

FLASHBACK_CURSOR VARCHAR2(1)

ANYDATA_TRANSFORMATION VARCHAR2(1)

INCOMPLETE_CURSOR VARCHAR2(1)

TOP_LEVEL_RPI_CURSOR VARCHAR2(1)

DIFFERENT_LONG_LENGTH VARCHAR2(1)

LOGICAL_STANDBY_APPLY VARCHAR2(1)

DIFF_CALL_DURN VARCHAR2(1)

BIND_UACS_DIFF VARCHAR2(1)

PLSQL_CMP_SWITCHS_DIFF VARCHAR2(1)

CURSOR_PARTS_MISMATCH VARCHAR2(1)

STB_OBJECT_MISMATCH VARCHAR2(1)

ROW_SHIP_MISMATCH VARCHAR2(1)

PQ_SLAVE_MISMATCH VARCHAR2(1)

TOP_LEVEL_DDL_MISMATCH VARCHAR2(1)

MULTI_PX_MISMATCH VARCHAR2(1)

BIND_PEEKED_PQ_MISMATCH VARCHAR2(1)

MV_REWRITE_MISMATCH VARCHAR2(1)

ROLL_INVALID_MISMATCH VARCHAR2(1)

OPTIMIZER_MODE_MISMATCH VARCHAR2(1)

PX_MISMATCH VARCHAR2(1)

MV_STALEOBJ_MISMATCH VARCHAR2(1)

FLASHBACK_TABLE_MISMATCH VARCHAR2(1)

LITREP_COMP_MISMATCH VARCHAR2(1)

V$SQL_SHARED_MEMORY: Synonym for V_$SQL_SHARED_MEMORY

iSelfSchooling-SQL> desc V$SQL_SHARED_MEMORY;

Name Null? Type

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

SQL_TEXT VARCHAR2(1000)

SQL_FULLTEXT CLOB

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

HEAP_DESC RAW(8)

STRUCTURE VARCHAR2(16)

FUNCTION VARCHAR2(16)

CHUNK_COM VARCHAR2(16)

CHUNK_PTR RAW(8)

CHUNK_SIZE NUMBER

ALLOC_CLASS VARCHAR2(8)

CHUNK_TYPE NUMBER

SUBHEAP_DESC RAW(8)

V$SQL_WORKAREA: Synonym for V_$SQL_WORKAREA

iSelfSchooling-SQL> desc V$SQL_WORKAREA;

Name Null? Type

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

ADDRESS RAW(8)

HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

CHILD_NUMBER NUMBER

WORKAREA_ADDRESS RAW(8)

OPERATION_TYPE VARCHAR2(20)

OPERATION_ID 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

V$SQL_WORKAREA_ACTIVE: Synonym for V_$SQL_WORKAREA_ACTIVE

iSelfSchooling-SQL> desc V$SQL_WORKAREA_ACTIVE;

Name Null? Type

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

SQL_HASH_VALUE NUMBER

SQL_ID VARCHAR2(13)

WORKAREA_ADDRESS RAW(8)

OPERATION_TYPE VARCHAR2(20)

OPERATION_ID NUMBER

POLICY VARCHAR2(6)

SID NUMBER

QCINST_ID NUMBER

QCSID NUMBER

ACTIVE_TIME NUMBER

WORK_AREA_SIZE NUMBER

EXPECTED_SIZE NUMBER

ACTUAL_MEM_USED NUMBER

MAX_MEM_USED NUMBER

NUMBER_PASSES NUMBER

TEMPSEG_SIZE NUMBER

TABLESPACE VARCHAR2(30)

SEGRFNO# NUMBER

SEGBLK# NUMBER

V$SQL_WORKAREA_HISTOGRAM: Synonym for V_$SQL_WORKAREA_HISTOGRAM

iSelfSchooling-SQL> desc V$SQL_WORKAREA_HISTOGRAM;

Name Null? Type

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

LOW_OPTIMAL_SIZE NUMBER

HIGH_OPTIMAL_SIZE NUMBER

OPTIMAL_EXECUTIONS NUMBER

ONEPASS_EXECUTIONS NUMBER

MULTIPASSES_EXECUTIONS NUMBER

TOTAL_EXECUTIONS NUMBER

V$STANDBY_APPLY_SNAPSHOT: Synonym for V_$STANDBY_APPLY_SNAPSHOT

iSelfSchooling-SQL> desc V$STANDBY_APPLY_SNAPSHOT;

Name Null? Type

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

SNAPSHOT_TIME DATE

SESSION_ID NUMBER

THREAD# NUMBER

RESET_TIMESTAMP NUMBER

SEQUENCE# NUMBER

BLOCK# NUMBER

APPLIED_SCN NUMBER

APPLIED_TIME DATE

NEWEST_RESET_TIMESTAMP NUMBER

NEWEST_ARCHIVED_SEQ# NUMBER

NEWEST_TIME DATE

NEWEST_USED NUMBER

NEWEST_SRL_SEQ# NUMBER

BLOCKSIZE NUMBER

APPLY_RATE NUMBER

V$STANDBY_LOG: Synonym for V_$STANDBY_LOG

iSelfSchooling-SQL> desc V$STANDBY_LOG;

Name Null? Type

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

GROUP# NUMBER

DBID VARCHAR2(40)

THREAD# NUMBER

SEQUENCE# NUMBER

BYTES NUMBER

USED NUMBER

ARCHIVED VARCHAR2(3)

STATUS VARCHAR2(10)

FIRST_CHANGE# NUMBER

FIRST_TIME DATE

LAST_CHANGE# NUMBER

LAST_TIME DATE

V$STATISTICS_LEVEL: Synonym for V_$STATISTICS_LEVEL

iSelfSchooling-SQL> desc V$STATISTICS_LEVEL;

Name Null? Type

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

STATISTICS_NAME VARCHAR2(64)

DESCRIPTION VARCHAR2(4000)

SESSION_STATUS VARCHAR2(8)

SYSTEM_STATUS VARCHAR2(8)

ACTIVATION_LEVEL VARCHAR2(7)

STATISTICS_VIEW_NAME VARCHAR2(64)

SESSION_SETTABLE VARCHAR2(3)

V$STATNAME: Synonym for V_$STATNAME

iSelfSchooling-SQL> desc V$STATNAME;

Name Null? Type

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

STATISTIC# NUMBER

NAME VARCHAR2(64)

CLASS NUMBER

STAT_ID NUMBER

V$STREAMS_APPLY_COORDINATOR: Synonym for V_$STREAMS_APPLY_COORDINATOR

iSelfSchooling-SQL> desc V$STREAMS_APPLY_COORDINATOR;

Name Null? Type

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

SID NUMBER

SERIAL# NUMBER

STATE VARCHAR2(21)

APPLY# NUMBER

APPLY_NAME VARCHAR2(30)

TOTAL_APPLIED NUMBER

TOTAL_WAIT_DEPS NUMBER

TOTAL_WAIT_COMMITS NUMBER

TOTAL_ADMIN NUMBER

TOTAL_ASSIGNED NUMBER

TOTAL_RECEIVED NUMBER

TOTAL_IGNORED NUMBER

TOTAL_ROLLBACKS NUMBER

TOTAL_ERRORS NUMBER

LWM_TIME DATE

LWM_MESSAGE_NUMBER NUMBER

LWM_MESSAGE_CREATE_TIME DATE

HWM_TIME DATE

HWM_MESSAGE_NUMBER NUMBER

HWM_MESSAGE_CREATE_TIME DATE

STARTUP_TIME DATE

ELAPSED_SCHEDULE_TIME NUMBER

ELAPSED_IDLE_TIME NUMBER

V$STREAMS_APPLY_READER: Synonym for V_$STREAMS_APPLY_READER

iSelfSchooling-SQL> desc V$STREAMS_APPLY_READER;

Name Null? Type

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

SID NUMBER

SERIAL# NUMBER

APPLY# NUMBER

APPLY_NAME VARCHAR2(30)

STATE VARCHAR2(17)

TOTAL_MESSAGES_DEQUEUED NUMBER

TOTAL_MESSAGES_SPILLED NUMBER

DEQUEUE_TIME DATE

DEQUEUED_MESSAGE_NUMBER NUMBER

DEQUEUED_MESSAGE_CREATE_TIME DATE

SGA_USED NUMBER

ELAPSED_DEQUEUE_TIME NUMBER

ELAPSED_SCHEDULE_TIME NUMBER

ELAPSED_SPILL_TIME NUMBER

LAST_BROWSE_NUM NUMBER

OLDEST_SCN_NUM NUMBER

LAST_BROWSE_SEQ NUMBER

LAST_DEQ_SEQ NUMBER

OLDEST_XIDUSN NUMBER

OLDEST_XIDSLT NUMBER

OLDEST_XIDSQN NUMBER

V$STREAMS_APPLY_SERVER: Synonym for V_$STREAMS_APPLY_SERVER

iSelfSchooling-SQL> desc V$STREAMS_APPLY_SERVER;

Name Null? Type

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

SID NUMBER

SERIAL# NUMBER

APPLY# NUMBER

APPLY_NAME VARCHAR2(30)

SERVER_ID NUMBER

STATE VARCHAR2(20)

XIDUSN NUMBER

XIDSLT NUMBER

XIDSQN NUMBER

COMMITSCN NUMBER

DEP_XIDUSN NUMBER

DEP_XIDSLT NUMBER

DEP_XIDSQN NUMBER

DEP_COMMITSCN NUMBER

MESSAGE_SEQUENCE NUMBER

TOTAL_ASSIGNED NUMBER

TOTAL_ADMIN NUMBER

TOTAL_ROLLBACKS NUMBER

TOTAL_MESSAGES_APPLIED NUMBER

APPLY_TIME DATE

APPLIED_MESSAGE_NUMBER NUMBER

APPLIED_MESSAGE_CREATE_TIME DATE

ELAPSED_DEQUEUE_TIME NUMBER

ELAPSED_APPLY_TIME NUMBER

V$STREAMS_CAPTURE: Synonym for V_$STREAMS_CAPTURE

iSelfSchooling-SQL> desc V$STREAMS_CAPTURE;

Name Null? Type

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

SID NUMBER

SERIAL# NUMBER

CAPTURE# NUMBER

CAPTURE_NAME VARCHAR2(30)

LOGMINER_ID NUMBER

STARTUP_TIME DATE

STATE VARCHAR2(73)

TOTAL_PREFILTER_DISCARDED NUMBER

TOTAL_PREFILTER_KEPT NUMBER

TOTAL_PREFILTER_EVALUATIONS NUMBER

TOTAL_MESSAGES_CAPTURED NUMBER

CAPTURE_TIME DATE

CAPTURE_MESSAGE_NUMBER NUMBER

CAPTURE_MESSAGE_CREATE_TIME DATE

TOTAL_MESSAGES_CREATED NUMBER

TOTAL_FULL_EVALUATIONS NUMBER

TOTAL_MESSAGES_ENQUEUED NUMBER

ENQUEUE_TIME DATE

ENQUEUE_MESSAGE_NUMBER NUMBER

ENQUEUE_MESSAGE_CREATE_TIME DATE

AVAILABLE_MESSAGE_NUMBER NUMBER

AVAILABLE_MESSAGE_CREATE_TIME DATE

ELAPSED_CAPTURE_TIME NUMBER

ELAPSED_RULE_TIME NUMBER

ELAPSED_ENQUEUE_TIME NUMBER

ELAPSED_LCR_TIME NUMBER

ELAPSED_REDO_WAIT_TIME NUMBER

ELAPSED_PAUSE_TIME NUMBER

STATE_CHANGED_TIME DATE

V$STREAMS_POOL_ADVICE: Synonym for V_$STREAMS_POOL_ADVICE

iSelfSchooling-SQL> desc V$STREAMS_POOL_ADVICE;

Name Null? Type

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

STREAMS_POOL_SIZE_FOR_ESTIMATE NUMBER

STREAMS_POOL_SIZE_FACTOR NUMBER

ESTD_SPILL_COUNT NUMBER

ESTD_SPILL_TIME NUMBER

ESTD_UNSPILL_COUNT NUMBER

ESTD_UNSPILL_TIME NUMBER

V$STREAMS_TRANSACTION: Synonym for V_$STREAMS_TRANSACTION

iSelfSchooling-SQL> desc V$STREAMS_TRANSACTION;

Name Null? Type

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

STREAMS_NAME VARCHAR2(30)

STREAMS_TYPE VARCHAR2(10)

XIDUSN NUMBER

XIDSLT NUMBER

XIDSQN NUMBER

CUMULATIVE_MESSAGE_COUNT NUMBER

TOTAL_MESSAGE_COUNT NUMBER

FIRST_MESSAGE_TIME DATE

FIRST_MESSAGE_NUMBER DATE

LAST_MESSAGE_TIME DATE

LAST_MESSAGE_NUMBER DATE

V$SUBCACHE: Synonym for V_$SUBCACHE

iSelfSchooling-SQL> desc V$SUBCACHE;

Name Null? Type

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

OWNER_NAME VARCHAR2(64)

NAME VARCHAR2(1000)

TYPE NUMBER

HEAP_NUM NUMBER

CACHE_ID NUMBER

CACHE_CNT NUMBER

HEAP_SZ NUMBER

HEAP_ALOC NUMBER

HEAP_USED NUMBER

V$SYSAUX_OCCUPANTS: Synonym for V_$SYSAUX_OCCUPANTS

iSelfSchooling-SQL> desc V$SYSAUX_OCCUPANTS;

Name Null? Type

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

OCCUPANT_NAME VARCHAR2(64)

OCCUPANT_DESC VARCHAR2(64)

SCHEMA_NAME VARCHAR2(64)

MOVE_PROCEDURE VARCHAR2(64)

MOVE_PROCEDURE_DESC VARCHAR2(64)

SPACE_USAGE_KBYTES NUMBER

V$SYSMETRIC: Synonym for V_$SYSMETRIC

iSelfSchooling-SQL> desc V$SYSMETRIC;

Name Null? Type

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

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

GROUP_ID NUMBER

METRIC_ID NUMBER

METRIC_NAME VARCHAR2(64)

VALUE NUMBER

METRIC_UNIT VARCHAR2(64)

V$SYSMETRIC_HISTORY: Synonym for V_$SYSMETRIC_HISTORY

iSelfSchooling-SQL> desc V$SYSMETRIC_HISTORY;

Name Null? Type

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

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

GROUP_ID NUMBER

METRIC_ID NUMBER

METRIC_NAME VARCHAR2(64)

VALUE NUMBER

METRIC_UNIT VARCHAR2(64)

V$SYSMETRIC_SUMMARY: Synonym for V_$SYSMETRIC_SUMMARY

iSelfSchooling-SQL> desc V$SYSMETRIC_SUMMARY;

Name Null? Type

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

BEGIN_TIME DATE

END_TIME DATE

INTSIZE_CSEC NUMBER

GROUP_ID NUMBER

METRIC_ID NUMBER

METRIC_NAME VARCHAR2(64)

NUM_INTERVAL NUMBER

MAXVAL NUMBER

MINVAL NUMBER

AVERAGE NUMBER

STANDARD_DEVIATION NUMBER

METRIC_UNIT VARCHAR2(64)

V$SYSSTAT: Synonym for V_$SYSSTAT

iSelfSchooling-SQL> desc V$SYSSTAT;

Name Null? Type

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

STATISTIC# NUMBER

NAME VARCHAR2(64)

CLASS NUMBER

VALUE NUMBER

STAT_ID NUMBER

V$SYSTEM_CURSOR_CACHE: Synonym for V_$SYSTEM_CURSOR_CACHE

iSelfSchooling-SQL> desc V$SYSTEM_CURSOR_CACHE;

Name Null? Type

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

OPENS NUMBER

HITS NUMBER

HIT_RATIO NUMBER

V$SYSTEM_EVENT: Synonym for V_$SYSTEM_EVENT

iSelfSchooling-SQL> desc V$SYSTEM_EVENT;

Name Null? Type

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

EVENT VARCHAR2(64)

TOTAL_WAITS NUMBER

TOTAL_TIMEOUTS NUMBER

TIME_WAITED NUMBER

AVERAGE_WAIT NUMBER

TIME_WAITED_MICRO NUMBER

EVENT_ID NUMBER

WAIT_CLASS_ID NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS VARCHAR2(64)

V$SYSTEM_PARAMETER: Synonym for V_$SYSTEM_PARAMETER

iSelfSchooling-SQL> desc V$SYSTEM_PARAMETER;

Name Null? Type

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

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(8)

ISADJUSTED VARCHAR2(5)

ISDEPRECATED VARCHAR2(5)

DESCRIPTION VARCHAR2(255)

UPDATE_COMMENT VARCHAR2(255)

HASH NUMBER

V$SYSTEM_PARAMETER2: Synonym for V_$SYSTEM_PARAMETER2

iSelfSchooling-SQL> desc V$SYSTEM_PARAMETER2;

Name Null? Type

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

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(8)

ISADJUSTED VARCHAR2(5)

ISDEPRECATED VARCHAR2(5)

DESCRIPTION VARCHAR2(255)

ORDINAL NUMBER

UPDATE_COMMENT VARCHAR2(255)

V$SYSTEM_WAIT_CLASS: Synonym for V_$SYSTEM_WAIT_CLASS

iSelfSchooling-SQL> desc V$SYSTEM_WAIT_CLASS;

Name Null? Type

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

WAIT_CLASS_ID NUMBER

WAIT_CLASS# NUMBER

WAIT_CLASS VARCHAR2(64)

TOTAL_WAITS NUMBER

TIME_WAITED NUMBER

V$SYS_OPTIMIZER_ENV: Synonym for V_$SYS_OPTIMIZER_ENV

iSelfSchooling-SQL> desc V$SYS_OPTIMIZER_ENV;

Name Null? Type

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

ID NUMBER

NAME VARCHAR2(40)

ISDEFAULT VARCHAR2(3)

VALUE VARCHAR2(25)

DEFAULT_VALUE VARCHAR2(25)

V$SYS_TIME_MODEL: Synonym for V_$SYS_TIME_MODEL

iSelfSchooling-SQL> desc V$SYS_TIME_MODEL;

Name Null? Type

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

STAT_ID NUMBER

STAT_NAME VARCHAR2(64)

VALUE NUMBER

V$TABLESPACE: Synonym for V_$TABLESPACE

iSelfSchooling-SQL> desc V$TABLESPACE;

Name Null? Type

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

TS# NUMBER

NAME VARCHAR2(30)

INCLUDED_IN_DATABASE_BACKUP VARCHAR2(3)

BIGFILE VARCHAR2(3)

FLASHBACK_ON VARCHAR2(3)

ENCRYPT_IN_BACKUP VARCHAR2(3)

V$TEMPFILE: Synonym for V_$TEMPFILE

iSelfSchooling-SQL> desc V$TEMPFILE;

Name Null? Type

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

FILE# NUMBER

CREATION_CHANGE# NUMBER

CREATION_TIME DATE

TS# NUMBER

RFILE# NUMBER

STATUS VARCHAR2(7)

ENABLED VARCHAR2(10)

BYTES NUMBER

BLOCKS NUMBER

CREATE_BYTES NUMBER

BLOCK_SIZE NUMBER

NAME VARCHAR2(513)

V$TEMPORARY_LOBS: Synonym for V_$TEMPORARY_LOBS

iSelfSchooling-SQL> desc V$TEMPORARY_LOBS;

Name Null? Type

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

SID NUMBER

CACHE_LOBS NUMBER

NOCACHE_LOBS NUMBER

ABSTRACT_LOBS NUMBER