|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_SNAPSHOT_LOGS: All snapshot logs in the database that
the user can see
iSelfSchooling-SQL> desc ALL_SNAPSHOT_LOGS;
Name
Null? Type
----------------------------- -------- --------------------
LOG_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
LOG_TABLE
VARCHAR2(30)
LOG_TRIGGER
VARCHAR2(30)
ROWIDS
VARCHAR2(3)
PRIMARY_KEY
VARCHAR2(3)
OBJECT_ID
VARCHAR2(3)
FILTER_COLUMNS
VARCHAR2(3)
SEQUENCE
VARCHAR2(3)
INCLUDE_NEW_VALUES
VARCHAR2(3)
CURRENT_SNAPSHOTS
DATE
SNAPSHOT_ID
NUMBER
ALL_SNAPSHOT_REFRESH_TIMES: Synonym for ALL_MVIEW_REFRESH_TIMES
iSelfSchooling-SQL> desc ALL_SNAPSHOT_REFRESH_TIMES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
MASTER_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
LAST_REFRESH
DATE
ALL_SOURCE
Current source on stored objects that
user is allowed to create
iSelfSchooling-SQL> desc ALL_SOURCE;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
TYPE
VARCHAR2(12)
LINE
NUMBER
TEXT
VARCHAR2(4000)
ALL_SOURCE_TABLES: Source tables available for Change Data
Capture
iSelfSchooling-SQL> desc ALL_SOURCE_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
ALL_SQLJ_TYPES: Description of types accessible to the
user
iSelfSchooling-SQL> desc ALL_SQLJ_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TYPE_NAME
NOT NULL VARCHAR2(30)
TYPE_OID
NOT NULL RAW(16)
EXTERNAL_NAME
VARCHAR2(4000)
USING
VARCHAR2(21)
TYPECODE
VARCHAR2(30)
ATTRIBUTES
NUMBER
METHODS
NUMBER
PREDEFINED
VARCHAR2(3)
INCOMPLETE
VARCHAR2(3)
FINAL
VARCHAR2(3)
INSTANTIABLE
VARCHAR2(3)
SUPERTYPE_OWNER
VARCHAR2(30)
SUPERTYPE_NAME
VARCHAR2(30)
LOCAL_ATTRIBUTES
NUMBER
LOCAL_METHODS
NUMBER
ALL_SQLJ_TYPE_ATTRS: Description of attributes of types
accessible to the user
iSelfSchooling-SQL> desc ALL_SQLJ_TYPE_ATTRS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TYPE_NAME
NOT NULL VARCHAR2(30)
ATTR_NAME
NOT NULL VARCHAR2(30)
EXTERNAL_ATTR_NAME
VARCHAR2(4000)
ATTR_TYPE_MOD
VARCHAR2(7)
ATTR_TYPE_OWNER
VARCHAR2(30)
ATTR_TYPE_NAME
VARCHAR2(30)
LENGTH
NUMBER
PRECISION
NUMBER
SCALE
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
ATTR_NO
NOT NULL NUMBER
INHERITED
VARCHAR2(3)
ALL_SQLJ_TYPE_METHODS: Description of methods of types
accessible to the user
iSelfSchooling-SQL> desc ALL_SQLJ_TYPE_METHODS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TYPE_NAME
NOT NULL VARCHAR2(30)
METHOD_NAME
NOT NULL VARCHAR2(30)
EXTERNAL_VAR_NAME
VARCHAR2(4000)
METHOD_NO
NOT NULL NUMBER
METHOD_TYPE
VARCHAR2(6)
PARAMETERS
NOT NULL NUMBER
RESULTS
NOT NULL NUMBER
FINAL
VARCHAR2(3)
INSTANTIABLE
VARCHAR2(3)
OVERRIDING
VARCHAR2(3)
INHERITED
VARCHAR2(3)
ALL_SQLSET
iSelfSchooling-SQL> desc ALL_SQLSET;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(30)
ID
NOT NULL NUMBER
OWNER
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
CREATED
DATE
LAST_MODIFIED
DATE
STATEMENT_COUNT
NUMBER
ALL_SQLSET_BINDS
iSelfSchooling-SQL> desc ALL_SQLSET_BINDS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
VARCHAR2(30)
SQLSET_OWNER
VARCHAR2(30)
SQLSET_ID
NUMBER
SQL_ID
VARCHAR2(13)
FORCE_MATCHING_SIGNATURE
NUMBER
PLAN_HASH_VALUE
NUMBER
POSITION
NUMBER
VALUE
ANYDATA
CAPTURED
CHAR(1)
SQL_SEQ
NUMBER
ALL_SQLSET_PLANS
iSelfSchooling-SQL> desc ALL_SQLSET_PLANS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
NOT NULL VARCHAR2(30)
SQLSET_OWNER
VARCHAR2(30)
SQLSET_ID
NOT NULL NUMBER
SQL_ID
NOT NULL VARCHAR2(13)
FORCE_MATCHING_SIGNATURE
NOT NULL NUMBER
PLAN_HASH_VALUE
NOT NULL NUMBER
SQL_SEQ
NOT NULL NUMBER
STATEMENT_ID
VARCHAR2(30)
PLAN_ID
NUMBER
TIMESTAMP
DATE
REMARKS
VARCHAR2(4000)
OPERATION
VARCHAR2(30)
OPTIONS
VARCHAR2(255)
OBJECT_NODE
VARCHAR2(128)
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
OBJECT_ALIAS
VARCHAR2(65)
OBJECT_INSTANCE
NUMBER(38)
OBJECT_TYPE
VARCHAR2(30)
OPTIMIZER
VARCHAR2(255)
SEARCH_COLUMNS
NUMBER
ID
NOT NULL NUMBER(38)
PARENT_ID
NUMBER(38)
DEPTH
NUMBER(38)
POSITION
NUMBER(38)
COST
NUMBER(38)
CARDINALITY
NUMBER(38)
BYTES
NUMBER(38)
OTHER_TAG
VARCHAR2(255)
PARTITION_START
VARCHAR2(255)
PARTITION_STOP
VARCHAR2(255)
PARTITION_ID
NUMBER(38)
OTHER
LONG
DISTRIBUTION
VARCHAR2(30)
CPU_COST
NUMBER(38)
IO_COST
NUMBER(38)
TEMP_SPACE
NUMBER(38)
ACCESS_PREDICATES
VARCHAR2(4000)
FILTER_PREDICATES
VARCHAR2(4000)
PROJECTION
VARCHAR2(4000)
TIME
NUMBER(38)
QBLOCK_NAME
VARCHAR2(30)
OTHER_XML
CLOB
EXECUTIONS
NUMBER
STARTS
NUMBER
OUTPUT_ROWS
NUMBER
CR_BUFFER_GETS
NUMBER
CU_BUFFER_GETS
NUMBER
DISK_READS
NUMBER
DISK_WRITES
NUMBER
ELAPSED_TIME
NUMBER
ALL_SQLSET_REFERENCES
iSelfSchooling-SQL> desc ALL_SQLSET_REFERENCES;
Name
Null? Type
----------------------------- -------- --------------------
|