ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_TAB_STATS_HISTORY: History of table statistics modifications
iSelfSchooling-SQL> desc DBA_TAB_STATS_HISTORY;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
STATS_UPDATE_TIME
TIMESTAMP(6)
DBA_TAB_SUBPARTITIONS
iSelfSchooling-SQL> desc DBA_TAB_SUBPARTITIONS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
HIGH_VALUE
LONG
HIGH_VALUE_LENGTH
NOT NULL NUMBER
SUBPARTITION_POSITION
NUMBER
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
PCT_FREE
NOT NULL NUMBER
PCT_USED
NUMBER
INI_TRANS
NOT NULL NUMBER
MAX_TRANS
NOT NULL NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENT
NOT NULL NUMBER
MAX_EXTENT
NOT NULL NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(3)
COMPRESSION
VARCHAR2(8)
NUM_ROWS
NUMBER
BLOCKS
NUMBER
EMPTY_BLOCKS
NUMBER
AVG_SPACE
NUMBER
CHAIN_CNT
NUMBER
AVG_ROW_LEN
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
BUFFER_POOL
VARCHAR2(7)
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
DBA_TEMPLATE_REFGROUPS: Table for maintaining refresh group information
for template.
iSelfSchooling-SQL> desc DBA_TEMPLATE_REFGROUPS;
Name
Null? Type
----------------------------- -------- --------------------
REFRESH_GROUP_ID
NOT NULL NUMBER
REFRESH_GROUP_NAME
NOT NULL VARCHAR2(30)
REFRESH_TEMPLATE_ID
NOT NULL NUMBER
REFRESH_TEMPLATE_NAME
NOT NULL VARCHAR2(30)
ROLLBACK_SEG
VARCHAR2(30)
START_DATE
VARCHAR2(200)
INTERVAL
VARCHAR2(200)
DBA_TEMPLATE_TARGETS: Internal table for tracking potential target
databases for templates.
iSelfSchooling-SQL> desc DBA_TEMPLATE_TARGETS;
Name
Null? Type
----------------------------- -------- --------------------
TEMPLATE_TARGET_ID
NOT NULL NUMBER
TARGET_DATABASE
NOT NULL VARCHAR2(128)
TARGET_COMMENT
VARCHAR2(2000)
CONNECT_STRING
VARCHAR2(4000)
DBA_TEMP_FILES: Information about database temp files
iSelfSchooling-SQL> desc DBA_TEMP_FILES;
Name
Null? Type
----------------------------- -------- --------------------
FILE_NAME
VARCHAR2(513)
FILE_ID
NUMBER
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
BYTES
NUMBER
BLOCKS
NUMBER
STATUS
CHAR(9)
RELATIVE_FNO
NUMBER
AUTOEXTENSIBLE
VARCHAR2(3)
MAXBYTES
NUMBER
MAXBLOCKS
NUMBER
INCREMENT_BY
NUMBER
USER_BYTES
NUMBER
USER_BLOCKS
NUMBER
DBA_THRESHOLDS: Description of all thresholds
iSelfSchooling-SQL> desc DBA_THRESHOLDS;
Name
Null? Type
----------------------------- -------- --------------------
METRICS_NAME
VARCHAR2(64)
WARNING_OPERATOR
VARCHAR2(12)
WARNING_VALUE
VARCHAR2(256)
CRITICAL_OPERATOR
VARCHAR2(12)
CRITICAL_VALUE
VARCHAR2(256)
OBSERVATION_PERIOD
NUMBER
CONSECUTIVE_OCCURRENCES
NUMBER
INSTANCE_NAME
VARCHAR2(16)
OBJECT_TYPE
VARCHAR2(64)
OBJECT_NAME
VARCHAR2(513)
STATUS
VARCHAR2(7)
DBA_TRANSFORMATIONS
iSelfSchooling-SQL> desc DBA_TRANSFORMATIONS;
Name
Null? Type
----------------------------- -------- --------------------
TRANSFORMATION_ID
NOT NULL NUMBER
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
FROM_TYPE
VARCHAR2(61)
TO_TYPE
VARCHAR2(91)
DBA_TRIGGERS: All triggers in the database
iSelfSchooling-SQL> desc DBA_TRIGGERS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TRIGGER_NAME
VARCHAR2(30)
TRIGGER_TYPE
VARCHAR2(16)
TRIGGERING_EVENT
VARCHAR2(227)
TABLE_OWNER
VARCHAR2(30)
BASE_OBJECT_TYPE
VARCHAR2(16)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
REFERENCING_NAMES
VARCHAR2(128)
WHEN_CLAUSE
VARCHAR2(4000)
STATUS
VARCHAR2(8)
DESCRIPTION
VARCHAR2(4000)
ACTION_TYPE
VARCHAR2(11)
TRIGGER_BODY
LONG
DBA_TRIGGER_COLS: Column usage in all triggers
iSelfSchooling-SQL> desc DBA_TRIGGER_COLS;
Name
Null? Type
----------------------------- -------- --------------------
TRIGGER_OWNER
VARCHAR2(30)
TRIGGER_NAME
VARCHAR2(30)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_LIST
VARCHAR2(3)
COLUMN_USAGE
VARCHAR2(17)
DBA_TSM_DESTINATION: Transparent session migration source session
statistics
iSelfSchooling-SQL> desc DBA_TSM_DESTINATION;
Name
Null? Type
----------------------------- -------- --------------------
SOURCE_DATABASE_NAME
VARCHAR2(4000)
DESTINATION_DATABASE_NAME
VARCHAR2(4000)
DESTINATION_INSTANCE_NAME
VARCHAR2(4000)
DESTINATION_INSTANCE_ID
VARCHAR2(4000)
DESTINATION_INST_START_TIME TIMESTAMP(6)
SEQUENCE#
NUMBER
DESTINATION_SID
NUMBER
DESTINATION_SERIAL#
NUMBER
DESTINATION_START_TIME
TIMESTAMP(6)
DESTINATION_END_TIME
TIMESTAMP(6)
DESTINATION_USER_NAME
NOT NULL VARCHAR2(30)
DESTINATION_SCHEMA_NAME
NOT NULL VARCHAR2(30)
DESTINATION_STATE
VARCHAR2(24)
DBA_TSM_HISTORY: Transparent session migration statistics
iSelfSchooling-SQL> desc DBA_TSM_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
SEQUENCE#
NUMBER
SOURCE_SID
NUMBER
SOURCE_SERIAL#
NUMBER
USER_NAME
NOT NULL VARCHAR2(30)
SCHEMA_NAME
NOT NULL VARCHAR2(30)
STATE
VARCHAR2(24)
COST
NUMBER
SOURCE
VARCHAR2(4000)
SOURCE_INSTANCE_ID
VARCHAR2(4000)
SOURCE_START_TIME
TIMESTAMP(6)
CONNECT_STRING
VARCHAR2(4000)
FAILURE_REASON
VARCHAR2(34)
DESTINATION_SID
NUMBER
DESTINATION_SERIAL#
NUMBER
DESTINATION_STATE
VARCHAR2(24)
DESTINATION
VARCHAR2(4000)
DESTINATION_INSTANCE_ID
VARCHAR2(4000)
DESTINATION_START_TIME
TIMESTAMP(6)
ROUNDTRIPS
NUMBER
START_TIME
TIMESTAMP(6)
END_TIME
TIMESTAMP(6)
DBA_TSM_SOURCE: Transparent session migration source session
statistics
iSelfSchooling-SQL> desc DBA_TSM_SOURCE;
Name
Null?
Type
----------------------------- -------- --------------------
SOURCE_DATABASE_NAME
VARCHAR2(4000)
SOURCE_INSTANCE_NAME
VARCHAR2(4000)
SOURCE_INSTANCE_ID
VARCHAR2(4000)
SOURCE_INSTANCE_START_TIME TIMESTAMP(6)
SEQUENCE#
NUMBER
SOURCE_SID
NUMBER
SOURCE_SERIAL#
NUMBER
SOURCE_STATE
VARCHAR2(24)
CONNECT_STRING
VARCHAR2(4000)
SOURCE_START_TIME
TIMESTAMP(6)
COST
NUMBER
FAILURE_REASON
VARCHAR2(34)
SOURCE_END_TIME
TIMESTAMP(6)
ROUNDTRIPS
NUMBER
SOURCE_USER_NAME
NOT NULL VARCHAR2(30)
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
DESTINATION_DATABASE_NAME
VARCHAR2(4000)
DBA_TS_QUOTAS: Tablespace quotas for all users
iSelfSchooling-SQL> desc DBA_TS_QUOTAS;
Name
Null? Type
----------------------------- -------- --------------------
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
USERNAME
NOT NULL VARCHAR2(30)
BYTES
NUMBER
MAX_BYTES
NUMBER
BLOCKS
NUMBER
MAX_BLOCKS
NUMBER
DROPPED
VARCHAR2(3)
DBA_TUNE_MVIEW: Catalog View to show the result after executing
TUNE_MVIEW() API
iSelfSchooling-SQL> desc DBA_TUNE_MVIEW;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TASK_NAME
VARCHAR2(30)
ACTION_ID
NOT NULL NUMBER
SCRIPT_TYPE
VARCHAR2(14)
STATEMENT
CLOB
DBA_TYPES: Description of all types in the database
iSelfSchooling-SQL> desc DBA_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TYPE_NAME
VARCHAR2(30)
TYPE_OID
RAW(16)
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
TYPEID
RAW(16)
DBA_TYPE_ATTRS: Description of attributes of all types in the
database
iSelfSchooling-SQL> desc DBA_TYPE_ATTRS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TYPE_NAME
VARCHAR2(30)
ATTR_NAME
VARCHAR2(30)
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
NUMBER
INHERITED
VARCHAR2(3)
DBA_TYPE_METHODS: Description of methods of all types in the
database
iSelfSchooling-SQL> desc DBA_TYPE_METHODS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TYPE_NAME
NOT NULL VARCHAR2(30)
METHOD_NAME
NOT NULL VARCHAR2(30)
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)
DBA_TYPE_VERSIONS: Description of each type version in the database
iSelfSchooling-SQL> desc DBA_TYPE_VERSIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TYPE_NAME
NOT NULL VARCHAR2(30)
VERSION#
NOT NULL NUMBER
TYPECODE
VARCHAR2(30)
STATUS
VARCHAR2(7)
LINE
NOT NULL NUMBER
TEXT
VARCHAR2(4000)
HASHCODE
RAW(17)
DBA_UNDO_EXTENTS: Extents comprising all segments in the system
managed undo tablespaces
iSelfSchooling-SQL> desc DBA_UNDO_EXTENTS;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
CHAR(3)
SEGMENT_NAME
NOT NULL VARCHAR2(30)
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
EXTENT_ID
NUMBER
FILE_ID
NOT NULL NUMBER
BLOCK_ID
NUMBER
BYTES
NUMBER
BLOCKS
NUMBER
RELATIVE_FNO
NUMBER
COMMIT_JTIME
NUMBER
COMMIT_WTIME
VARCHAR2(20)
STATUS
VARCHAR2(9)
DBA_UNUSED_COL_TABS: All tables with unused columns in the database
iSelfSchooling-SQL> desc DBA_UNUSED_COL_TABS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COUNT
NUMBER
DBA_UPDATABLE_COLUMNS: Description of dba updatable columns
iSelfSchooling-SQL> desc DBA_UPDATABLE_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
UPDATABLE
VARCHAR2(3)
INSERTABLE
VARCHAR2(3)
DELETABLE
VARCHAR2(3)
DBA_USERS: Information about all users of the database
iSelfSchooling-SQL> desc DBA_USERS;
Name
Null? Type
----------------------------- -------- --------------------
USERNAME
NOT NULL VARCHAR2(30)
USER_ID
NOT NULL NUMBER
PASSWORD
VARCHAR2(30)
ACCOUNT_STATUS
NOT NULL VARCHAR2(32)
LOCK_DATE
DATE
EXPIRY_DATE
DATE
DEFAULT_TABLESPACE
NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE
NOT NULL VARCHAR2(30)
CREATED
NOT NULL DATE
PROFILE
NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)
EXTERNAL_NAME
VARCHAR2(4000)
DBA_USTATS: All statistics collected on either tables or
indexes
iSelfSchooling-SQL> desc DBA_USTATS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
OBJECT_TYPE
VARCHAR2(6)
ASSOCIATION
VARCHAR2(8)
COLUMN_NAME
VARCHAR2(30)
STATSTYPE_SCHEMA
VARCHAR2(30)
STATSTYPE_NAME
VARCHAR2(30)
STATISTICS
RAW(2000)
DBA_VARRAYS: Description of varrays in tables accessible to
the user
iSelfSchooling-SQL> desc DBA_VARRAYS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
PARENT_TABLE_NAME
VARCHAR2(30)
PARENT_TABLE_COLUMN
VARCHAR2(4000)
TYPE_OWNER
VARCHAR2(30)
TYPE_NAME
VARCHAR2(30)
LOB_NAME
VARCHAR2(30)
STORAGE_SPEC VARCHAR2(30)
RETURN_TYPE
VARCHAR2(20)
ELEMENT_SUBSTITUTABLE
VARCHAR2(25)
DBA_VIEWS: Description of all views in the database
iSelfSchooling-SQL> desc DBA_VIEWS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
VIEW_NAME
NOT NULL VARCHAR2(30)
TEXT_LENGTH
NUMBER
TEXT
LONG
TYPE_TEXT_LENGTH
NUMBER
TYPE_TEXT
VARCHAR2(4000)
OID_TEXT_LENGTH
NUMBER
OID_TEXT
VARCHAR2(4000)
VIEW_TYPE_OWNER
VARCHAR2(30)
VIEW_TYPE
VARCHAR2(30)
SUPERVIEW_NAME
VARCHAR2(30)
DBA_WAITERS
iSelfSchooling-SQL> desc DBA_WAITERS;
Name
Null? Type
-----------------------------
-------- --------------------
WAITING_SESSION
NUMBER
HOLDING_SESSION
NUMBER
LOCK_TYPE
VARCHAR2(26)
MODE_HELD
VARCHAR2(40)
MODE_REQUESTED
VARCHAR2(40)
LOCK_ID1
NUMBER
LOCK_ID2
NUMBER
DBA_WARNING_SETTINGS: warning settings for all objects
iSelfSchooling-SQL> desc DBA_WARNING_SETTINGS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
OBJECT_ID
NOT NULL NUMBER
OBJECT_TYPE
VARCHAR2(12)
WARNING
VARCHAR2(40)
SETTING
VARCHAR2(7)
DBA_WORKSPACES
iSelfSchooling-SQL> desc DBA_WORKSPACES;
Name
Null? Type
-----------------------------
-------- --------------------
WORKSPACE
NOT NULL VARCHAR2(30)
PARENT_WORKSPACE
VARCHAR2(30)
PARENT_SAVEPOINT
VARCHAR2(30)
OWNER
VARCHAR2(30)
CREATETIME
DATE
DESCRIPTION
VARCHAR2(1000)
FREEZE_STATUS
VARCHAR2(8)
FREEZE_MODE
VARCHAR2(20)
FREEZE_WRITER
VARCHAR2(30)
SID
VARCHAR2(30)
SERIAL#
VARCHAR2(30)
FREEZE_OWNER
VARCHAR2(30)
SESSION_DURATION
VARCHAR2(3)
CURRENT_SESSION
VARCHAR2(3)
RESOLVE_STATUS
VARCHAR2(8)
RESOLVE_USER
VARCHAR2(30)
MP_ROOT_WORKSPACE
VARCHAR2(30)
DBA_WORKSPACE_SESSIONS
iSelfSchooling-SQL> desc DBA_WORKSPACE_SESSIONS;
Name
Null?
Type
----------------------------- -------- --------------------
USERNAME
VARCHAR2(30)
WORKSPACE
NOT NULL VARCHAR2(30)
SID
NUMBER
STATUS
VARCHAR2(8)
DBA_XML_INDEXES: Description of all XML indexes in the database
iSelfSchooling-SQL> desc DBA_XML_INDEXES;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
PATH_TABLE_NAME
NOT NULL VARCHAR2(30)
PATHS
XMLTYPE
DBA_XML_SCHEMAS: Description of all the XML Schemas registered
iSelfSchooling-SQL> desc DBA_XML_SCHEMAS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
SCHEMA_URL
VARCHAR2(700)
LOCAL
VARCHAR2(3)
SCHEMA
XMLTYPE(XMLSchema "h
ttp://xmlns.oracle.c
om/xdb/XDBSchema.xsd
" Element "schema")
INT_OBJNAME
VARCHAR2(4000)
QUAL_SCHEMA_URL
VARCHAR2(767)
HIER_TYPE
VARCHAR2(11)
DBA_XML_TABLES: Description of all XML tables in the database
iSelfSchooling-SQL> desc DBA_XML_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
XMLSCHEMA
VARCHAR2(700)
SCHEMA_OWNER
VARCHAR2(30)
ELEMENT_NAME
VARCHAR2(2000)
STORAGE_TYPE
VARCHAR2(17)
DBA_XML_TAB_COLS: Description of all XML tables in the database
iSelfSchooling-SQL> desc DBA_XML_TAB_COLS;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
XMLSCHEMA
VARCHAR2(700)
SCHEMA_OWNER
VARCHAR2(30)
ELEMENT_NAME
VARCHAR2(2000)
STORAGE_TYPE
VARCHAR2(17)
DBA_XML_VIEWS: Description of all XML views in the database
iSelfSchooling-SQL> desc DBA_XML_VIEWS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
VIEW_NAME
VARCHAR2(30)
XMLSCHEMA
VARCHAR2(700)
SCHEMA_OWNER
VARCHAR2(30)
ELEMENT_NAME
VARCHAR2(2000)
DBA_XML_VIEW_COLS: Description of all XML views in the database
iSelfSchooling-SQL> desc DBA_XML_VIEW_COLS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
VIEW_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
XMLSCHEMA
VARCHAR2(700)
SCHEMA_OWNER
VARCHAR2(30)
ELEMENT_NAME
VARCHAR2(2000)
|