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
|