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