|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_ADVISOR_ACTIONS
iSelfSchooling-SQL> desc USER_ADVISOR_ACTIONS;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_ADVISOR_DIRECTIVES
iSelfSchooling-SQL> desc USER_ADVISOR_DIRECTIVES;
Name
Null? Type
----------------------------- -------- --------------------
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
USER_ADVISOR_FINDINGS
iSelfSchooling-SQL> desc USER_ADVISOR_FINDINGS;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_ADVISOR_JOURNAL
iSelfSchooling-SQL> desc USER_ADVISOR_JOURNAL;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
JOURNAL_ENTRY_SEQ
NOT NULL NUMBER
JOURNAL_ENTRY_TYPE
VARCHAR2(12)
JOURNAL_ENTRY
VARCHAR2(4000)
USER_ADVISOR_LOG
iSelfSchooling-SQL> desc USER_ADVISOR_LOG;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_ADVISOR_OBJECTS
iSelfSchooling-SQL> desc USER_ADVISOR_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_ADVISOR_PARAMETERS
iSelfSchooling-SQL> desc USER_ADVISOR_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_ADVISOR_RATIONALE
iSelfSchooling-SQL> desc USER_ADVISOR_RATIONALE;
Name
Null?
Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
REC_ID
NUMBER
RATIONALE_ID
NOT NULL NUMBER
IMPACT_TYPE
VARCHAR2(4000)
IMPACT
NUMBER
MESSAGE
VARCHAR2(4000)
OBJECT_ID
NUMBER
TYPE
VARCHAR2(30)
ATTR1
VARCHAR2(4000)
ATTR2
VARCHAR2(4000)
ATTR3
VARCHAR2(4000)
ATTR4
VARCHAR2(4000)
ATTR5
CLOB
USER_ADVISOR_RECOMMENDATIONS
iSelfSchooling-SQL> desc USER_ADVISOR_RECOMMENDATIONS;
Name
Null? Type
----------------------------- -------- --------------------
REC_ID
NOT NULL NUMBER
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
FINDING_ID
NUMBER
TYPE
VARCHAR2(30)
RANK
NUMBER
PARENT_REC_IDS
VARCHAR2(4000)
BENEFIT_TYPE
VARCHAR2(4000)
BENEFIT
NUMBER
ANNOTATION_STATUS
VARCHAR2(11)
FLAGS
NUMBER
USER_ADVISOR_SQLA_REC_SUM
iSelfSchooling-SQL> desc USER_ADVISOR_SQLA_REC_SUM;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NUMBER
TASK_NAME
VARCHAR2(30)
REC_ID
NUMBER
TOTAL_STMTS
NUMBER
TOTAL_PRECOST
NUMBER
TOTAL_POSTCOST
NUMBER
USER_ADVISOR_SQLA_WK_MAP
iSelfSchooling-SQL> desc USER_ADVISOR_SQLA_WK_MAP;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NUMBER
TASK_NAME
VARCHAR2(30)
WORKLOAD_ID
NUMBER
WORKLOAD_NAME
VARCHAR2(30)
USER_ADVISOR_SQLA_WK_STMTS
iSelfSchooling-SQL> desc USER_ADVISOR_SQLA_WK_STMTS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
SQL_ID
NOT NULL NUMBER
HASH_VALUE
NUMBER
USERNAME
VARCHAR2(30)
MODULE
VARCHAR2(64)
ACTION
VARCHAR2(64)
CPU_TIME
NUMBER
BUFFER_GETS
NUMBER
DISK_READS
NUMBER
ELAPSED_TIME
NUMBER
ROWS_PROCESSED
NUMBER
EXECUTIONS
NUMBER
PRECOST
NUMBER
|