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)
LOB_NAME
NOT NULL VARCHAR2(30)
LOB_INDEX_NAME
NOT NULL VARCHAR2(30)
DEF_CHUNK
NOT NULL NUMBER
DEF_PCTVERSION
NOT NULL NUMBER
DEF_CACHE
VARCHAR2(10)
DEF_IN_ROW
VARCHAR2(3)
DEF_TABLESPACE_NAME
VARCHAR2(30)
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
VARCHAR2(40)
DEF_FREELIST_GROUPS
VARCHAR2(40)
DEF_LOGGING
VARCHAR2(7)
DEF_BUFFER_POOL
VARCHAR2(7)
DBA_PART_TABLES
iSelfSchooling-SQL> desc DBA_PART_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
PARTITIONING_TYPE
VARCHAR2(7)
SUBPARTITIONING_TYPE
VARCHAR2(7)
PARTITION_COUNT
NUMBER
DEF_SUBPARTITION_COUNT
NUMBER
PARTITIONING_KEY_COUNT
NUMBER
SUBPARTITIONING_KEY_COUNT
NUMBER
STATUS
VARCHAR2(8)
DEF_TABLESPACE_NAME
VARCHAR2(30)
DEF_PCT_FREE
NUMBER
DEF_PCT_USED
NUMBER
DEF_INI_TRANS
NUMBER
DEF_MAX_TRANS
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
NUMBER
DEF_FREELIST_GROUPS
NUMBER
DEF_LOGGING
VARCHAR2(7)
DEF_COMPRESSION
VARCHAR2(8)
DEF_BUFFER_POOL
VARCHAR2(7)
DBA_PENDING_CONV_TABLES: All tables which are not upgraded to the latest
type version in the database
iSelfSchooling-SQL> desc DBA_PENDING_CONV_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
DBA_PENDING_TRANSACTIONS: information about unresolved global transactions
iSelfSchooling-SQL> desc DBA_PENDING_TRANSACTIONS;
Name
Null?
Type
----------------------------- -------- --------------------
FORMATID
NUMBER
GLOBALID
RAW(64)
BRANCHID
RAW(64)
DBA_PLSQL_OBJECT_SETTINGS: Compiler settings of all objects in the database
iSelfSchooling-SQL> desc DBA_PLSQL_OBJECT_SETTINGS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(12)
PLSQL_OPTIMIZE_LEVEL
NUMBER
PLSQL_CODE_TYPE
VARCHAR2(4000)
PLSQL_DEBUG
VARCHAR2(4000)
PLSQL_WARNINGS
VARCHAR2(4000)
NLS_LENGTH_SEMANTICS
VARCHAR2(4000)
PLSQL_CCFLAGS
VARCHAR2(4000)
DBA_POLICIES: All row level security policies in the database
iSelfSchooling-SQL> desc DBA_POLICIES;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
POLICY_GROUP
NOT
NULL VARCHAR2(30)
POLICY_NAME
NOT NULL VARCHAR2(30)
PF_OWNER
NOT NULL VARCHAR2(30)
PACKAGE
VARCHAR2(30)
FUNCTION
NOT NULL VARCHAR2(30)
SEL
VARCHAR2(3)
INS
VARCHAR2(3)
UPD
VARCHAR2(3)
DEL
VARCHAR2(3)
IDX
VARCHAR2(3)
CHK_OPTION
VARCHAR2(3)
ENABLE
VARCHAR2(3)
STATIC_POLICY
VARCHAR2(3)
POLICY_TYPE
VARCHAR2(24)
LONG_PREDICATE
VARCHAR2(3)
DBA_POLICY_CONTEXTS: All policy driving context defined for any
synonym, table, or view in the database
iSelfSchooling-SQL> desc DBA_POLICY_CONTEXTS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
NAMESPACE
NOT NULL VARCHAR2(30)
ATTRIBUTE
NOT NULL VARCHAR2(30)
DBA_POLICY_GROUPS: All policy groups defined for any synonym,
table, view in the database
iSelfSchooling-SQL> desc DBA_POLICY_GROUPS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
POLICY_GROUP
NOT NULL VARCHAR2(30)
DBA_PRIV_AUDIT_OPTS: Describes current system privileges being
audited across the system and by user
iSelfSchooling-SQL> desc DBA_PRIV_AUDIT_OPTS;
Name
Null? Type
----------------------------- -------- --------------------
USER_NAME
VARCHAR2(30)
PROXY_NAME
VARCHAR2(30)
PRIVILEGE
NOT NULL VARCHAR2(40)
SUCCESS
VARCHAR2(10)
FAILURE
VARCHAR2(10)
DBA_PROCEDURES: Description of all procedures
iSelfSchooling-SQL> desc DBA_PROCEDURES;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
PROCEDURE_NAME
VARCHAR2(30)
AGGREGATE
VARCHAR2(3)
PIPELINED
VARCHAR2(3)
IMPLTYPEOWNER
VARCHAR2(30)
IMPLTYPENAME
VARCHAR2(30)
PARALLEL
VARCHAR2(3)
INTERFACE
VARCHAR2(3)
DETERMINISTIC
VARCHAR2(3)
AUTHID
VARCHAR2(12)
DBA_PROFILES: Display all profiles and their limits
iSelfSchooling-SQL> desc DBA_PROFILES;
Name
Null? Type
-----------------------------
-------- --------------------
PROFILE
NOT NULL VARCHAR2(30)
RESOURCE_NAME
NOT NULL VARCHAR2(32)
RESOURCE_TYPE
VARCHAR2(8)
LIMIT
VARCHAR2(40)
DBA_PROPAGATIONS: treams propagation in the database
iSelfSchooling-SQL> desc DBA_PROPAGATION;
Name
Null? Type
----------------------------- -------- --------------------
PROPAGATION_NAME
NOT NULL VARCHAR2(30)
SOURCE_QUEUE_OWNER
VARCHAR2(30)
SOURCE_QUEUE_NAME
VARCHAR2(30)
DESTINATION_QUEUE_OWNER
VARCHAR2(30)
DESTINATION_QUEUE_NAME
VARCHAR2(30)
DESTINATION_DBLINK
VARCHAR2(128)
RULE_SET_OWNER
VARCHAR2(30)
RULE_SET_NAME
VARCHAR2(30)
NEGATIVE_RULE_SET_OWNER
VARCHAR2(30)
NEGATIVE_RULE_SET_NAME
VARCHAR2(30)
QUEUE_TO_QUEUE
VARCHAR2(5)
STATUS
VARCHAR2(8)
ERROR_MESSAGE
VARCHAR2(4000)
ERROR_DATE
DATE
DBA_PROXIES: Information about all proxy connections
iSelfSchooling-SQL> desc DBA_PROXIES;
Name
Null? Type
----------------------------- -------- --------------------
PROXY
VARCHAR2(30)
|