iSelfSchooling.com Since 1999 References | Search more | Oracle Syntax | Free Online Oracle Training

Home .Services Login Start Learning Certification . .Share your BELIEF(s)...

. Online Accounting     .Copyright & User Agreement   |

    .Vision      .Biography     .Acknowledgement
.Contact Us      .Comments/Suggestions       Email2aFriend    |

Complete Syntax | Oracle Functions | PL/SQL Syntax | SQL Syntax | Tables

Oracle Dictionary Tables

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)