|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_LOCK
iSelfSchooling-SQL> desc DBA_LOCK;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
LOCK_TYPE
VARCHAR2(26)
MODE_HELD
VARCHAR2(40)
MODE_REQUESTED
VARCHAR2(40)
LOCK_ID1
VARCHAR2(40)
LOCK_ID2
VARCHAR2(40)
LAST_CONVERT
NUMBER
BLOCKING_OTHERS
VARCHAR2(40)
DBA_LOCKS: Synonym for DBA_LOCK
iSelfSchooling-SQL> desc DBA_LOCKS;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
LOCK_TYPE
VARCHAR2(26)
MODE_HELD
VARCHAR2(40)
MODE_REQUESTED
VARCHAR2(40)
LOCK_ID1
VARCHAR2(40)
LOCK_ID2
VARCHAR2(40)
LAST_CONVERT
NUMBER
BLOCKING_OTHERS
VARCHAR2(40)
DBA_LOCK_INTERNAL
iSelfSchooling-SQL> desc DBA_LOCK_INTERNAL;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
LOCK_TYPE
VARCHAR2(56)
MODE_HELD
VARCHAR2(40)
MODE_REQUESTED
VARCHAR2(40)
LOCK_ID1
VARCHAR2(1130)
LOCK_ID2
VARCHAR2(40)
DBA_LOGMNR_LOG
iSelfSchooling-SQL> desc DBA_LOGMNR_LOG;
Name
Null? Type
----------------------------- -------- --------------------
LOGMNR_SESSION_ID
NOT NULL NUMBER
NAME
VARCHAR2(513)
DBID
NOT NULL NUMBER
RESETLOGS_SCN
NOT NULL NUMBER
RESETLOGS_TIME
NOT NULL NUMBER
MODIFIED_TIME
DATE
THREAD#
NOT NULL NUMBER
SEQUENCE#
NOT NULL NUMBER
FIRST_SCN
NOT NULL NUMBER
NEXT_SCN
NUMBER
FIRST_TIME
DATE
NEXT_TIME
DATE
DICTIONARY_BEGIN
VARCHAR2(3)
DICTIONARY_END
VARCHAR2(3)
KEEP
VARCHAR2(3)
SUSPECT
VARCHAR2(3)
DBA_LOGMNR_PURGED_LOG
iSelfSchooling-SQL> desc DBA_LOGMNR_PURGED_LOG;
Name
Null? Type
----------------------------- -------- --------------------
FILE_NAME
VARCHAR2(513)
DBA_LOGMNR_SESSION
iSelfSchooling-SQL> desc DBA_LOGMNR_SESSION;
Name
Null? Type
----------------------------- -------- --------------------
ID
NOT NULL NUMBER
NAME
NOT NULL VARCHAR2(128)
SOURCE_DATABASE
VARCHAR2(128)
SOURCE_DBID
NUMBER
SOURCE_RESETLOGS_SCN
NUMBER
SOURCE_RESETLOGS_TIME
NUMBER
FIRST_SCN
NUMBER
END_SCN
NUMBER
BRANCH_SCN
NUMBER
WAIT_FOR_LOG
VARCHAR2(3)
HOT_MINE
VARCHAR2(3)
SAFE_PURGE_SCN
NUMBER
CHECKPOINT_SCN
NUMBER
DBA_LOGSTDBY_EVENTS: Information on why logical standby events
iSelfSchooling-SQL> desc DBA_LOGSTDBY_EVENTS;
Name
Null? Type
----------------------------- -------- --------------------
EVENT_TIME
DATE
EVENT_TIMESTAMP
TIMESTAMP(6)
CURRENT_SCN
NUMBER
COMMIT_SCN
NUMBER
XIDUSN
NUMBER
XIDSLT
NUMBER
XIDSQN
NUMBER
EVENT
CLOB
STATUS_CODE
NUMBER
STATUS
VARCHAR2(2000)
DBA_LOGSTDBY_HISTORY: Information on processed, active, and pending
log streams
iSelfSchooling-SQL> desc DBA_LOGSTDBY_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
STREAM_SEQUENCE#
NUMBER
STATUS
VARCHAR2(16)
SOURCE
VARCHAR2(5)
DBID
NUMBER
FIRST_CHANGE#
NUMBER
LAST_CHANGE#
NUMBER
FIRST_TIME
DATE
LAST_TIME
DATE
DGNAME
VARCHAR2(255)
DBA_LOGSTDBY_LOG: List the information about received logs from
the primary
iSelfSchooling-SQL> desc DBA_LOGSTDBY_LOG;
Name
Null? Type
----------------------------- -------- --------------------
THREAD#
NOT NULL NUMBER
RESETLOGS_CHANGE#
NOT NULL NUMBER
RESETLOGS_ID
NOT NULL NUMBER
SEQUENCE#
NOT NULL NUMBER
FIRST_CHANGE#
NOT NULL NUMBER
NEXT_CHANGE#
NUMBER
FIRST_TIME
DATE
NEXT_TIME
DATE
FILE_NAME
VARCHAR2(513)
TIMESTAMP
DATE
DICT_BEGIN
VARCHAR2(3)
DICT_END
VARCHAR2(3)
APPLIED
VARCHAR2(8)
DBA_LOGSTDBY_NOT_UNIQUE: List of all the tables with out primary or
unique key not null constraints
iSelfSchooling-SQL> desc DBA_LOGSTDBY_NOT_UNIQUE;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
BAD_COLUMN
VARCHAR2(1)
DBA_LOGSTDBY_PARAMETERS: Miscellaneous options and settings for Logical
Standby
iSelfSchooling-SQL> desc DBA_LOGSTDBY_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
VALUE
VARCHAR2(2000)
DBA_LOGSTDBY_PROGRESS: List the SCN values describing read and apply
progress
iSelfSchooling-SQL> desc DBA_LOGSTDBY_PROGRESS;
Name
Null? Type
----------------------------- -------- --------------------
APPLIED_SCN
NUMBER
APPLIED_THREAD#
NUMBER
APPLIED_SEQUENCE#
NUMBER
APPLIED_TIME
DATE
READ_SCN
NUMBER
READ_THREAD#
NUMBER
READ_SEQUENCE#
NUMBER
READ_TIME
DATE
NEWEST_SCN
NUMBER
NEWEST_THREAD#
NUMBER
NEWEST_SEQUENCE#
NUMBER
NEWEST_TIME
DATE
DBA_LOGSTDBY_SKIP: List the skip settings chosen
iSelfSchooling-SQL> desc DBA_LOGSTDBY_SKIP;
Name
Null? Type
----------------------------- -------- --------------------
ERROR
VARCHAR2(1)
STATEMENT_OPT
VARCHAR2(30)
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
USE_LIKE
VARCHAR2(1)
ESC
VARCHAR2(1)
PROC
VARCHAR2(98)
DBA_LOGSTDBY_SKIP_TRANSACTION:
List
the transactions to be skipped
iSelfSchooling-SQL> desc DBA_LOGSTDBY_SKIP_TRANSACTION;
Name
Null? Type
----------------------------- -------- --------------------
XIDUSN
NUMBER
XIDSLT
NUMBER
XIDSQN
NUMBER
DBA_LOGSTDBY_UNSUPPORTED: List of all the columns that are not supported
by Logical Standby
iSelfSchooling-SQL> desc DBA_LOGSTDBY_UNSUPPORTED;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(106)
ATTRIBUTES
VARCHAR2(39)
DBA_LOG_GROUPS: Log group definitions on all tables
iSelfSchooling-SQL> desc DBA_LOG_GROUPS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
LOG_GROUP_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
LOG_GROUP_TYPE
VARCHAR2(19)
ALWAYS
VARCHAR2(11)
GENERATED
VARCHAR2(14)
DBA_LOG_GROUP_COLUMNS: Information about columns in log group
definitions |