|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_2PC_NEIGHBORS: information about incoming and outgoing
connections for pending transactions
iSelfSchooling-SQL> desc DBA_2PC_NEIGHBORS;
Name
Null? Type
----------------------------- -------- --------------------
LOCAL_TRAN_ID
VARCHAR2(22)
IN_OUT
VARCHAR2(3)
DATABASE
VARCHAR2(128)
DBUSER_OWNER
VARCHAR2(30)
INTERFACE
VARCHAR2(1)
DBID
VARCHAR2(16)
SESS#
NUMBER(38)
BRANCH
VARCHAR2(128)
DBA_2PC_PENDING: info about distributed transactions
awaiting recovery
iSelfSchooling-SQL> desc DBA_2PC_PENDING;
Name
Null? Type
----------------------------- -------- --------------------
LOCAL_TRAN_ID
NOT NULL VARCHAR2(22)
GLOBAL_TRAN_ID
VARCHAR2(169)
STATE
NOT NULL VARCHAR2(16)
MIXED
VARCHAR2(3)
ADVICE
VARCHAR2(1)
TRAN_COMMENT
VARCHAR2(255)
FAIL_TIME
NOT NULL DATE
FORCE_TIME
DATE
RETRY_TIME
NOT NULL DATE
OS_USER
VARCHAR2(64)
OS_TERMINAL
VARCHAR2(255)
HOST
VARCHAR2(128)
DB_USER
VARCHAR2(30)
COMMIT#
VARCHAR2(16)
DBA_ADVISOR_ACTIONS
iSelfSchooling-SQL> desc DBA_ADVISOR_ACTIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
REC_ID
NOT NULL NUMBER
ACTION_ID
NOT NULL NUMBER
OBJECT_ID
NUMBER
COMMAND
VARCHAR2(64)
COMMAND_ID
NOT NULL NUMBER
FLAGS
NUMBER
ATTR1
VARCHAR2(4000)
ATTR2
VARCHAR2(4000)
ATTR3
VARCHAR2(4000)
ATTR4
VARCHAR2(4000)
ATTR5
CLOB
ATTR6
CLOB
NUM_ATTR1
NUMBER
NUM_ATTR2
NUMBER
NUM_ATTR3
NUMBER
NUM_ATTR4
NUMBER
NUM_ATTR5
NUMBER
MESSAGE
VARCHAR2(4000)
DBA_ADVISOR_COMMANDS
iSelfSchooling-SQL> desc DBA_ADVISOR_COMMANDS;
Name
Null? Type
----------------------------- -------- --------------------
COMMAND_ID
NUMBER
COMMAND_NAME
VARCHAR2(64)
DBA_ADVISOR_DEFINITIONS
iSelfSchooling-SQL> desc DBA_ADVISOR_DEFINITIONS;
Name
Null? Type
----------------------------- -------- --------------------
ADVISOR_ID
NOT NULL NUMBER
ADVISOR_NAME
NOT NULL VARCHAR2(30)
PROPERTY
NOT NULL NUMBER
DBA_ADVISOR_DEF_PARAMETERS
iSelfSchooling-SQL> desc DBA_ADVISOR_DEF_PARAMETERS;
Name
Null? Type
-----------------------------
-------- --------------------
ADVISOR_NAME
NOT NULL VARCHAR2(30)
PARAMETER_NAME
NOT NULL VARCHAR2(30)
PARAMETER_VALUE
NOT NULL VARCHAR2(4000)
PARAMETER_TYPE
VARCHAR2(10)
IS_DEFAULT
VARCHAR2(1)
IS_OUTPUT
VARCHAR2(1)
IS_MODIFIABLE_ANYTIME
VARCHAR2(1)
DESCRIPTION
VARCHAR2(4000)
DBA_ADVISOR_DIRECTIVES
iSelfSchooling-SQL> desc DBA_ADVISOR_DIRECTIVES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
SOURCE_TASK_ID
NUMBER
DIRECTIVE_ID
NOT NULL NUMBER
REC_OBJ_OWNER
VARCHAR2(30)
REC_OBJ_NAME
VARCHAR2(30)
REC_ID
NUMBER
REC_ACTION_ID
NUMBER
COMMAND
VARCHAR2(64)
ATTR1
VARCHAR2(2000)
ATTR2
VARCHAR2(2000)
ATTR3
VARCHAR2(2000)
ATTR4
VARCHAR2(2000)
ATTR5
CLOB
DBA_ADVISOR_FINDINGS
iSelfSchooling-SQL> desc DBA_ADVISOR_FINDINGS;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
VARCHAR2(30)
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
FINDING_ID
NOT NULL NUMBER
TYPE
VARCHAR2(11)
PARENT
NOT NULL NUMBER
OBJECT_ID
NUMBER
IMPACT_TYPE
VARCHAR2(4000)
IMPACT
NUMBER
MESSAGE
VARCHAR2(4000)
MORE_INFO
VARCHAR2(4000)
DBA_ADVISOR_JOURNAL
iSelfSchooling-SQL> desc DBA_ADVISOR_JOURNAL;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
JOURNAL_ENTRY_SEQ
NOT NULL NUMBER
JOURNAL_ENTRY_TYPE
VARCHAR2(12)
JOURNAL_ENTRY
VARCHAR2(4000)
DBA_ADVISOR_LOG
iSelfSchooling-SQL> desc DBA_ADVISOR_LOG;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
EXECUTION_START
DATE
EXECUTION_END
DATE
STATUS
VARCHAR2(11)
STATUS_MESSAGE
VARCHAR2(4000)
PCT_COMPLETION_TIME
NUMBER
PROGRESS_METRIC
NUMBER
METRIC_UNITS
VARCHAR2(64)
ACTIVITY_COUNTER
NUMBER
RECOMMENDATION_COUNT
NUMBER
ERROR_MESSAGE
VARCHAR2(4000)
DBA_ADVISOR_OBJECTS
iSelfSchooling-SQL> desc DBA_ADVISOR_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
OBJECT_ID
NOT NULL NUMBER
TYPE
VARCHAR2(64)
TYPE_ID
NOT NULL NUMBER
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
ATTR1
VARCHAR2(4000)
ATTR2
VARCHAR2(4000)
ATTR3
VARCHAR2(4000)
ATTR4
CLOB
ATTR5
VARCHAR2(4000)
OTHER
CLOB
DBA_ADVISOR_OBJECT_TYPES
iSelfSchooling-SQL> desc DBA_ADVISOR_OBJECT_TYPES;
Name
Null? Type
-----------------------------
-------- --------------------
OBJECT_TYPE_ID
NUMBER
OBJECT_TYPE
VARCHAR2(64)
DBA_ADVISOR_PARAMETERS
iSelfSchooling-SQL> desc DBA_ADVISOR_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
PARAMETER_NAME
NOT NULL VARCHAR2(30)
PARAMETER_VALUE
NOT NULL VARCHAR2(4000)
PARAMETER_TYPE
VARCHAR2(10)
IS_DEFAULT
VARCHAR2(1)
IS_OUTPUT
VARCHAR2(1)
IS_MODIFIABLE_ANYTIME
VARCHAR2(1)
DESCRIPTION
VARCHAR2(4000)
DBA_ADVISOR_PARAMETERS_PROJ
iSelfSchooling-SQL> desc DBA_ADVISOR_PARAMETERS_PROJ;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
PARAMETER_NAME
NOT NULL VARCHAR2(30)
PARAMETER_VALUE
NOT NULL VARCHAR2(4000)
PARAMETER_TYPE
VARCHAR2(10)
IS_DEFAULT
VARCHAR2(1)
IS_OUTPUT
VARCHAR2(1)
IS_MODIFIABLE_ANYTIME
VARCHAR2(1)
DESCRIPTION
VARCHAR2(4000)
|