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)
DBA_ADVISOR_RATIONALE
iSelfSchooling-SQL> desc DBA_ADVISOR_RATIONALE;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
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
DBA_ADVISOR_RECOMMENDATIONS
iSelfSchooling-SQL> desc DBA_ADVISOR_RECOMMENDATIONS;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
VARCHAR2(30)
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
DBA_ADVISOR_SQLA_REC_SUM
iSelfSchooling-SQL> desc DBA_ADVISOR_SQLA_REC_SUM;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
VARCHAR2(30)
TASK_ID
NUMBER
TASK_NAME
VARCHAR2(30)
REC_ID
NUMBER
TOTAL_STMTS
NUMBER
TOTAL_PRECOST
NUMBER
TOTAL_POSTCOST
NUMBER
DBA_ADVISOR_SQLA_WK_MAP
iSelfSchooling-SQL> desc DBA_ADVISOR_SQLA_WK_MAP;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TASK_ID
NUMBER
TASK_NAME
VARCHAR2(30)
WORKLOAD_ID
NUMBER
WORKLOAD_NAME
VARCHAR2(30)
DBA_ADVISOR_SQLA_WK_STMTS
iSelfSchooling-SQL> desc DBA_ADVISOR_SQLA_WK_STMTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
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
POSTCOST
NUMBER
LAST_EXECUTION_DATE
DATE
PRIORITY
NUMBER
COMMAND_TYPE
NUMBER
STAT_PERIOD
NUMBER
SQL_TEXT
CLOB
IMPORTANCE
NUMBER
REC_ID
NUMBER
VALIDATED
NUMBER
DBA_ADVISOR_SQLW_COLVOL
iSelfSchooling-SQL> desc DBA_ADVISOR_SQLW_COLVOL;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
UPDATE_FREQ
NUMBER
UPDATED_ROWS
NUMBER
DBA_ADVISOR_SQLW_JOURNAL
iSelfSchooling-SQL> desc DBA_ADVISOR_SQLW_JOURNAL;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
JOURNAL_ENTRY_SEQ
NOT NULL NUMBER
JOURNAL_ENTRY_TYPE
VARCHAR2(12)
JOURNAL_ENTRY
VARCHAR2(4000)
DBA_ADVISOR_SQLW_PARAMETERS
iSelfSchooling-SQL> desc DBA_ADVISOR_SQLW_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
PARAMETER_NAME
NOT NULL VARCHAR2(30)
PARAMETER_VALUE
NOT NULL VARCHAR2(4000)
PARAMETER_TYPE
VARCHAR2(10)
DESCRIPTION
VARCHAR2(4000)
DBA_ADVISOR_SQLW_STMTS
iSelfSchooling-SQL> desc DBA_ADVISOR_SQLW_STMTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
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
OPTIMIZER_COST
NUMBER
LAST_EXECUTION_DATE
DATE
PRIORITY
NUMBER
COMMAND_TYPE
NUMBER
STAT_PERIOD
NUMBER
SQL_TEXT
CLOB
VALID
NUMBER
DBA_ADVISOR_SQLW_SUM
iSelfSchooling-SQL> desc DBA_ADVISOR_SQLW_SUM;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
CREATE_DATE
NOT NULL DATE
MODIFY_DATE
NOT NULL DATE
NUM_SELECT_STMT
NUMBER
NUM_UPDATE_STMT
NUMBER
NUM_DELETE_STMT
NUMBER
NUM_INSERT_STMT
NUMBER
NUM_MERGE_STMT
NUMBER
SOURCE
VARCHAR2(30)
HOW_CREATED
VARCHAR2(30)
DATA_SOURCE
VARCHAR2(2000)
READ_ONLY
VARCHAR2(5)
DBA_ADVISOR_SQLW_TABLES
iSelfSchooling-SQL> desc DBA_ADVISOR_SQLW_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
WORKLOAD_ID
NUMBER
WORKLOAD_NAME
VARCHAR2(30)
SQL_ID
NUMBER
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
DBA_ADVISOR_SQLW_TABVOL
iSelfSchooling-SQL> desc DBA_ADVISOR_SQLW_TABVOL;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
VARCHAR2(30)
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
UPDATE_FREQ
NUMBER
INSERT_FREQ
NUMBER
DELETE_FREQ
NUMBER
DIRECT_LOAD_FREQ
NUMBER
UPDATED_ROWS
NUMBER
INSERTED_ROWS
NUMBER
DELETED_ROWS
NUMBER
DIRECT_LOAD_ROWS
NUMBER
DBA_ADVISOR_SQLW_TEMPLATES
iSelfSchooling-SQL> desc DBA_ADVISOR_SQLW_TEMPLATES;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
WORKLOAD_ID
NOT NULL NUMBER
WORKLOAD_NAME
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
CREATE_DATE
NOT NULL DATE
MODIFY_DATE
NOT NULL DATE
SOURCE
VARCHAR2(30)
READ_ONLY
VARCHAR2(5)
DBA_ADVISOR_TASKS
iSelfSchooling-SQL> desc DBA_ADVISOR_TASKS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
ADVISOR_NAME
VARCHAR2(30)
CREATED
NOT NULL DATE
LAST_MODIFIED
NOT NULL DATE
PARENT_TASK_ID
NUMBER
PARENT_REC_ID
NUMBER
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)
SOURCE
VARCHAR2(30)
HOW_CREATED
VARCHAR2(30)
READ_ONLY
VARCHAR2(5)
ADVISOR_ID
NOT NULL NUMBER
DBA_ADVISOR_TEMPLATES
iSelfSchooling-SQL> desc DBA_ADVISOR_TEMPLATES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TASK_ID
NOT NULL NUMBER
TASK_NAME
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
ADVISOR_NAME
VARCHAR2(30)
CREATED
NOT NULL DATE
LAST_MODIFIED
NOT NULL DATE
SOURCE
VARCHAR2(30)
READ_ONLY
VARCHAR2(5)
DBA_ADVISOR_USAGE
iSelfSchooling-SQL> desc DBA_ADVISOR_USAGE;
Name
Null? Type
-----------------------------
-------- --------------------
ADVISOR_ID
NOT NULL NUMBER
LAST_EXEC_TIME
NOT NULL DATE
NUM_EXECS
NOT NULL NUMBER
DBA_ALERT_ARGUMENTS: Message Id and arguments of outstanding alerts
iSelfSchooling-SQL> desc DBA_ALERT_ARGUMENTS;
Name
Null? Type
----------------------------- -------- --------------------
SEQUENCE_ID
NUMBER
REASON_MESSAGE_ID
NUMBER
REASON_ARGUMENT_COUNT
NUMBER
REASON_ARGUMENT_1
VARCHAR2(581)
REASON_ARGUMENT_2
VARCHAR2(581)
REASON_ARGUMENT_3
VARCHAR2(581)
REASON_ARGUMENT_4
VARCHAR2(581)
REASON_ARGUMENT_5
VARCHAR2(581)
ACTION_MESSAGE_ID
NUMBER
ACTION_ARGUMENT_COUNT
NUMBER
ACTION_ARGUMENT_1
VARCHAR2(30)
ACTION_ARGUMENT_2
VARCHAR2(30)
ACTION_ARGUMENT_3
VARCHAR2(30)
ACTION_ARGUMENT_4
VARCHAR2(30)
ACTION_ARGUMENT_5
VARCHAR2(30)
DBA_ALERT_HISTORY: Description on alert history
iSelfSchooling-SQL> desc DBA_ALERT_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
SEQUENCE_ID
NOT NULL NUMBER
REASON_ID
NUMBER
OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(513)
SUBOBJECT_NAME
VARCHAR2(30)
OBJECT_TYPE
VARCHAR2(64)
REASON
VARCHAR2(4000)
TIME_SUGGESTED
TIMESTAMP(6)
CREATION_TIME
TIMESTAMP(6)
SUGGESTED_ACTION
VARCHAR2(4000)
ADVISOR_NAME
VARCHAR2(30)
METRIC_VALUE
NUMBER
MESSAGE_TYPE
VARCHAR2(12)
MESSAGE_GROUP
VARCHAR2(64)
MESSAGE_LEVEL
NUMBER
HOSTING_CLIENT_ID
VARCHAR2(64)
MODULE_ID
VARCHAR2(64)
PROCESS_ID
VARCHAR2(128)
HOST_ID
VARCHAR2(256)
HOST_NW_ADDR
VARCHAR2(256)
INSTANCE_NAME
VARCHAR2(16)
INSTANCE_NUMBER
NUMBER
USER_ID
VARCHAR2(30)
EXECUTION_CONTEXT_ID
VARCHAR2(60)
ERROR_INSTANCE_ID
VARCHAR2(142)
RESOLUTION
VARCHAR2(7)
DBA_ALL_TABLES: Description of all object and relational tables
in the database
iSelfSchooling-SQL> desc DBA_ALL_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
TABLESPACE_NAME
VARCHAR2(30)
CLUSTER_NAME
VARCHAR2(30)
IOT_NAME
VARCHAR2(30)
STATUS
VARCHAR2(8)
PCT_FREE
NUMBER
PCT_USED
NUMBER
INI_TRANS
NUMBER
MAX_TRANS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(3)
BACKED_UP
VARCHAR2(1)
NUM_ROWS
NUMBER
BLOCKS
NUMBER
EMPTY_BLOCKS
NUMBER
AVG_SPACE
NUMBER
CHAIN_CNT
NUMBER
AVG_ROW_LEN
NUMBER
AVG_SPACE_FREELIST_BLOCKS
NUMBER
NUM_FREELIST_BLOCKS
NUMBER
DEGREE
VARCHAR2(10)
INSTANCES
VARCHAR2(10)
CACHE
VARCHAR2(5)
TABLE_LOCK
VARCHAR2(8)
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
PARTITIONED
VARCHAR2(3)
IOT_TYPE
VARCHAR2(12)
OBJECT_ID_TYPE
VARCHAR2(16)
TABLE_TYPE_OWNER
VARCHAR2(30)
TABLE_TYPE
VARCHAR2(30)
TEMPORARY
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
NESTED
VARCHAR2(3)
BUFFER_POOL
VARCHAR2(7)
ROW_MOVEMENT
VARCHAR2(8)
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
DURATION
VARCHAR2(15)
SKIP_CORRUPT
VARCHAR2(8)
MONITORING
VARCHAR2(3)
CLUSTER_OWNER
VARCHAR2(30)
DEPENDENCIES
VARCHAR2(8)
COMPRESSION
VARCHAR2(8)
DROPPED
VARCHAR2(3)
DBA_ANALYZE_OBJECTS
iSelfSchooling-SQL> desc DBA_ANALYZE_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
OBJECT_TYPE
VARCHAR2(7)
|