|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_OPANCILLARY: All ancillary operators
iSelfSchooling-SQL> desc DBA_OPANCILLARY;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
BINDING#
NOT NULL NUMBER
PRIMOP_OWNER
NOT NULL VARCHAR2(30)
PRIMOP_NAME
NOT NULL VARCHAR2(30)
PRIMOP_BIND#
NOT NULL NUMBER
DBA_OPARGUMENTS: All operator arguments
iSelfSchooling-SQL> desc DBA_OPARGUMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
BINDING#
NOT NULL NUMBER
POSITION
NOT NULL NUMBER
ARGUMENT_TYPE
VARCHAR2(61)
DBA_OPBINDINGS: All operator binding functiosn or methods
iSelfSchooling-SQL> desc DBA_OPBINDINGS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
BINDING# NOT
NULL NUMBER
FUNCTION_NAME
VARCHAR2(92)
RETURN_SCHEMA
VARCHAR2(30)
RETURN_TYPE
VARCHAR2(30)
IMPLEMENTATION_TYPE_SCHEMA VARCHAR2(30)
IMPLEMENTATION_TYPE
VARCHAR2(30)
PROPERTY
VARCHAR2(43)
DBA_OPERATORS: All operators
iSelfSchooling-SQL> desc DBA_OPERATORS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
NUMBER_OF_BINDS
NOT NULL NUMBER
DBA_OPERATOR_COMMENTS: Comments for user-defined operators
iSelfSchooling-SQL> desc DBA_OPERATOR_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
DBA_OPTSTAT_OPERATIONS: History of statistics operations performed
iSelfSchooling-SQL> desc DBA_OPTSTAT_OPERATIONS;
Name
Null? Type
----------------------------- -------- --------------------
OPERATION
VARCHAR2(64)
TARGET
VARCHAR2(64)
START_TIME
TIMESTAMP(6)
END_TIME
TIMESTAMP(6)
DBA_OUTLINES: Stored outlines
iSelfSchooling-SQL> desc DBA_OUTLINES;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
OWNER
VARCHAR2(30)
CATEGORY
VARCHAR2(30)
USED
VARCHAR2(6)
TIMESTAMP
DATE
VERSION
VARCHAR2(64)
SQL_TEXT
LONG
SIGNATURE
RAW(16)
COMPATIBLE
VARCHAR2(12)
ENABLED
VARCHAR2(8)
FORMAT
VARCHAR2(6)
DBA_OUTLINE_HINTS: Hints stored in outlines
iSelfSchooling-SQL> desc DBA_OUTLINE_HINTS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
OWNER
VARCHAR2(30)
NODE
NUMBER
STAGE
NUMBER
JOIN_POS
NUMBER
HINT
CLOB
DBA_OUTSTANDING_ALERTS: Description of all outstanding alerts
iSelfSchooling-SQL> desc DBA_OUTSTANDING_ALERTS;
Name
Null? Type
----------------------------- -------- --------------------
SEQUENCE_ID
NUMBER
REASON_ID
NOT NULL NUMBER
OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(513)
SUBOBJECT_NAME
VARCHAR2(30)
OBJECT_TYPE
VARCHAR2(64)
REASON
VARCHAR2(4000)
TIME_SUGGESTED
TIMESTAMP(6)
CREATION_TIME
TIMESTAMP(6)
SUGGESTED_ACTION
VARCHAR2(4000)
ADVISOR_NAME
VARCHAR2(30)
METRIC_VALUE
NUMBER
MESSAGE_TYPE
VARCHAR2(12)
MESSAGE_GROUP
VARCHAR2(64)
MESSAGE_LEVEL
NUMBER
HOSTING_CLIENT_ID
VARCHAR2(64)
MODULE_ID
VARCHAR2(64)
PROCESS_ID
VARCHAR2(128)
HOST_ID
VARCHAR2(256)
HOST_NW_ADDR
VARCHAR2(256)
INSTANCE_NAME
VARCHAR2(16)
INSTANCE_NUMBER
NUMBER
USER_ID
VARCHAR2(30)
EXECUTION_CONTEXT_ID
VARCHAR2(60)
ERROR_INSTANCE_ID
VARCHAR2(142)
DBA_PARTIAL_DROP_TABS: All tables with partially dropped columns in the
database
iSelfSchooling-SQL> desc DBA_PARTIAL_DROP_TABS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
DBA_PART_COL_STATISTICS
iSelfSchooling-SQL> desc DBA_PART_COL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
NUM_DISTINCT
NUMBER
LOW_VALUE
RAW(32)
HIGH_VALUE
RAW(32)
DENSITY
NUMBER
NUM_NULLS
NUMBER
NUM_BUCKETS
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
AVG_COL_LEN
NUMBER
HISTOGRAM
VARCHAR2(15)
DBA_PART_HISTOGRAMS
iSelfSchooling-SQL> desc DBA_PART_HISTOGRAMS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
BUCKET_NUMBER
NUMBER
ENDPOINT_VALUE
NUMBER
ENDPOINT_ACTUAL_VALUE
VARCHAR2(1000)
DBA_PART_INDEXES
iSelfSchooling-SQL> desc DBA_PART_INDEXES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
PARTITIONING_TYPE
VARCHAR2(7)
SUBPARTITIONING_TYPE
VARCHAR2(7)
PARTITION_COUNT
NOT NULL NUMBER
DEF_SUBPARTITION_COUNT
NUMBER
PARTITIONING_KEY_COUNT
NOT NULL NUMBER
SUBPARTITIONING_KEY_COUNT
NUMBER
LOCALITY
VARCHAR2(6)
ALIGNMENT
VARCHAR2(12)
DEF_TABLESPACE_NAME
VARCHAR2(30)
DEF_PCT_FREE
NOT NULL NUMBER
DEF_INI_TRANS
NOT NULL NUMBER
DEF_MAX_TRANS
NOT NULL NUMBER
DEF_INITIAL_EXTENT
VARCHAR2(40)
DEF_NEXT_EXTENT
VARCHAR2(40)
DEF_MIN_EXTENTS
VARCHAR2(40)
DEF_MAX_EXTENTS
VARCHAR2(40)
DEF_PCT_INCREASE
VARCHAR2(40)
DEF_FREELISTS
NOT NULL NUMBER
DEF_FREELIST_GROUPS
NOT NULL NUMBER
DEF_LOGGING
VARCHAR2(7)
DEF_BUFFER_POOL
VARCHAR2(7)
DEF_PARAMETERS
VARCHAR2(1000)
DBA_PART_KEY_COLUMNS
iSelfSchooling-SQL> desc DBA_PART_KEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
OBJECT_TYPE
CHAR(5)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_POSITION
NUMBER
DBA_PART_LOBS
iSelfSchooling-SQL> desc DBA_PART_LOBS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
|