|
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
|