Check all partioned and non-partioned tables & Indexes
SQL> set linesize 180
set pagesize 10000
column owner format a10
column index_type format a25
column table_name format a35
column index_name format a35
column partitioned format a10
column tablespace_name format a15
column partitioned format a20
SELECT dt.table_name,
di.owner,
di.INDEX_NAME,
di.INDEX_TYPE,
di.partitioned,
di.tablespace_name,
di.STATUS
FROM DBA_INDEXES di , DBA_TABLES dt
WHERE dt.table_name = di.table_name
AND di.table_name LIKE 'WR%'
order by di.partitioned, di.owner, dt.table_name;
TABLE_NAME OWNER INDEX_NAME INDEX_TYPE PARTITIONED TABLESPACE_NAME STATUS
----------------------------------- ---------- ----------------------------------- ------------------------- -------------------- --------------- --------
WRH$_ACTIVE_SESSION_HISTORY_BL SYS WRH$_ASH_BL_PK NORMAL NO SYSAUX VALID
WRH$_BG_EVENT_SUMMARY SYS WRH$_BG_EVENT_SUMMARY_PK NORMAL NO SYSAUX VALID
WRH$_BUFFERED_QUEUES SYS WRH$_BUFFERED_QUEUES_PK NORMAL NO SYSAUX VALID
WRH$_BUFFERED_SUBSCRIBERS SYS WRH$_BUFFERED_SUBSCRIBERS_PK NORMAL NO SYSAUX VALID
WRH$_BUFFER_POOL_STATISTICS SYS WRH$_BUFFER_POOL_STATS_PK NORMAL NO SYSAUX VALID
WRH$_CLUSTER_INTERCON SYS WRH$_CLUSTER_INTERCON_PK NORMAL NO SYSAUX VALID
WRH$_COMP_IOSTAT SYS WRH$_COMP_IOSTAT_PK NORMAL NO SYSAUX VALID
WRH$_CR_BLOCK_SERVER SYS WRH$_CR_BLOCK_SERVER_PK NORMAL NO SYSAUX VALID
WRH$_CURRENT_BLOCK_SERVER SYS WRH$_CURRENT_BLOCK_SERVER_PK NORMAL NO SYSAUX VALID
WRH$_DATAFILE SYS WRH$_DATAFILE_PK NORMAL NO SYSAUX VALID
WRH$_DB_CACHE_ADVICE_BL SYS WRH$_DB_CACHE_ADVICE_BL_PK NORMAL NO SYSAUX VALID
WRH$_DISPATCHER SYS WRH$_DISPATCHER_PK NORMAL NO SYSAUX VALID
WRH$_DLM_MISC_BL SYS WRH$_DLM_MISC_BL_PK NORMAL NO SYSAUX VALID
WRH$_DYN_REMASTER_STATS SYS WRH$_DYN_REMASTER_STATS_PK NORMAL NO SYSAUX VALID
WRH$_ENQUEUE_STAT SYS WRH$_ENQUEUE_STAT_PK NORMAL NO SYSAUX VALID
WRH$_EVENT_HISTOGRAM_BL SYS WRH$_EVENT_HISTOGRAM_BL_PK NORMAL NO SYSAUX VALID
WRH$_EVENT_NAME SYS WRH$_EVENT_NAME_PK NORMAL NO SYSAUX VALID
WRH$_FILEMETRIC_HISTORY SYS WRH$_FILEMETRIC_HISTORY_INDEX NORMAL NO SYSAUX VALID
WRH$_FILESTATXS_BL SYS WRH$_FILESTATXS_BL_PK NORMAL NO SYSAUX VALID
WRH$_IC_CLIENT_STATS SYS WRH$_IC_CLIENT_STATS_PK NORMAL NO SYSAUX VALID
WRH$_IC_DEVICE_STATS SYS WRH$_IC_DEVICE_STATS_PK NORMAL NO SYSAUX VALID
WRH$_INSTANCE_RECOVERY SYS WRH$_INSTANCE_RECOVERY_PK NORMAL NO SYSAUX VALID
WRH$_INST_CACHE_TRANSFER_BL SYS WRH$_INST_CACHE_TRANSFER_BL_PK NORMAL NO SYSAUX VALID
WRH$_INTERCONNECT_PINGS_BL SYS WRH$_INTERCONNECT_PINGS_BL_PK NORMAL NO SYSAUX VALID
WRH$_IOSTAT_DETAIL SYS WRH$_IOSTAT_DETAIL_PK NORMAL NO SYSAUX VALID
WRH$_IOSTAT_FILETYPE SYS WRH$_IOSTAT_FILETYPE_PK NORMAL NO SYSAUX VALID
WRH$_IOSTAT_FILETYPE_NAME SYS WRH$_IOSTAT_FILETYPE_NAME_PK NORMAL NO SYSAUX VALID
WRH$_IOSTAT_FUNCTION SYS WRH$_IOSTAT_FUNCTION_PK NORMAL NO SYSAUX VALID
WRH$_IOSTAT_FUNCTION_NAME SYS WRH$_IOSTAT_FUNCTION_NAME_PK NORMAL NO SYSAUX VALID
WRH$_JAVA_POOL_ADVICE SYS WRH$_JAVA_POOL_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_LATCH_BL SYS WRH$_LATCH_BL_PK NORMAL NO SYSAUX VALID
WRH$_LATCH_CHILDREN_BL SYS WRH$_LATCH_CHILDREN_BL_PK NORMAL NO SYSAUX VALID
WRH$_LATCH_MISSES_SUMMARY_BL SYS WRH$_LATCH_MISSES_SUMRY_BL_PK NORMAL NO SYSAUX VALID
WRH$_LATCH_NAME SYS WRH$_LATCH_NAME_PK NORMAL NO SYSAUX VALID
WRH$_LATCH_PARENT_BL SYS WRH$_LATCH_PARENT_BL_PK NORMAL NO SYSAUX VALID
WRH$_LIBRARYCACHE SYS WRH$_LIBRARYCACHE_PK NORMAL NO SYSAUX VALID
WRH$_LOG SYS WRH$_LOG_PK NORMAL NO SYSAUX VALID
WRH$_MEMORY_RESIZE_OPS SYS WRH$_MEMORY_RESIZE_OPS_PK NORMAL NO SYSAUX VALID
WRH$_MEMORY_TARGET_ADVICE SYS WRH$_MEMORY_TARGET_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_MEM_DYNAMIC_COMP SYS WRH$_MEM_DYNAMIC_COMP_PK NORMAL NO SYSAUX VALID
WRH$_METRIC_NAME SYS WRH$_METRIC_NAME_PK NORMAL NO SYSAUX VALID
WRH$_MUTEX_SLEEP SYS WRH$_MUTEX_SLEEP_PK NORMAL NO SYSAUX VALID
WRH$_MVPARAMETER_BL SYS WRH$_MVPARAMETER_BL_PK NORMAL NO SYSAUX VALID
WRH$_OPTIMIZER_ENV SYS WRH$_OPTIMIZER_ENV_PK NORMAL NO SYSAUX VALID
WRH$_OSSTAT_BL SYS WRH$_OSSTAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_OSSTAT_NAME SYS WRH$_OSSTAT_NAME_PK NORMAL NO SYSAUX VALID
WRH$_PARAMETER_BL SYS WRH$_PARAMETER_BL_PK NORMAL NO SYSAUX VALID
WRH$_PARAMETER_NAME SYS WRH$_PARAMETER_NAME_PK NORMAL NO SYSAUX VALID
WRH$_PERSISTENT_QMN_CACHE SYS WRH$_PERSISTENT_QMN_CACHE_PK NORMAL NO SYSAUX VALID
WRH$_PERSISTENT_QUEUES SYS WRH$_PERSISTENT_QUEUES_PK NORMAL NO SYSAUX VALID
WRH$_PERSISTENT_SUBSCRIBERS SYS WRH$_PERSISTENT_SUBSCRIBERS_PK NORMAL NO SYSAUX VALID
WRH$_PGASTAT SYS WRH$_PGASTAT_PK NORMAL NO SYSAUX VALID
WRH$_PGA_TARGET_ADVICE SYS WRH$_PGA_TARGET_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_PLAN_OPERATION_NAME SYS WRH$_PLAN_OPERATION_NAME_PK NORMAL NO SYSAUX VALID
WRH$_PLAN_OPTION_NAME SYS WRH$_PLAN_OPTION_NAME_PK NORMAL NO SYSAUX VALID
WRH$_PROCESS_MEMORY_SUMMARY SYS WRH$_PROCESS_MEM_SUMMARY_PK NORMAL NO SYSAUX VALID
WRH$_RESOURCE_LIMIT SYS WRH$_RESOURCE_LIMIT_PK NORMAL NO SYSAUX VALID
WRH$_ROWCACHE_SUMMARY_BL SYS WRH$_ROWCACHE_SUMMARY_BL_PK NORMAL NO SYSAUX VALID
WRH$_RSRC_CONSUMER_GROUP SYS WRH$_RSRC_CONSUMER_GROUP_PK NORMAL NO SYSAUX VALID
WRH$_RSRC_PLAN SYS WRH$_RSRC_PLAN_PK NORMAL NO SYSAUX VALID
WRH$_RULE_SET SYS WRH$_RULE_SET_PK NORMAL NO SYSAUX VALID
WRH$_SEG_STAT_BL SYS WRH$_SEG_STAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_SEG_STAT_OBJ SYS WRH$_SEG_STAT_OBJ_PK NORMAL NO SYSAUX VALID
WRH$_SEG_STAT_OBJ SYS WRH$_SEG_STAT_OBJ_INDEX NORMAL NO SYSAUX VALID
WRH$_SERVICE_NAME SYS WRH$_SERVICE_NAME_PK NORMAL NO SYSAUX VALID
WRH$_SERVICE_STAT_BL SYS WRH$_SERVICE_STAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_SERVICE_WAIT_CLASS_BL SYS WRH$_SERVICE_WAIT_CLASS_BL_PK NORMAL NO SYSAUX VALID
WRH$_SESSMETRIC_HISTORY SYS WRH$_SESSMETRIC_HISTORY_INDEX NORMAL NO SYSAUX VALID
WRH$_SESS_TIME_STATS SYS WRH$_SESS_TIME_STATS_PK NORMAL NO SYSAUX VALID
WRH$_SGA SYS WRH$_SGA_PK NORMAL NO SYSAUX VALID
WRH$_SGASTAT_BL SYS WRH$_SGASTAT_BL_U NORMAL NO SYSAUX VALID
WRH$_SGA_TARGET_ADVICE SYS WRH$_SGA_TARGET_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_SHARED_POOL_ADVICE SYS WRH$_SHARED_POOL_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_SHARED_SERVER_SUMMARY SYS WRH$_SHARED_SERVER_SUMMARY_PK NORMAL NO SYSAUX VALID
WRH$_SQLCOMMAND_NAME SYS WRH$_SQLCOMMAND_NAME_PK NORMAL NO SYSAUX VALID
WRH$_SQLSTAT_BL SYS WRH$_SQLSTAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_SQLSTAT_BL SYS WRH$_SQLSTAT_BL_INDEX NORMAL NO SYSAUX VALID
WRH$_SQLTEXT SYS WRH$_SQLTEXT_PK NORMAL NO SYSAUX VALID
WRH$_SQLTEXT SYS SYS_IL0000006331C00004$$ LOB NO SYSAUX VALID
WRH$_SQL_BIND_METADATA SYS WRH$_SQL_BIND_METADATA_PK NORMAL NO SYSAUX VALID
WRH$_SQL_PLAN SYS SYS_IL0000006339C00038$$ LOB NO SYSAUX VALID
WRH$_SQL_PLAN SYS WRH$_SQL_PLAN_PK NORMAL NO SYSAUX VALID
WRH$_SQL_SUMMARY SYS WRH$_SQL_SUMMARY_PK NORMAL NO SYSAUX VALID
WRH$_SQL_WORKAREA_HISTOGRAM SYS WRH$_SQL_WORKAREA_HIST_PK NORMAL NO SYSAUX VALID
WRH$_STAT_NAME SYS WRH$_STAT_NAME_PK NORMAL NO SYSAUX VALID
WRH$_STREAMS_APPLY_SUM SYS WRH$_STREAMS_APPLY_SUM_PK NORMAL NO SYSAUX VALID
WRH$_STREAMS_CAPTURE SYS WRH$_STREAMS_CAPTURE_PK NORMAL NO SYSAUX VALID
WRH$_STREAMS_POOL_ADVICE SYS WRH$_STREAMS_POOL_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_SYSMETRIC_HISTORY SYS WRH$_SYSMETRIC_HISTORY_INDEX NORMAL NO SYSAUX VALID
WRH$_SYSMETRIC_SUMMARY SYS WRH$_SYSMETRIC_SUMMARY_INDEX NORMAL NO SYSAUX VALID
WRH$_SYSSTAT_BL SYS WRH$_SYSSTAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_SYSTEM_EVENT_BL SYS WRH$_SYSTEM_EVENT_BL_PK NORMAL NO SYSAUX VALID
WRH$_SYS_TIME_MODEL_BL SYS WRH$_SYS_TIME_MODEL_BL_PK NORMAL NO SYSAUX VALID
WRH$_TABLESPACE SYS WRH$_TABLESPACE_PK NORMAL NO SYSAUX VALID
WRH$_TABLESPACE_SPACE_USAGE SYS WRH$_TS_SPACE_USAGE_IND NORMAL NO SYSAUX VALID
WRH$_TABLESPACE_STAT_BL SYS WRH$_TABLESPACE_STAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_TEMPFILE SYS WRH$_TEMPFILE_PK NORMAL NO SYSAUX VALID
WRH$_TEMPSTATXS SYS WRH$_TEMPSTATXS_PK NORMAL NO SYSAUX VALID
WRH$_THREAD SYS WRH$_THREAD_PK NORMAL NO SYSAUX VALID
WRH$_TOPLEVELCALL_NAME SYS WRH$_TOPLEVELCALL_NAME_PK NORMAL NO SYSAUX VALID
WRH$_UNDOSTAT SYS WRH$_UNDOSTAT_PK NORMAL NO SYSAUX VALID
WRH$_WAITCLASSMETRIC_HISTORY SYS WRH$_WAITCLASSMETRIC_HIST_IND NORMAL NO SYSAUX VALID
WRH$_WAITSTAT_BL SYS WRH$_WAITSTAT_BL_PK NORMAL NO SYSAUX VALID
WRI$_ADV_ACTIONS SYS SYS_IL0000005857C00011$$ LOB NO SYSAUX VALID
WRI$_ADV_ACTIONS SYS SYS_IL0000005857C00012$$ LOB NO SYSAUX VALID
WRI$_ADV_ACTIONS SYS WRI$_ADV_ACTIONS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_ADDM_FDG SYS SYS_C001863 NORMAL NO SYSAUX VALID
WRI$_ADV_ADDM_INST SYS SYS_C001860 NORMAL NO SYSAUX VALID
WRI$_ADV_ADDM_TASKS SYS SYS_C001857 NORMAL NO SYSAUX VALID
WRI$_ADV_ADDM_TASKS SYS WRI$_ADV_ADDM_TASKS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_DEFINITIONS SYS WRI$_ADV_DEFINITIONS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_DEF_EXEC_TYPES SYS WRI$_ADV_DEF_ACTION_PK NORMAL NO SYSAUX VALID
WRI$_ADV_DEF_PARAMETERS SYS WRI$_ADV_DEF_PARAMETERS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_DEFS SYS WRI$_ADV_DIR_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_DEFS SYS WRI$_ADV_DIR_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_INSTANCES SYS SYS_IL0000005878C00005$$ LOB NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_INSTANCES SYS WRI$_ADV_DIRINST_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_INSTANCES SYS WRI$_ADV_DIRINST_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_META SYS SYS_IL0000005873C00002$$ LOB NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_META SYS WRI$_ADV_DIRM_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_EXECUTIONS SYS WRI$_ADV_EXECS_IDX_03 NORMAL NO SYSAUX VALID
WRI$_ADV_EXECUTIONS SYS WRI$_ADV_EXECS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_EXECUTIONS SYS WRI$_ADV_EXECS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_EXECUTIONS SYS WRI$_ADV_EXECS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_EXEC_PARAMETERS SYS WRI$_ADV_EXEC_PARAMETERS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_FINDINGS SYS WRI$_ADV_FINDINGS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_FINDINGS SYS WRI$_ADV_FINDINGS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_FINDINGS SYS WRI$_ADV_FINDINGS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_INST_FDG SYS SYS_C001800 NORMAL NO SYSAUX VALID
WRI$_ADV_JOURNAL SYS WRI$_ADV_JOURNAL NORMAL NO SYSAUX VALID
WRI$_ADV_MESSAGE_GROUPS SYS WRI$_ADV_MSG_GRPS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_MESSAGE_GROUPS SYS WRI$_ADV_MESSAGE_GROUPS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_OBJECTS SYS WRI$_ADV_OBJECTS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_OBJECTS SYS SYS_IL0000005840C00008$$ LOB NO SYSAUX VALID
WRI$_ADV_OBJECTS SYS WRI$_ADV_OBJECTS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_OBJECTS SYS SYS_IL0000005840C00015$$ LOB NO SYSAUX VALID
WRI$_ADV_PARAMETERS SYS WRI$_ADV_PARAMETERS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_RATIONALE SYS SYS_IL0000005863C00014$$ LOB NO SYSAUX VALID
WRI$_ADV_RATIONALE SYS WRI$_ADV_RATIONALE_PK NORMAL NO SYSAUX VALID
WRI$_ADV_RECOMMENDATIONS SYS WRI$_ADV_REC_PK NORMAL NO SYSAUX VALID
WRI$_ADV_RECOMMENDATIONS SYS WRI$_ADV_RECS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_RECOMMENDATIONS SYS WRI$_ADV_RECS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_REC_ACTIONS SYS WRI$_ADV_REC_ACTIONS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_COLVOL SYS WRI$_ADV_SQLA_CV_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_FAKE_REG SYS WRI$_ADV_SQLA_FREG_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_MAP SYS WRI$_ADV_SQLA_MAP_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_STMTS SYS WRI$_ADV_SQLA_STMTS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_STMTS SYS WRI$_ADV_SQLA_STMTS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_SUM SYS WRI$_ADV_SQLA_SUM_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_TABLES SYS WRI$_ADV_SQLA_TABLES_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_TABVOL SYS WRI$_ADV_SQLA_TV_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_TMP SYS WRI$_ADV_SQLA_TMP_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_BINDS SYS WRI$_ADV_SQLT_BINDS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_BINDS SYS SYS_IL0000006237C00004$$ LOB NO SYSAUX VALID
WRI$_ADV_SQLT_PLANS SYS WRI$_ADV_SQLT_PLANS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_PLANS SYS SYS_IL0000005899C00040$$ LOB NO SYSAUX VALID
WRI$_ADV_SQLT_PLAN_HASH SYS WRI$_ADV_SQLT_PLAN_HASH_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_PLAN_HASH SYS WRI$_ADV_SQLT_PLAN_HASH_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_PLAN_STATS SYS SYS_IL0000005893C00014$$ LOB NO SYSAUX VALID
WRI$_ADV_SQLT_PLAN_STATS SYS SYS_IL0000005893C00023$$ LOB NO SYSAUX VALID
WRI$_ADV_SQLT_PLAN_STATS SYS WRI$_ADV_SQLT_PLAN_STATS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_RTN_PLAN SYS WRI$_ADV_SQLT_RTN_PLAN_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_STATISTICS SYS WRI$_ADV_SQLT_STATISTICS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLW_COLVOL SYS WRI$_ADV_SQLW_CV_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLW_STMTS SYS SYS_IL0000006935C00018$$ LOB NO SYSAUX VALID
WRI$_ADV_SQLW_STMTS SYS WRI$_ADV_SQLW_STMTS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLW_SUM SYS WRI$_ADV_SQLW_SUM_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLW_TABLES SYS WRI$_ADV_SQLW_TABLES_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLW_TABVOL SYS WRI$_ADV_SQLW_TV_PK NORMAL NO SYSAUX VALID
WRI$_ADV_TASKS SYS WRI$_ADV_TASKS_IDX_03 NORMAL NO SYSAUX VALID
WRI$_ADV_TASKS SYS WRI$_ADV_TASKS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_TASKS SYS WRI$_ADV_TASKS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_TASKS SYS WRI$_ADV_TASKS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_TASKS SYS WRI$_ADV_TASKS_IDX_04 NORMAL NO SYSAUX VALID
WRI$_ADV_USAGE SYS WRI$_ADV_USAGE_PK NORMAL NO SYSAUX VALID
WRI$_AGGREGATION_ENABLED SYS WRI$_AGGREGATION_IND1 NORMAL NO SYSAUX VALID
WRI$_ALERT_HISTORY SYS WRI$_ALERT_HISTORY_PK NORMAL NO SYSAUX VALID
WRI$_ALERT_OUTSTANDING SYS WRI$_ALERTS_OUTSTANDING_PK NORMAL NO SYSAUX VALID
WRI$_ALERT_THRESHOLD SYS WRI$_ALERT_THRESHOLD_PK NORMAL NO SYSAUX VALID
WRI$_ALERT_THRESHOLD_LOG SYS WRI$_ALERT_THRESHOLD_LOG_PK NORMAL NO SYSTEM VALID
WRI$_DBU_CPU_USAGE SYS WRI$_DBU_CPU_USAGE_PK NORMAL NO SYSAUX VALID
WRI$_DBU_CPU_USAGE_SAMPLE SYS WRI$_DBU_CPU_USAGE_SAMPLE_PK NORMAL NO SYSAUX VALID
WRI$_DBU_FEATURE_METADATA SYS WRI$_DBU_FEATURE_METADATA_PK NORMAL NO SYSAUX VALID
WRI$_DBU_FEATURE_METADATA SYS SYS_IL0000006149C00005$$ LOB NO SYSAUX VALID
WRI$_DBU_FEATURE_METADATA SYS SYS_IL0000006149C00003$$ LOB NO SYSAUX VALID
WRI$_DBU_FEATURE_USAGE SYS WRI$_DBU_FEATURE_USAGE_PK NORMAL NO SYSAUX VALID
WRI$_DBU_FEATURE_USAGE SYS SYS_IL0000006145C00008$$ LOB NO SYSAUX VALID
WRI$_DBU_HIGH_WATER_MARK SYS WRI$_DBU_HIGH_WATER_MARK_PK NORMAL NO SYSAUX VALID
WRI$_DBU_HWM_METADATA SYS WRI$_DBU_HWM_METADATA_PK NORMAL NO SYSAUX VALID
WRI$_DBU_HWM_METADATA SYS SYS_IL0000006157C00003$$ LOB NO SYSAUX VALID
WRI$_DBU_USAGE_SAMPLE SYS WRI$_DBU_USAGE_SAMPLE_PK NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_AUX_HISTORY SYS I_WRI$_OPTSTAT_AUX_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_HISTGRM_HISTORY SYS I_WRI$_OPTSTAT_H_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_HISTGRM_HISTORY SYS I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_HISTHEAD_HISTORY SYS I_WRI$_OPTSTAT_HH_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_HISTHEAD_HISTORY SYS I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_HISTHEAD_HISTORY SYS SYS_IL0000000471C00016$$ LOB NO SYSAUX VALID
WRI$_OPTSTAT_IND_HISTORY SYS I_WRI$_OPTSTAT_IND_OBJ#_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_IND_HISTORY SYS I_WRI$_OPTSTAT_IND_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_OPR SYS I_WRI$_OPTSTAT_OPR_STIME FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_SYNOPSIS_HEAD$ SYS I_WRI$_OPTSTAT_SYNOPHEAD NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_SYNOPSIS_HEAD$ SYS SYS_IL0000008822C00008$$ LOB NO SYSAUX VALID
WRI$_OPTSTAT_SYNOPSIS_HEAD$ SYS SYS_C003380 NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_SYNOPSIS_PARTGRP SYS I_WRI$_OPTSTAT_SYNOPPARTGRP NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_TAB_HISTORY SYS I_WRI$_OPTSTAT_TAB_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_TAB_HISTORY SYS I_WRI$_OPTSTAT_TAB_OBJ#_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_REPT_COMPONENTS SYS WRI$_REPT_COMPONENTS_PK NORMAL NO SYSAUX VALID
WRI$_REPT_COMPONENTS SYS WRI$_REPT_COMPONENTS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_REPT_FILES SYS WRI$_REPT_FILES_PK NORMAL NO SYSAUX VALID
WRI$_REPT_FILES SYS WRI$_REPT_FILES_IDX_01 NORMAL NO SYSAUX VALID
WRI$_REPT_FILES SYS SYS_IL0000005097C00005$$ LOB NO SYSAUX VALID
WRI$_REPT_FORMATS SYS WRI$_REPT_FORMATS_PK NORMAL NO SYSAUX VALID
WRI$_REPT_FORMATS SYS WRI$_REPT_FORMATS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_REPT_REPORTS SYS WRI$_REPT_REPORTS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_REPT_REPORTS SYS WRI$_REPT_REPORTS_PK NORMAL NO SYSAUX VALID
WRI$_SCH_CONTROL SYS WRM$_SCH_CONTROL_PK NORMAL NO SYSAUX VALID
WRI$_SCH_VOTES SYS WRM$_SCH_VOTES_PK NORMAL NO SYSAUX VALID
WRI$_SEGADV_CNTRLTAB SYS WRI$_SEGADV_CNTRLTAB_PK NORMAL NO SYSAUX VALID
WRI$_SEGADV_OBJLIST SYS WRI$_SEGADV_OBJLIST_IDX_TS NORMAL NO SYSAUX VALID
WRI$_SEGADV_OBJLIST SYS WRI$_SEGADV_OBJLIST_IDX_OBJ NORMAL NO SYSAUX VALID
WRI$_SEGADV_OBJLIST SYS WRI$_SEGADV_OBJLIST_IDX_OBJD NORMAL NO SYSAUX VALID
WRI$_SEGADV_OBJLIST SYS WRI$_SEGADV_OBJLIST_IDX_AID NORMAL NO SYSAUX VALID
WRI$_SQLSET_BINDS SYS SYS_IL0000006279C00004$$ LOB NO SYSAUX VALID
WRI$_SQLSET_BINDS SYS WRI$_SQLSET_BINDS_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_DEFINITIONS SYS WRI$_SQLSET_DEFINITIONS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_SQLSET_DEFINITIONS SYS WRI$_SQLSET_DEFINITIONS_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_MASK SYS SYS_IL0000006271C00004$$ LOB NO SYSAUX VALID
WRI$_SQLSET_MASK SYS WRI$_SQLSET_MASK_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_PLANS SYS WRI$_SQLSET_PLANS_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_PLANS_TOCAP SYS WRI$_SQLSET_PLANS_TOCAP_PK NORMAL NO VALID
WRI$_SQLSET_PLAN_LINES SYS WRI$_SQLSET_PLAN_LINES_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_PLAN_LINES SYS SYS_IL0000006275C00038$$ LOB NO SYSAUX VALID
WRI$_SQLSET_REFERENCES SYS WRI$_SQLSET_REFERENCES_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_STATEMENTS SYS WRI$_SQLSET_STATEMENTS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_SQLSET_STATEMENTS SYS WRI$_SQLSET_STATEMENTS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_SQLSET_STATEMENTS SYS WRI$_SQLSET_STATEMENTS_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_STATISTICS SYS WRI$_SQLSET_STATISTICS_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_WORKSPACE SYS WRI$_SQLSET_WORKSPACE_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_WORKSPACE SYS SYS_IL0000006283C00010$$ LOB NO SYSTEM VALID
WRI$_SQLSET_WORKSPACE SYS SYS_IL0000006283C00008$$ LOB NO SYSTEM VALID
WRI$_SQLSET_WORKSPACE SYS SYS_IL0000006283C00005$$ LOB NO SYSTEM VALID
WRI$_SQLSET_WORKSPACE_PLANS SYS WRI$_SQLSET_WORKSPACE_PLANS_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_WORKSPACE_PLANS SYS SYS_IL0000006291C00036$$ LOB NO SYSAUX VALID
WRI$_SQLTEXT_REFCOUNT SYS WRI$_SQLTEXT_REFCOUNT_PK NORMAL NO SYSAUX VALID
WRI$_TRACING_ENABLED SYS WRI$_TRACING_IND1 NORMAL NO SYSAUX VALID
WRM$_BASELINE SYS WRM$_BASELINE_PK NORMAL NO SYSAUX VALID
WRM$_BASELINE_DETAILS SYS WRM$_BASELINE_DETAILS_PK NORMAL NO SYSAUX VALID
WRM$_BASELINE_TEMPLATE SYS WRM$_BASELINE_TEMPLATE_PK NORMAL NO SYSAUX VALID
WRM$_COLORED_SQL SYS WRM$_COLORED_SQL_PK NORMAL NO SYSAUX VALID
WRM$_DATABASE_INSTANCE SYS WRM$_DATABASE_INSTANCE_PK NORMAL NO SYSAUX VALID
WRM$_SNAPSHOT SYS WRM$_SNAPSHOT_PK NORMAL NO SYSAUX VALID
WRM$_SNAPSHOT_DETAILS SYS WRM$_SNAPSHOT_DETAILS_INDEX NORMAL NO SYSAUX VALID
WRM$_SNAP_ERROR SYS WRM$_SNAP_ERROR_PK NORMAL NO SYSAUX VALID
WRM$_WR_CONTROL SYS WRM$_WR_CONTROL_PK NORMAL NO SYSAUX VALID
WRM$_WR_USAGE SYS WRM$_WR_USAGE_INDEX NORMAL NO SYSAUX VALID
WRR$_CAPTURES SYS WRR$_CAPTURES_PK NORMAL NO SYSTEM VALID
WRR$_CAPTURE_STATS SYS WRR$_CAPTURE_STATS_PK NORMAL NO SYSAUX VALID
WRR$_CONNECTION_MAP SYS WRR$_CONNECTION_MAP_PK NORMAL NO SYSAUX VALID
WRR$_FILTERS SYS WRR$_FILTERS_PK NORMAL NO SYSAUX VALID
WRR$_REPLAYS SYS WRR$_REPLAYS_PK NORMAL NO SYSTEM VALID
WRR$_REPLAY_DATA SYS WRR$_REPLAY_DATA_PK IOT - TOP NO SYSAUX VALID
WRR$_REPLAY_DIVERGENCE SYS WRR$_REPLAY_DIVERGENCE_PK NORMAL NO SYSAUX VALID
WRR$_REPLAY_FILTER_SET SYS WRR$_REPLAY_FILTER_SET_PK NORMAL NO SYSAUX VALID
WRR$_REPLAY_SCN_ORDER SYS WRR$_REPLAY_SCN_ORDER_PK IOT - TOP NO SYSAUX VALID
WRR$_REPLAY_SEQ_DATA SYS WRR$_REPLAY_SEQ_DATA_PK IOT - TOP NO SYSAUX VALID
WRR$_REPLAY_SQL_BINDS SYS WRR$_REPLAY_SQL_BINDS_PK NORMAL NO SYSAUX VALID
WRR$_REPLAY_SQL_TEXT SYS WRR$_REPLAY_SQL_TEXT_PK NORMAL NO SYSAUX VALID
WRR$_REPLAY_SQL_TEXT SYS SYS_IL0000006917C00003$$ LOB NO SYSAUX VALID
WRR$_REPLAY_STATS SYS WRR$_REPLAY_STATS_PK NORMAL NO SYSAUX VALID
WRR$_WORKLOAD_ATTRIBUTES SYS WRR$_WORKLOAD_ATTRIBUTES_PK IOT - TOP NO SYSAUX VALID
WRH$_ACTIVE_SESSION_HISTORY SYS WRH$_ACTIVE_SESSION_HISTORY_PK NORMAL YES N/A
WRH$_DB_CACHE_ADVICE SYS WRH$_DB_CACHE_ADVICE_PK NORMAL YES N/A
WRH$_DLM_MISC SYS WRH$_DLM_MISC_PK NORMAL YES N/A
WRH$_EVENT_HISTOGRAM SYS WRH$_EVENT_HISTOGRAM_PK NORMAL YES N/A
WRH$_FILESTATXS SYS WRH$_FILESTATXS_PK NORMAL YES N/A
WRH$_INST_CACHE_TRANSFER SYS WRH$_INST_CACHE_TRANSFER_PK NORMAL YES N/A
WRH$_INTERCONNECT_PINGS SYS WRH$_INTERCONNECT_PINGS_PK NORMAL YES N/A
WRH$_LATCH SYS WRH$_LATCH_PK NORMAL YES N/A
WRH$_LATCH_CHILDREN SYS WRH$_LATCH_CHILDREN_PK NORMAL YES N/A
WRH$_LATCH_MISSES_SUMMARY SYS WRH$_LATCH_MISSES_SUMMARY_PK NORMAL YES N/A
WRH$_LATCH_PARENT SYS WRH$_LATCH_PARENT_PK NORMAL YES N/A
WRH$_MVPARAMETER SYS WRH$_MVPARAMETER_PK NORMAL YES N/A
WRH$_OSSTAT SYS WRH$_OSSTAT_PK NORMAL YES N/A
WRH$_PARAMETER SYS WRH$_PARAMETER_PK NORMAL YES N/A
WRH$_ROWCACHE_SUMMARY SYS WRH$_ROWCACHE_SUMMARY_PK NORMAL YES N/A
WRH$_SEG_STAT SYS WRH$_SEG_STAT_PK NORMAL YES N/A
WRH$_SERVICE_STAT SYS WRH$_SERVICE_STAT_PK NORMAL YES N/A
WRH$_SERVICE_WAIT_CLASS SYS WRH$_SERVICE_WAIT_CLASS_PK NORMAL YES N/A
WRH$_SGASTAT SYS WRH$_SGASTAT_U NORMAL YES N/A
WRH$_SQLSTAT SYS WRH$_SQLSTAT_INDEX NORMAL YES N/A
WRH$_SQLSTAT SYS WRH$_SQLSTAT_PK NORMAL YES N/A
WRH$_SYSSTAT SYS WRH$_SYSSTAT_PK NORMAL YES N/A
WRH$_SYSTEM_EVENT SYS WRH$_SYSTEM_EVENT_PK NORMAL YES N/A
WRH$_SYS_TIME_MODEL SYS WRH$_SYS_TIME_MODEL_PK NORMAL YES N/A
WRH$_TABLESPACE_STAT SYS WRH$_TABLESPACE_STAT_PK NORMAL YES N/A
WRH$_WAITSTAT SYS WRH$_WAITSTAT_PK NORMAL YES N/A
296 rows selected.
Check all non-partioned tables & Indexes
SQL> set linesize 180
set pagesize 10000
column owner format a10
column index_type format a25
column table_name format a35
column index_name format a35
column partitioned format a10
column tablespace_name format a15
column partitioned format a20
SELECT dt.table_name,
di.owner,
di.INDEX_NAME,
di.INDEX_TYPE,
di.partitioned,
di.tablespace_name,
di.STATUS
FROM DBA_INDEXES di , DBA_TABLES dt
WHERE dt.table_name = di.table_name
AND di.table_name LIKE 'WR%'
AND di.partitioned='NO'
order by di.partitioned, di.owner, dt.table_name;
TABLE_NAME OWNER INDEX_NAME INDEX_TYPE PARTITIONED TABLESPACE_NAME STATUS
----------------------------------- ---------- ----------------------------------- ------------------------- -------------------- --------------- --------
WRH$_ACTIVE_SESSION_HISTORY_BL SYS WRH$_ASH_BL_PK NORMAL NO SYSAUX VALID
WRH$_BG_EVENT_SUMMARY SYS WRH$_BG_EVENT_SUMMARY_PK NORMAL NO SYSAUX VALID
WRH$_BUFFERED_QUEUES SYS WRH$_BUFFERED_QUEUES_PK NORMAL NO SYSAUX VALID
WRH$_BUFFERED_SUBSCRIBERS SYS WRH$_BUFFERED_SUBSCRIBERS_PK NORMAL NO SYSAUX VALID
WRH$_BUFFER_POOL_STATISTICS SYS WRH$_BUFFER_POOL_STATS_PK NORMAL NO SYSAUX VALID
WRH$_CLUSTER_INTERCON SYS WRH$_CLUSTER_INTERCON_PK NORMAL NO SYSAUX VALID
WRH$_COMP_IOSTAT SYS WRH$_COMP_IOSTAT_PK NORMAL NO SYSAUX VALID
WRH$_CR_BLOCK_SERVER SYS WRH$_CR_BLOCK_SERVER_PK NORMAL NO SYSAUX VALID
WRH$_CURRENT_BLOCK_SERVER SYS WRH$_CURRENT_BLOCK_SERVER_PK NORMAL NO SYSAUX VALID
WRH$_DATAFILE SYS WRH$_DATAFILE_PK NORMAL NO SYSAUX VALID
WRH$_DB_CACHE_ADVICE_BL SYS WRH$_DB_CACHE_ADVICE_BL_PK NORMAL NO SYSAUX VALID
WRH$_DISPATCHER SYS WRH$_DISPATCHER_PK NORMAL NO SYSAUX VALID
WRH$_DLM_MISC_BL SYS WRH$_DLM_MISC_BL_PK NORMAL NO SYSAUX VALID
WRH$_DYN_REMASTER_STATS SYS WRH$_DYN_REMASTER_STATS_PK NORMAL NO SYSAUX VALID
WRH$_ENQUEUE_STAT SYS WRH$_ENQUEUE_STAT_PK NORMAL NO SYSAUX VALID
WRH$_EVENT_HISTOGRAM_BL SYS WRH$_EVENT_HISTOGRAM_BL_PK NORMAL NO SYSAUX VALID
WRH$_EVENT_NAME SYS WRH$_EVENT_NAME_PK NORMAL NO SYSAUX VALID
WRH$_FILEMETRIC_HISTORY SYS WRH$_FILEMETRIC_HISTORY_INDEX NORMAL NO SYSAUX VALID
WRH$_FILESTATXS_BL SYS WRH$_FILESTATXS_BL_PK NORMAL NO SYSAUX VALID
WRH$_IC_CLIENT_STATS SYS WRH$_IC_CLIENT_STATS_PK NORMAL NO SYSAUX VALID
WRH$_IC_DEVICE_STATS SYS WRH$_IC_DEVICE_STATS_PK NORMAL NO SYSAUX VALID
WRH$_INSTANCE_RECOVERY SYS WRH$_INSTANCE_RECOVERY_PK NORMAL NO SYSAUX VALID
WRH$_INST_CACHE_TRANSFER_BL SYS WRH$_INST_CACHE_TRANSFER_BL_PK NORMAL NO SYSAUX VALID
WRH$_INTERCONNECT_PINGS_BL SYS WRH$_INTERCONNECT_PINGS_BL_PK NORMAL NO SYSAUX VALID
WRH$_IOSTAT_DETAIL SYS WRH$_IOSTAT_DETAIL_PK NORMAL NO SYSAUX VALID
WRH$_IOSTAT_FILETYPE SYS WRH$_IOSTAT_FILETYPE_PK NORMAL NO SYSAUX VALID
WRH$_IOSTAT_FILETYPE_NAME SYS WRH$_IOSTAT_FILETYPE_NAME_PK NORMAL NO SYSAUX VALID
WRH$_IOSTAT_FUNCTION SYS WRH$_IOSTAT_FUNCTION_PK NORMAL NO SYSAUX VALID
WRH$_IOSTAT_FUNCTION_NAME SYS WRH$_IOSTAT_FUNCTION_NAME_PK NORMAL NO SYSAUX VALID
WRH$_JAVA_POOL_ADVICE SYS WRH$_JAVA_POOL_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_LATCH_BL SYS WRH$_LATCH_BL_PK NORMAL NO SYSAUX VALID
WRH$_LATCH_CHILDREN_BL SYS WRH$_LATCH_CHILDREN_BL_PK NORMAL NO SYSAUX VALID
WRH$_LATCH_MISSES_SUMMARY_BL SYS WRH$_LATCH_MISSES_SUMRY_BL_PK NORMAL NO SYSAUX VALID
WRH$_LATCH_NAME SYS WRH$_LATCH_NAME_PK NORMAL NO SYSAUX VALID
WRH$_LATCH_PARENT_BL SYS WRH$_LATCH_PARENT_BL_PK NORMAL NO SYSAUX VALID
WRH$_LIBRARYCACHE SYS WRH$_LIBRARYCACHE_PK NORMAL NO SYSAUX VALID
WRH$_LOG SYS WRH$_LOG_PK NORMAL NO SYSAUX VALID
WRH$_MEMORY_RESIZE_OPS SYS WRH$_MEMORY_RESIZE_OPS_PK NORMAL NO SYSAUX VALID
WRH$_MEMORY_TARGET_ADVICE SYS WRH$_MEMORY_TARGET_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_MEM_DYNAMIC_COMP SYS WRH$_MEM_DYNAMIC_COMP_PK NORMAL NO SYSAUX VALID
WRH$_METRIC_NAME SYS WRH$_METRIC_NAME_PK NORMAL NO SYSAUX VALID
WRH$_MUTEX_SLEEP SYS WRH$_MUTEX_SLEEP_PK NORMAL NO SYSAUX VALID
WRH$_MVPARAMETER_BL SYS WRH$_MVPARAMETER_BL_PK NORMAL NO SYSAUX VALID
WRH$_OPTIMIZER_ENV SYS WRH$_OPTIMIZER_ENV_PK NORMAL NO SYSAUX VALID
WRH$_OSSTAT_BL SYS WRH$_OSSTAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_OSSTAT_NAME SYS WRH$_OSSTAT_NAME_PK NORMAL NO SYSAUX VALID
WRH$_PARAMETER_BL SYS WRH$_PARAMETER_BL_PK NORMAL NO SYSAUX VALID
WRH$_PARAMETER_NAME SYS WRH$_PARAMETER_NAME_PK NORMAL NO SYSAUX VALID
WRH$_PERSISTENT_QMN_CACHE SYS WRH$_PERSISTENT_QMN_CACHE_PK NORMAL NO SYSAUX VALID
WRH$_PERSISTENT_QUEUES SYS WRH$_PERSISTENT_QUEUES_PK NORMAL NO SYSAUX VALID
WRH$_PERSISTENT_SUBSCRIBERS SYS WRH$_PERSISTENT_SUBSCRIBERS_PK NORMAL NO SYSAUX VALID
WRH$_PGASTAT SYS WRH$_PGASTAT_PK NORMAL NO SYSAUX VALID
WRH$_PGA_TARGET_ADVICE SYS WRH$_PGA_TARGET_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_PLAN_OPERATION_NAME SYS WRH$_PLAN_OPERATION_NAME_PK NORMAL NO SYSAUX VALID
WRH$_PLAN_OPTION_NAME SYS WRH$_PLAN_OPTION_NAME_PK NORMAL NO SYSAUX VALID
WRH$_PROCESS_MEMORY_SUMMARY SYS WRH$_PROCESS_MEM_SUMMARY_PK NORMAL NO SYSAUX VALID
WRH$_RESOURCE_LIMIT SYS WRH$_RESOURCE_LIMIT_PK NORMAL NO SYSAUX VALID
WRH$_ROWCACHE_SUMMARY_BL SYS WRH$_ROWCACHE_SUMMARY_BL_PK NORMAL NO SYSAUX VALID
WRH$_RSRC_CONSUMER_GROUP SYS WRH$_RSRC_CONSUMER_GROUP_PK NORMAL NO SYSAUX VALID
WRH$_RSRC_PLAN SYS WRH$_RSRC_PLAN_PK NORMAL NO SYSAUX VALID
WRH$_RULE_SET SYS WRH$_RULE_SET_PK NORMAL NO SYSAUX VALID
WRH$_SEG_STAT_BL SYS WRH$_SEG_STAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_SEG_STAT_OBJ SYS WRH$_SEG_STAT_OBJ_PK NORMAL NO SYSAUX VALID
WRH$_SEG_STAT_OBJ SYS WRH$_SEG_STAT_OBJ_INDEX NORMAL NO SYSAUX VALID
WRH$_SERVICE_NAME SYS WRH$_SERVICE_NAME_PK NORMAL NO SYSAUX VALID
WRH$_SERVICE_STAT_BL SYS WRH$_SERVICE_STAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_SERVICE_WAIT_CLASS_BL SYS WRH$_SERVICE_WAIT_CLASS_BL_PK NORMAL NO SYSAUX VALID
WRH$_SESSMETRIC_HISTORY SYS WRH$_SESSMETRIC_HISTORY_INDEX NORMAL NO SYSAUX VALID
WRH$_SESS_TIME_STATS SYS WRH$_SESS_TIME_STATS_PK NORMAL NO SYSAUX VALID
WRH$_SGA SYS WRH$_SGA_PK NORMAL NO SYSAUX VALID
WRH$_SGASTAT_BL SYS WRH$_SGASTAT_BL_U NORMAL NO SYSAUX VALID
WRH$_SGA_TARGET_ADVICE SYS WRH$_SGA_TARGET_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_SHARED_POOL_ADVICE SYS WRH$_SHARED_POOL_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_SHARED_SERVER_SUMMARY SYS WRH$_SHARED_SERVER_SUMMARY_PK NORMAL NO SYSAUX VALID
WRH$_SQLCOMMAND_NAME SYS WRH$_SQLCOMMAND_NAME_PK NORMAL NO SYSAUX VALID
WRH$_SQLSTAT_BL SYS WRH$_SQLSTAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_SQLSTAT_BL SYS WRH$_SQLSTAT_BL_INDEX NORMAL NO SYSAUX VALID
WRH$_SQLTEXT SYS WRH$_SQLTEXT_PK NORMAL NO SYSAUX VALID
WRH$_SQLTEXT SYS SYS_IL0000006331C00004$$ LOB NO SYSAUX VALID
WRH$_SQL_BIND_METADATA SYS WRH$_SQL_BIND_METADATA_PK NORMAL NO SYSAUX VALID
WRH$_SQL_PLAN SYS SYS_IL0000006339C00038$$ LOB NO SYSAUX VALID
WRH$_SQL_PLAN SYS WRH$_SQL_PLAN_PK NORMAL NO SYSAUX VALID
WRH$_SQL_SUMMARY SYS WRH$_SQL_SUMMARY_PK NORMAL NO SYSAUX VALID
WRH$_SQL_WORKAREA_HISTOGRAM SYS WRH$_SQL_WORKAREA_HIST_PK NORMAL NO SYSAUX VALID
WRH$_STAT_NAME SYS WRH$_STAT_NAME_PK NORMAL NO SYSAUX VALID
WRH$_STREAMS_APPLY_SUM SYS WRH$_STREAMS_APPLY_SUM_PK NORMAL NO SYSAUX VALID
WRH$_STREAMS_CAPTURE SYS WRH$_STREAMS_CAPTURE_PK NORMAL NO SYSAUX VALID
WRH$_STREAMS_POOL_ADVICE SYS WRH$_STREAMS_POOL_ADVICE_PK NORMAL NO SYSAUX VALID
WRH$_SYSMETRIC_HISTORY SYS WRH$_SYSMETRIC_HISTORY_INDEX NORMAL NO SYSAUX VALID
WRH$_SYSMETRIC_SUMMARY SYS WRH$_SYSMETRIC_SUMMARY_INDEX NORMAL NO SYSAUX VALID
WRH$_SYSSTAT_BL SYS WRH$_SYSSTAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_SYSTEM_EVENT_BL SYS WRH$_SYSTEM_EVENT_BL_PK NORMAL NO SYSAUX VALID
WRH$_SYS_TIME_MODEL_BL SYS WRH$_SYS_TIME_MODEL_BL_PK NORMAL NO SYSAUX VALID
WRH$_TABLESPACE SYS WRH$_TABLESPACE_PK NORMAL NO SYSAUX VALID
WRH$_TABLESPACE_SPACE_USAGE SYS WRH$_TS_SPACE_USAGE_IND NORMAL NO SYSAUX VALID
WRH$_TABLESPACE_STAT_BL SYS WRH$_TABLESPACE_STAT_BL_PK NORMAL NO SYSAUX VALID
WRH$_TEMPFILE SYS WRH$_TEMPFILE_PK NORMAL NO SYSAUX VALID
WRH$_TEMPSTATXS SYS WRH$_TEMPSTATXS_PK NORMAL NO SYSAUX VALID
WRH$_THREAD SYS WRH$_THREAD_PK NORMAL NO SYSAUX VALID
WRH$_TOPLEVELCALL_NAME SYS WRH$_TOPLEVELCALL_NAME_PK NORMAL NO SYSAUX VALID
WRH$_UNDOSTAT SYS WRH$_UNDOSTAT_PK NORMAL NO SYSAUX VALID
WRH$_WAITCLASSMETRIC_HISTORY SYS WRH$_WAITCLASSMETRIC_HIST_IND NORMAL NO SYSAUX VALID
WRH$_WAITSTAT_BL SYS WRH$_WAITSTAT_BL_PK NORMAL NO SYSAUX VALID
WRI$_ADV_ACTIONS SYS SYS_IL0000005857C00011$$ LOB NO SYSAUX VALID
WRI$_ADV_ACTIONS SYS SYS_IL0000005857C00012$$ LOB NO SYSAUX VALID
WRI$_ADV_ACTIONS SYS WRI$_ADV_ACTIONS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_ADDM_FDG SYS SYS_C001863 NORMAL NO SYSAUX VALID
WRI$_ADV_ADDM_INST SYS SYS_C001860 NORMAL NO SYSAUX VALID
WRI$_ADV_ADDM_TASKS SYS WRI$_ADV_ADDM_TASKS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_ADDM_TASKS SYS SYS_C001857 NORMAL NO SYSAUX VALID
WRI$_ADV_DEFINITIONS SYS WRI$_ADV_DEFINITIONS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_DEF_EXEC_TYPES SYS WRI$_ADV_DEF_ACTION_PK NORMAL NO SYSAUX VALID
WRI$_ADV_DEF_PARAMETERS SYS WRI$_ADV_DEF_PARAMETERS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_DEFS SYS WRI$_ADV_DIR_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_DEFS SYS WRI$_ADV_DIR_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_INSTANCES SYS SYS_IL0000005878C00005$$ LOB NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_INSTANCES SYS WRI$_ADV_DIRINST_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_INSTANCES SYS WRI$_ADV_DIRINST_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_META SYS WRI$_ADV_DIRM_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_DIRECTIVE_META SYS SYS_IL0000005873C00002$$ LOB NO SYSAUX VALID
WRI$_ADV_EXECUTIONS SYS WRI$_ADV_EXECS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_EXECUTIONS SYS WRI$_ADV_EXECS_IDX_03 NORMAL NO SYSAUX VALID
WRI$_ADV_EXECUTIONS SYS WRI$_ADV_EXECS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_EXECUTIONS SYS WRI$_ADV_EXECS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_EXEC_PARAMETERS SYS WRI$_ADV_EXEC_PARAMETERS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_FINDINGS SYS WRI$_ADV_FINDINGS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_FINDINGS SYS WRI$_ADV_FINDINGS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_FINDINGS SYS WRI$_ADV_FINDINGS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_INST_FDG SYS SYS_C001800 NORMAL NO SYSAUX VALID
WRI$_ADV_JOURNAL SYS WRI$_ADV_JOURNAL NORMAL NO SYSAUX VALID
WRI$_ADV_MESSAGE_GROUPS SYS WRI$_ADV_MESSAGE_GROUPS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_MESSAGE_GROUPS SYS WRI$_ADV_MSG_GRPS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_OBJECTS SYS SYS_IL0000005840C00008$$ LOB NO SYSAUX VALID
WRI$_ADV_OBJECTS SYS SYS_IL0000005840C00015$$ LOB NO SYSAUX VALID
WRI$_ADV_OBJECTS SYS WRI$_ADV_OBJECTS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_OBJECTS SYS WRI$_ADV_OBJECTS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_PARAMETERS SYS WRI$_ADV_PARAMETERS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_RATIONALE SYS WRI$_ADV_RATIONALE_PK NORMAL NO SYSAUX VALID
WRI$_ADV_RATIONALE SYS SYS_IL0000005863C00014$$ LOB NO SYSAUX VALID
WRI$_ADV_RECOMMENDATIONS SYS WRI$_ADV_REC_PK NORMAL NO SYSAUX VALID
WRI$_ADV_RECOMMENDATIONS SYS WRI$_ADV_RECS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_RECOMMENDATIONS SYS WRI$_ADV_RECS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_REC_ACTIONS SYS WRI$_ADV_REC_ACTIONS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_COLVOL SYS WRI$_ADV_SQLA_CV_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_FAKE_REG SYS WRI$_ADV_SQLA_FREG_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_MAP SYS WRI$_ADV_SQLA_MAP_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_STMTS SYS WRI$_ADV_SQLA_STMTS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_STMTS SYS WRI$_ADV_SQLA_STMTS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_SUM SYS WRI$_ADV_SQLA_SUM_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_TABLES SYS WRI$_ADV_SQLA_TABLES_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_TABVOL SYS WRI$_ADV_SQLA_TV_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLA_TMP SYS WRI$_ADV_SQLA_TMP_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_BINDS SYS SYS_IL0000006237C00004$$ LOB NO SYSAUX VALID
WRI$_ADV_SQLT_BINDS SYS WRI$_ADV_SQLT_BINDS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_PLANS SYS SYS_IL0000005899C00040$$ LOB NO SYSAUX VALID
WRI$_ADV_SQLT_PLANS SYS WRI$_ADV_SQLT_PLANS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_PLAN_HASH SYS WRI$_ADV_SQLT_PLAN_HASH_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_PLAN_HASH SYS WRI$_ADV_SQLT_PLAN_HASH_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_PLAN_STATS SYS SYS_IL0000005893C00014$$ LOB NO SYSAUX VALID
WRI$_ADV_SQLT_PLAN_STATS SYS SYS_IL0000005893C00023$$ LOB NO SYSAUX VALID
WRI$_ADV_SQLT_PLAN_STATS SYS WRI$_ADV_SQLT_PLAN_STATS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_RTN_PLAN SYS WRI$_ADV_SQLT_RTN_PLAN_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLT_STATISTICS SYS WRI$_ADV_SQLT_STATISTICS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLW_COLVOL SYS WRI$_ADV_SQLW_CV_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLW_STMTS SYS SYS_IL0000006935C00018$$ LOB NO SYSAUX VALID
WRI$_ADV_SQLW_STMTS SYS WRI$_ADV_SQLW_STMTS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLW_SUM SYS WRI$_ADV_SQLW_SUM_PK NORMAL NO SYSAUX VALID
WRI$_ADV_SQLW_TABLES SYS WRI$_ADV_SQLW_TABLES_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_SQLW_TABVOL SYS WRI$_ADV_SQLW_TV_PK NORMAL NO SYSAUX VALID
WRI$_ADV_TASKS SYS WRI$_ADV_TASKS_IDX_03 NORMAL NO SYSAUX VALID
WRI$_ADV_TASKS SYS WRI$_ADV_TASKS_PK NORMAL NO SYSAUX VALID
WRI$_ADV_TASKS SYS WRI$_ADV_TASKS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_ADV_TASKS SYS WRI$_ADV_TASKS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_ADV_TASKS SYS WRI$_ADV_TASKS_IDX_04 NORMAL NO SYSAUX VALID
WRI$_ADV_USAGE SYS WRI$_ADV_USAGE_PK NORMAL NO SYSAUX VALID
WRI$_AGGREGATION_ENABLED SYS WRI$_AGGREGATION_IND1 NORMAL NO SYSAUX VALID
WRI$_ALERT_HISTORY SYS WRI$_ALERT_HISTORY_PK NORMAL NO SYSAUX VALID
WRI$_ALERT_OUTSTANDING SYS WRI$_ALERTS_OUTSTANDING_PK NORMAL NO SYSAUX VALID
WRI$_ALERT_THRESHOLD SYS WRI$_ALERT_THRESHOLD_PK NORMAL NO SYSAUX VALID
WRI$_ALERT_THRESHOLD_LOG SYS WRI$_ALERT_THRESHOLD_LOG_PK NORMAL NO SYSTEM VALID
WRI$_DBU_CPU_USAGE SYS WRI$_DBU_CPU_USAGE_PK NORMAL NO SYSAUX VALID
WRI$_DBU_CPU_USAGE_SAMPLE SYS WRI$_DBU_CPU_USAGE_SAMPLE_PK NORMAL NO SYSAUX VALID
WRI$_DBU_FEATURE_METADATA SYS SYS_IL0000006149C00003$$ LOB NO SYSAUX VALID
WRI$_DBU_FEATURE_METADATA SYS SYS_IL0000006149C00005$$ LOB NO SYSAUX VALID
WRI$_DBU_FEATURE_METADATA SYS WRI$_DBU_FEATURE_METADATA_PK NORMAL NO SYSAUX VALID
WRI$_DBU_FEATURE_USAGE SYS SYS_IL0000006145C00008$$ LOB NO SYSAUX VALID
WRI$_DBU_FEATURE_USAGE SYS WRI$_DBU_FEATURE_USAGE_PK NORMAL NO SYSAUX VALID
WRI$_DBU_HIGH_WATER_MARK SYS WRI$_DBU_HIGH_WATER_MARK_PK NORMAL NO SYSAUX VALID
WRI$_DBU_HWM_METADATA SYS SYS_IL0000006157C00003$$ LOB NO SYSAUX VALID
WRI$_DBU_HWM_METADATA SYS WRI$_DBU_HWM_METADATA_PK NORMAL NO SYSAUX VALID
WRI$_DBU_USAGE_SAMPLE SYS WRI$_DBU_USAGE_SAMPLE_PK NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_AUX_HISTORY SYS I_WRI$_OPTSTAT_AUX_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_HISTGRM_HISTORY SYS I_WRI$_OPTSTAT_H_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_HISTGRM_HISTORY SYS I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_HISTHEAD_HISTORY SYS I_WRI$_OPTSTAT_HH_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_HISTHEAD_HISTORY SYS I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_HISTHEAD_HISTORY SYS SYS_IL0000000471C00016$$ LOB NO SYSAUX VALID
WRI$_OPTSTAT_IND_HISTORY SYS I_WRI$_OPTSTAT_IND_OBJ#_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_IND_HISTORY SYS I_WRI$_OPTSTAT_IND_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_OPR SYS I_WRI$_OPTSTAT_OPR_STIME FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_SYNOPSIS_HEAD$ SYS SYS_C003380 NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_SYNOPSIS_HEAD$ SYS SYS_IL0000008822C00008$$ LOB NO SYSAUX VALID
WRI$_OPTSTAT_SYNOPSIS_HEAD$ SYS I_WRI$_OPTSTAT_SYNOPHEAD NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_SYNOPSIS_PARTGRP SYS I_WRI$_OPTSTAT_SYNOPPARTGRP NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_TAB_HISTORY SYS I_WRI$_OPTSTAT_TAB_OBJ#_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_OPTSTAT_TAB_HISTORY SYS I_WRI$_OPTSTAT_TAB_ST FUNCTION-BASED NORMAL NO SYSAUX VALID
WRI$_REPT_COMPONENTS SYS WRI$_REPT_COMPONENTS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_REPT_COMPONENTS SYS WRI$_REPT_COMPONENTS_PK NORMAL NO SYSAUX VALID
WRI$_REPT_FILES SYS SYS_IL0000005097C00005$$ LOB NO SYSAUX VALID
WRI$_REPT_FILES SYS WRI$_REPT_FILES_PK NORMAL NO SYSAUX VALID
WRI$_REPT_FILES SYS WRI$_REPT_FILES_IDX_01 NORMAL NO SYSAUX VALID
WRI$_REPT_FORMATS SYS WRI$_REPT_FORMATS_PK NORMAL NO SYSAUX VALID
WRI$_REPT_FORMATS SYS WRI$_REPT_FORMATS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_REPT_REPORTS SYS WRI$_REPT_REPORTS_PK NORMAL NO SYSAUX VALID
WRI$_REPT_REPORTS SYS WRI$_REPT_REPORTS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_SCH_CONTROL SYS WRM$_SCH_CONTROL_PK NORMAL NO SYSAUX VALID
WRI$_SCH_VOTES SYS WRM$_SCH_VOTES_PK NORMAL NO SYSAUX VALID
WRI$_SEGADV_CNTRLTAB SYS WRI$_SEGADV_CNTRLTAB_PK NORMAL NO SYSAUX VALID
WRI$_SEGADV_OBJLIST SYS WRI$_SEGADV_OBJLIST_IDX_TS NORMAL NO SYSAUX VALID
WRI$_SEGADV_OBJLIST SYS WRI$_SEGADV_OBJLIST_IDX_OBJD NORMAL NO SYSAUX VALID
WRI$_SEGADV_OBJLIST SYS WRI$_SEGADV_OBJLIST_IDX_OBJ NORMAL NO SYSAUX VALID
WRI$_SEGADV_OBJLIST SYS WRI$_SEGADV_OBJLIST_IDX_AID NORMAL NO SYSAUX VALID
WRI$_SQLSET_BINDS SYS WRI$_SQLSET_BINDS_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_BINDS SYS SYS_IL0000006279C00004$$ LOB NO SYSAUX VALID
WRI$_SQLSET_DEFINITIONS SYS WRI$_SQLSET_DEFINITIONS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_SQLSET_DEFINITIONS SYS WRI$_SQLSET_DEFINITIONS_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_MASK SYS WRI$_SQLSET_MASK_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_MASK SYS SYS_IL0000006271C00004$$ LOB NO SYSAUX VALID
WRI$_SQLSET_PLANS SYS WRI$_SQLSET_PLANS_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_PLANS_TOCAP SYS WRI$_SQLSET_PLANS_TOCAP_PK NORMAL NO VALID
WRI$_SQLSET_PLAN_LINES SYS WRI$_SQLSET_PLAN_LINES_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_PLAN_LINES SYS SYS_IL0000006275C00038$$ LOB NO SYSAUX VALID
WRI$_SQLSET_REFERENCES SYS WRI$_SQLSET_REFERENCES_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_STATEMENTS SYS WRI$_SQLSET_STATEMENTS_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_STATEMENTS SYS WRI$_SQLSET_STATEMENTS_IDX_02 NORMAL NO SYSAUX VALID
WRI$_SQLSET_STATEMENTS SYS WRI$_SQLSET_STATEMENTS_IDX_01 NORMAL NO SYSAUX VALID
WRI$_SQLSET_STATISTICS SYS WRI$_SQLSET_STATISTICS_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_WORKSPACE SYS SYS_IL0000006283C00005$$ LOB NO SYSTEM VALID
WRI$_SQLSET_WORKSPACE SYS SYS_IL0000006283C00010$$ LOB NO SYSTEM VALID
WRI$_SQLSET_WORKSPACE SYS SYS_IL0000006283C00008$$ LOB NO SYSTEM VALID
WRI$_SQLSET_WORKSPACE SYS WRI$_SQLSET_WORKSPACE_PK NORMAL NO SYSAUX VALID
WRI$_SQLSET_WORKSPACE_PLANS SYS SYS_IL0000006291C00036$$ LOB NO SYSAUX VALID
WRI$_SQLSET_WORKSPACE_PLANS SYS WRI$_SQLSET_WORKSPACE_PLANS_PK NORMAL NO SYSAUX VALID
WRI$_SQLTEXT_REFCOUNT SYS WRI$_SQLTEXT_REFCOUNT_PK NORMAL NO SYSAUX VALID
WRI$_TRACING_ENABLED SYS WRI$_TRACING_IND1 NORMAL NO SYSAUX VALID
WRM$_BASELINE SYS WRM$_BASELINE_PK NORMAL NO SYSAUX VALID
WRM$_BASELINE_DETAILS SYS WRM$_BASELINE_DETAILS_PK NORMAL NO SYSAUX VALID
WRM$_BASELINE_TEMPLATE SYS WRM$_BASELINE_TEMPLATE_PK NORMAL NO SYSAUX VALID
WRM$_COLORED_SQL SYS WRM$_COLORED_SQL_PK NORMAL NO SYSAUX VALID
WRM$_DATABASE_INSTANCE SYS WRM$_DATABASE_INSTANCE_PK NORMAL NO SYSAUX VALID
WRM$_SNAPSHOT SYS WRM$_SNAPSHOT_PK NORMAL NO SYSAUX VALID
WRM$_SNAPSHOT_DETAILS SYS WRM$_SNAPSHOT_DETAILS_INDEX NORMAL NO SYSAUX VALID
WRM$_SNAP_ERROR SYS WRM$_SNAP_ERROR_PK NORMAL NO SYSAUX VALID
WRM$_WR_CONTROL SYS WRM$_WR_CONTROL_PK NORMAL NO SYSAUX VALID
WRM$_WR_USAGE SYS WRM$_WR_USAGE_INDEX NORMAL NO SYSAUX VALID
WRR$_CAPTURES SYS WRR$_CAPTURES_PK NORMAL NO SYSTEM VALID
WRR$_CAPTURE_STATS SYS WRR$_CAPTURE_STATS_PK NORMAL NO SYSAUX VALID
WRR$_CONNECTION_MAP SYS WRR$_CONNECTION_MAP_PK NORMAL NO SYSAUX VALID
WRR$_FILTERS SYS WRR$_FILTERS_PK NORMAL NO SYSAUX VALID
WRR$_REPLAYS SYS WRR$_REPLAYS_PK NORMAL NO SYSTEM VALID
WRR$_REPLAY_DATA SYS WRR$_REPLAY_DATA_PK IOT - TOP NO SYSAUX VALID
WRR$_REPLAY_DIVERGENCE SYS WRR$_REPLAY_DIVERGENCE_PK NORMAL NO SYSAUX VALID
WRR$_REPLAY_FILTER_SET SYS WRR$_REPLAY_FILTER_SET_PK NORMAL NO SYSAUX VALID
WRR$_REPLAY_SCN_ORDER SYS WRR$_REPLAY_SCN_ORDER_PK IOT - TOP NO SYSAUX VALID
WRR$_REPLAY_SEQ_DATA SYS WRR$_REPLAY_SEQ_DATA_PK IOT - TOP NO SYSAUX VALID
WRR$_REPLAY_SQL_BINDS SYS WRR$_REPLAY_SQL_BINDS_PK NORMAL NO SYSAUX VALID
WRR$_REPLAY_SQL_TEXT SYS WRR$_REPLAY_SQL_TEXT_PK NORMAL NO SYSAUX VALID
WRR$_REPLAY_SQL_TEXT SYS SYS_IL0000006917C00003$$ LOB NO SYSAUX VALID
WRR$_REPLAY_STATS SYS WRR$_REPLAY_STATS_PK NORMAL NO SYSAUX VALID
WRR$_WORKLOAD_ATTRIBUTES SYS WRR$_WORKLOAD_ATTRIBUTES_PK IOT - TOP NO SYSAUX VALID
270 rows selected.
*******************************************************************************************************************************************
Analyze all non-partitioned tables
*******************************************************************************************************************************************
set linesize 150
SELECT 'analyze table '||di.owner||'.'||dt.table_name||' validate structure cascade online;'
FROM DBA_INDEXES di , DBA_TABLES dt
WHERE dt.table_name = di.table_name
AND di.table_name LIKE 'WR%'
AND di.partitioned='NO'
group by di.owner, dt.table_name
order by di.owner, dt.table_name;
'ANALYZETABLE'||DI.OWNER||'.'||DT.TABLE_NAME||'VALIDATESTRUCTURECASCADEONLINE;'
--------------------------------------------------------------------------------------------------------------
analyze table SYS.WRH$_ACTIVE_SESSION_HISTORY_BL validate structure cascade online;
analyze table SYS.WRH$_BG_EVENT_SUMMARY validate structure cascade online;
analyze table SYS.WRH$_BUFFERED_QUEUES validate structure cascade online;
analyze table SYS.WRH$_BUFFERED_SUBSCRIBERS validate structure cascade online;
analyze table SYS.WRH$_BUFFER_POOL_STATISTICS validate structure cascade online;
analyze table SYS.WRH$_CLUSTER_INTERCON validate structure cascade online;
analyze table SYS.WRH$_COMP_IOSTAT validate structure cascade online;
analyze table SYS.WRH$_CR_BLOCK_SERVER validate structure cascade online;
analyze table SYS.WRH$_CURRENT_BLOCK_SERVER validate structure cascade online;
analyze table SYS.WRH$_DATAFILE validate structure cascade online;
analyze table SYS.WRH$_DB_CACHE_ADVICE_BL validate structure cascade online;
analyze table SYS.WRH$_DISPATCHER validate structure cascade online;
analyze table SYS.WRH$_DLM_MISC_BL validate structure cascade online;
analyze table SYS.WRH$_DYN_REMASTER_STATS validate structure cascade online;
analyze table SYS.WRH$_ENQUEUE_STAT validate structure cascade online;
analyze table SYS.WRH$_EVENT_HISTOGRAM_BL validate structure cascade online;
analyze table SYS.WRH$_EVENT_NAME validate structure cascade online;
analyze table SYS.WRH$_FILEMETRIC_HISTORY validate structure cascade online;
analyze table SYS.WRH$_FILESTATXS_BL validate structure cascade online;
analyze table SYS.WRH$_IC_CLIENT_STATS validate structure cascade online;
analyze table SYS.WRH$_IC_DEVICE_STATS validate structure cascade online;
analyze table SYS.WRH$_INSTANCE_RECOVERY validate structure cascade online;
analyze table SYS.WRH$_INST_CACHE_TRANSFER_BL validate structure cascade online;
analyze table SYS.WRH$_INTERCONNECT_PINGS_BL validate structure cascade online;
analyze table SYS.WRH$_IOSTAT_DETAIL validate structure cascade online;
analyze table SYS.WRH$_IOSTAT_FILETYPE validate structure cascade online;
analyze table SYS.WRH$_IOSTAT_FILETYPE_NAME validate structure cascade online;
analyze table SYS.WRH$_IOSTAT_FUNCTION validate structure cascade online;
analyze table SYS.WRH$_IOSTAT_FUNCTION_NAME validate structure cascade online;
analyze table SYS.WRH$_JAVA_POOL_ADVICE validate structure cascade online;
analyze table SYS.WRH$_LATCH_BL validate structure cascade online;
analyze table SYS.WRH$_LATCH_CHILDREN_BL validate structure cascade online;
analyze table SYS.WRH$_LATCH_MISSES_SUMMARY_BL validate structure cascade online;
analyze table SYS.WRH$_LATCH_NAME validate structure cascade online;
analyze table SYS.WRH$_LATCH_PARENT_BL validate structure cascade online;
analyze table SYS.WRH$_LIBRARYCACHE validate structure cascade online;
analyze table SYS.WRH$_LOG validate structure cascade online;
analyze table SYS.WRH$_MEMORY_RESIZE_OPS validate structure cascade online;
analyze table SYS.WRH$_MEMORY_TARGET_ADVICE validate structure cascade online;
analyze table SYS.WRH$_MEM_DYNAMIC_COMP validate structure cascade online;
analyze table SYS.WRH$_METRIC_NAME validate structure cascade online;
analyze table SYS.WRH$_MUTEX_SLEEP validate structure cascade online;
analyze table SYS.WRH$_MVPARAMETER_BL validate structure cascade online;
analyze table SYS.WRH$_OPTIMIZER_ENV validate structure cascade online;
analyze table SYS.WRH$_OSSTAT_BL validate structure cascade online;
analyze table SYS.WRH$_OSSTAT_NAME validate structure cascade online;
analyze table SYS.WRH$_PARAMETER_BL validate structure cascade online;
analyze table SYS.WRH$_PARAMETER_NAME validate structure cascade online;
analyze table SYS.WRH$_PERSISTENT_QMN_CACHE validate structure cascade online;
analyze table SYS.WRH$_PERSISTENT_QUEUES validate structure cascade online;
analyze table SYS.WRH$_PERSISTENT_SUBSCRIBERS validate structure cascade online;
analyze table SYS.WRH$_PGASTAT validate structure cascade online;
analyze table SYS.WRH$_PGA_TARGET_ADVICE validate structure cascade online;
analyze table SYS.WRH$_PLAN_OPERATION_NAME validate structure cascade online;
analyze table SYS.WRH$_PLAN_OPTION_NAME validate structure cascade online;
analyze table SYS.WRH$_PROCESS_MEMORY_SUMMARY validate structure cascade online;
analyze table SYS.WRH$_RESOURCE_LIMIT validate structure cascade online;
analyze table SYS.WRH$_ROWCACHE_SUMMARY_BL validate structure cascade online;
analyze table SYS.WRH$_RSRC_CONSUMER_GROUP validate structure cascade online;
analyze table SYS.WRH$_RSRC_PLAN validate structure cascade online;
analyze table SYS.WRH$_RULE_SET validate structure cascade online;
analyze table SYS.WRH$_SEG_STAT_BL validate structure cascade online;
analyze table SYS.WRH$_SEG_STAT_OBJ validate structure cascade online;
analyze table SYS.WRH$_SERVICE_NAME validate structure cascade online;
analyze table SYS.WRH$_SERVICE_STAT_BL validate structure cascade online;
analyze table SYS.WRH$_SERVICE_WAIT_CLASS_BL validate structure cascade online;
analyze table SYS.WRH$_SESSMETRIC_HISTORY validate structure cascade online;
analyze table SYS.WRH$_SESS_TIME_STATS validate structure cascade online;
analyze table SYS.WRH$_SGA validate structure cascade online;
analyze table SYS.WRH$_SGASTAT_BL validate structure cascade online;
analyze table SYS.WRH$_SGA_TARGET_ADVICE validate structure cascade online;
analyze table SYS.WRH$_SHARED_POOL_ADVICE validate structure cascade online;
analyze table SYS.WRH$_SHARED_SERVER_SUMMARY validate structure cascade online;
analyze table SYS.WRH$_SQLCOMMAND_NAME validate structure cascade online;
analyze table SYS.WRH$_SQLSTAT_BL validate structure cascade online;
analyze table SYS.WRH$_SQLTEXT validate structure cascade online;
analyze table SYS.WRH$_SQL_BIND_METADATA validate structure cascade online;
analyze table SYS.WRH$_SQL_PLAN validate structure cascade online;
analyze table SYS.WRH$_SQL_SUMMARY validate structure cascade online;
analyze table SYS.WRH$_SQL_WORKAREA_HISTOGRAM validate structure cascade online;
analyze table SYS.WRH$_STAT_NAME validate structure cascade online;
analyze table SYS.WRH$_STREAMS_APPLY_SUM validate structure cascade online;
analyze table SYS.WRH$_STREAMS_CAPTURE validate structure cascade online;
analyze table SYS.WRH$_STREAMS_POOL_ADVICE validate structure cascade online;
analyze table SYS.WRH$_SYSMETRIC_HISTORY validate structure cascade online;
analyze table SYS.WRH$_SYSMETRIC_SUMMARY validate structure cascade online;
analyze table SYS.WRH$_SYSSTAT_BL validate structure cascade online;
analyze table SYS.WRH$_SYSTEM_EVENT_BL validate structure cascade online;
analyze table SYS.WRH$_SYS_TIME_MODEL_BL validate structure cascade online;
analyze table SYS.WRH$_TABLESPACE validate structure cascade online;
analyze table SYS.WRH$_TABLESPACE_SPACE_USAGE validate structure cascade online;
analyze table SYS.WRH$_TABLESPACE_STAT_BL validate structure cascade online;
analyze table SYS.WRH$_TEMPFILE validate structure cascade online;
analyze table SYS.WRH$_TEMPSTATXS validate structure cascade online;
analyze table SYS.WRH$_THREAD validate structure cascade online;
analyze table SYS.WRH$_TOPLEVELCALL_NAME validate structure cascade online;
analyze table SYS.WRH$_UNDOSTAT validate structure cascade online;
analyze table SYS.WRH$_WAITCLASSMETRIC_HISTORY validate structure cascade online;
analyze table SYS.WRH$_WAITSTAT_BL validate structure cascade online;
analyze table SYS.WRI$_ADV_ACTIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_ADDM_FDG validate structure cascade online;
analyze table SYS.WRI$_ADV_ADDM_INST validate structure cascade online;
analyze table SYS.WRI$_ADV_ADDM_TASKS validate structure cascade online;
analyze table SYS.WRI$_ADV_DEFINITIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_DEF_EXEC_TYPES validate structure cascade online;
analyze table SYS.WRI$_ADV_DEF_PARAMETERS validate structure cascade online;
analyze table SYS.WRI$_ADV_DIRECTIVE_DEFS validate structure cascade online;
analyze table SYS.WRI$_ADV_DIRECTIVE_INSTANCES validate structure cascade online;
analyze table SYS.WRI$_ADV_DIRECTIVE_META validate structure cascade online;
analyze table SYS.WRI$_ADV_EXECUTIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_EXEC_PARAMETERS validate structure cascade online;
analyze table SYS.WRI$_ADV_FINDINGS validate structure cascade online;
analyze table SYS.WRI$_ADV_INST_FDG validate structure cascade online;
analyze table SYS.WRI$_ADV_JOURNAL validate structure cascade online;
analyze table SYS.WRI$_ADV_MESSAGE_GROUPS validate structure cascade online;
analyze table SYS.WRI$_ADV_OBJECTS validate structure cascade online;
analyze table SYS.WRI$_ADV_PARAMETERS validate structure cascade online;
analyze table SYS.WRI$_ADV_RATIONALE validate structure cascade online;
analyze table SYS.WRI$_ADV_RECOMMENDATIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_REC_ACTIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_COLVOL validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_FAKE_REG validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_MAP validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_STMTS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_SUM validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_TABLES validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_TABVOL validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_TMP validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_BINDS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_PLANS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_PLAN_HASH validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_PLAN_STATS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_RTN_PLAN validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_STATISTICS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLW_COLVOL validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLW_STMTS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLW_SUM validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLW_TABLES validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLW_TABVOL validate structure cascade online;
analyze table SYS.WRI$_ADV_TASKS validate structure cascade online;
analyze table SYS.WRI$_ADV_USAGE validate structure cascade online;
analyze table SYS.WRI$_AGGREGATION_ENABLED validate structure cascade online;
analyze table SYS.WRI$_ALERT_HISTORY validate structure cascade online;
analyze table SYS.WRI$_ALERT_OUTSTANDING validate structure cascade online;
analyze table SYS.WRI$_ALERT_THRESHOLD validate structure cascade online;
analyze table SYS.WRI$_ALERT_THRESHOLD_LOG validate structure cascade online;
analyze table SYS.WRI$_DBU_CPU_USAGE validate structure cascade online;
analyze table SYS.WRI$_DBU_CPU_USAGE_SAMPLE validate structure cascade online;
analyze table SYS.WRI$_DBU_FEATURE_METADATA validate structure cascade online;
analyze table SYS.WRI$_DBU_FEATURE_USAGE validate structure cascade online;
analyze table SYS.WRI$_DBU_HIGH_WATER_MARK validate structure cascade online;
analyze table SYS.WRI$_DBU_HWM_METADATA validate structure cascade online;
analyze table SYS.WRI$_DBU_USAGE_SAMPLE validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_AUX_HISTORY validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_HISTGRM_HISTORY validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_IND_HISTORY validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_OPR validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_SYNOPSIS_HEAD$ validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_SYNOPSIS_PARTGRP validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_TAB_HISTORY validate structure cascade online;
analyze table SYS.WRI$_REPT_COMPONENTS validate structure cascade online;
analyze table SYS.WRI$_REPT_FILES validate structure cascade online;
analyze table SYS.WRI$_REPT_FORMATS validate structure cascade online;
analyze table SYS.WRI$_REPT_REPORTS validate structure cascade online;
analyze table SYS.WRI$_SCH_CONTROL validate structure cascade online;
analyze table SYS.WRI$_SCH_VOTES validate structure cascade online;
analyze table SYS.WRI$_SEGADV_CNTRLTAB validate structure cascade online;
analyze table SYS.WRI$_SEGADV_OBJLIST validate structure cascade online;
analyze table SYS.WRI$_SQLSET_BINDS validate structure cascade online;
analyze table SYS.WRI$_SQLSET_DEFINITIONS validate structure cascade online;
analyze table SYS.WRI$_SQLSET_MASK validate structure cascade online;
analyze table SYS.WRI$_SQLSET_PLANS validate structure cascade online;
analyze table SYS.WRI$_SQLSET_PLANS_TOCAP validate structure cascade online;
analyze table SYS.WRI$_SQLSET_PLAN_LINES validate structure cascade online;
analyze table SYS.WRI$_SQLSET_REFERENCES validate structure cascade online;
analyze table SYS.WRI$_SQLSET_STATEMENTS validate structure cascade online;
analyze table SYS.WRI$_SQLSET_STATISTICS validate structure cascade online;
analyze table SYS.WRI$_SQLSET_WORKSPACE validate structure cascade online;
analyze table SYS.WRI$_SQLSET_WORKSPACE_PLANS validate structure cascade online;
analyze table SYS.WRI$_SQLTEXT_REFCOUNT validate structure cascade online;
analyze table SYS.WRI$_TRACING_ENABLED validate structure cascade online;
analyze table SYS.WRM$_BASELINE validate structure cascade online;
analyze table SYS.WRM$_BASELINE_DETAILS validate structure cascade online;
analyze table SYS.WRM$_BASELINE_TEMPLATE validate structure cascade online;
analyze table SYS.WRM$_COLORED_SQL validate structure cascade online;
analyze table SYS.WRM$_DATABASE_INSTANCE validate structure cascade online;
analyze table SYS.WRM$_SNAPSHOT validate structure cascade online;
analyze table SYS.WRM$_SNAPSHOT_DETAILS validate structure cascade online;
analyze table SYS.WRM$_SNAP_ERROR validate structure cascade online;
analyze table SYS.WRM$_WR_CONTROL validate structure cascade online;
analyze table SYS.WRM$_WR_USAGE validate structure cascade online;
analyze table SYS.WRR$_CAPTURES validate structure cascade online;
analyze table SYS.WRR$_CAPTURE_STATS validate structure cascade online;
analyze table SYS.WRR$_CONNECTION_MAP validate structure cascade online;
analyze table SYS.WRR$_FILTERS validate structure cascade online;
analyze table SYS.WRR$_REPLAYS validate structure cascade online;
analyze table SYS.WRR$_REPLAY_DATA validate structure cascade online;
analyze table SYS.WRR$_REPLAY_DIVERGENCE validate structure cascade online;
analyze table SYS.WRR$_REPLAY_FILTER_SET validate structure cascade online;
analyze table SYS.WRR$_REPLAY_SCN_ORDER validate structure cascade online;
analyze table SYS.WRR$_REPLAY_SEQ_DATA validate structure cascade online;
analyze table SYS.WRR$_REPLAY_SQL_BINDS validate structure cascade online;
analyze table SYS.WRR$_REPLAY_SQL_TEXT validate structure cascade online;
analyze table SYS.WRR$_REPLAY_STATS validate structure cascade online;
analyze table SYS.WRR$_WORKLOAD_ATTRIBUTES validate structure cascade online;
206 rows selected.
*******************************************************************************************************************************************
Analyze all non-partitioned tables
******************************************************************************************************************************************
set linesize 150
set pagesize 10000
select 'analyze table '||owner||'.'||table_name||' validate structure cascade online;'
from dba_indexes
where TABLE_OWNER='SYS'
and table_name like 'WR%'
AND partitioned='NO'
group by owner, table_name
order by owner, table_name;
'ANALYZETABLE'||OWNER||'.'||TABLE_NAME||'VALIDATESTRUCTURECASCADEONLINE;'
--------------------------------------------------------------------------------------------------------------
analyze table SYS.WRH$_ACTIVE_SESSION_HISTORY_BL validate structure cascade online;
analyze table SYS.WRH$_BG_EVENT_SUMMARY validate structure cascade online;
analyze table SYS.WRH$_BUFFERED_QUEUES validate structure cascade online;
analyze table SYS.WRH$_BUFFERED_SUBSCRIBERS validate structure cascade online;
analyze table SYS.WRH$_BUFFER_POOL_STATISTICS validate structure cascade online;
analyze table SYS.WRH$_CLUSTER_INTERCON validate structure cascade online;
analyze table SYS.WRH$_COMP_IOSTAT validate structure cascade online;
analyze table SYS.WRH$_CR_BLOCK_SERVER validate structure cascade online;
analyze table SYS.WRH$_CURRENT_BLOCK_SERVER validate structure cascade online;
analyze table SYS.WRH$_DATAFILE validate structure cascade online;
analyze table SYS.WRH$_DB_CACHE_ADVICE_BL validate structure cascade online;
analyze table SYS.WRH$_DISPATCHER validate structure cascade online;
analyze table SYS.WRH$_DLM_MISC_BL validate structure cascade online;
analyze table SYS.WRH$_DYN_REMASTER_STATS validate structure cascade online;
analyze table SYS.WRH$_ENQUEUE_STAT validate structure cascade online;
analyze table SYS.WRH$_EVENT_HISTOGRAM_BL validate structure cascade online;
analyze table SYS.WRH$_EVENT_NAME validate structure cascade online;
analyze table SYS.WRH$_FILEMETRIC_HISTORY validate structure cascade online;
analyze table SYS.WRH$_FILESTATXS_BL validate structure cascade online;
analyze table SYS.WRH$_IC_CLIENT_STATS validate structure cascade online;
analyze table SYS.WRH$_IC_DEVICE_STATS validate structure cascade online;
analyze table SYS.WRH$_INSTANCE_RECOVERY validate structure cascade online;
analyze table SYS.WRH$_INST_CACHE_TRANSFER_BL validate structure cascade online;
analyze table SYS.WRH$_INTERCONNECT_PINGS_BL validate structure cascade online;
analyze table SYS.WRH$_IOSTAT_DETAIL validate structure cascade online;
analyze table SYS.WRH$_IOSTAT_FILETYPE validate structure cascade online;
analyze table SYS.WRH$_IOSTAT_FILETYPE_NAME validate structure cascade online;
analyze table SYS.WRH$_IOSTAT_FUNCTION validate structure cascade online;
analyze table SYS.WRH$_IOSTAT_FUNCTION_NAME validate structure cascade online;
analyze table SYS.WRH$_JAVA_POOL_ADVICE validate structure cascade online;
analyze table SYS.WRH$_LATCH_BL validate structure cascade online;
analyze table SYS.WRH$_LATCH_CHILDREN_BL validate structure cascade online;
analyze table SYS.WRH$_LATCH_MISSES_SUMMARY_BL validate structure cascade online;
analyze table SYS.WRH$_LATCH_NAME validate structure cascade online;
analyze table SYS.WRH$_LATCH_PARENT_BL validate structure cascade online;
analyze table SYS.WRH$_LIBRARYCACHE validate structure cascade online;
analyze table SYS.WRH$_LOG validate structure cascade online;
analyze table SYS.WRH$_MEMORY_RESIZE_OPS validate structure cascade online;
analyze table SYS.WRH$_MEMORY_TARGET_ADVICE validate structure cascade online;
analyze table SYS.WRH$_MEM_DYNAMIC_COMP validate structure cascade online;
analyze table SYS.WRH$_METRIC_NAME validate structure cascade online;
analyze table SYS.WRH$_MUTEX_SLEEP validate structure cascade online;
analyze table SYS.WRH$_MVPARAMETER_BL validate structure cascade online;
analyze table SYS.WRH$_OPTIMIZER_ENV validate structure cascade online;
analyze table SYS.WRH$_OSSTAT_BL validate structure cascade online;
analyze table SYS.WRH$_OSSTAT_NAME validate structure cascade online;
analyze table SYS.WRH$_PARAMETER_BL validate structure cascade online;
analyze table SYS.WRH$_PARAMETER_NAME validate structure cascade online;
analyze table SYS.WRH$_PERSISTENT_QMN_CACHE validate structure cascade online;
analyze table SYS.WRH$_PERSISTENT_QUEUES validate structure cascade online;
analyze table SYS.WRH$_PERSISTENT_SUBSCRIBERS validate structure cascade online;
analyze table SYS.WRH$_PGASTAT validate structure cascade online;
analyze table SYS.WRH$_PGA_TARGET_ADVICE validate structure cascade online;
analyze table SYS.WRH$_PLAN_OPERATION_NAME validate structure cascade online;
analyze table SYS.WRH$_PLAN_OPTION_NAME validate structure cascade online;
analyze table SYS.WRH$_PROCESS_MEMORY_SUMMARY validate structure cascade online;
analyze table SYS.WRH$_RESOURCE_LIMIT validate structure cascade online;
analyze table SYS.WRH$_ROWCACHE_SUMMARY_BL validate structure cascade online;
analyze table SYS.WRH$_RSRC_CONSUMER_GROUP validate structure cascade online;
analyze table SYS.WRH$_RSRC_PLAN validate structure cascade online;
analyze table SYS.WRH$_RULE_SET validate structure cascade online;
analyze table SYS.WRH$_SEG_STAT_BL validate structure cascade online;
analyze table SYS.WRH$_SEG_STAT_OBJ validate structure cascade online;
analyze table SYS.WRH$_SERVICE_NAME validate structure cascade online;
analyze table SYS.WRH$_SERVICE_STAT_BL validate structure cascade online;
analyze table SYS.WRH$_SERVICE_WAIT_CLASS_BL validate structure cascade online;
analyze table SYS.WRH$_SESSMETRIC_HISTORY validate structure cascade online;
analyze table SYS.WRH$_SESS_TIME_STATS validate structure cascade online;
analyze table SYS.WRH$_SGA validate structure cascade online;
analyze table SYS.WRH$_SGASTAT_BL validate structure cascade online;
analyze table SYS.WRH$_SGA_TARGET_ADVICE validate structure cascade online;
analyze table SYS.WRH$_SHARED_POOL_ADVICE validate structure cascade online;
analyze table SYS.WRH$_SHARED_SERVER_SUMMARY validate structure cascade online;
analyze table SYS.WRH$_SQLCOMMAND_NAME validate structure cascade online;
analyze table SYS.WRH$_SQLSTAT_BL validate structure cascade online;
analyze table SYS.WRH$_SQLTEXT validate structure cascade online;
analyze table SYS.WRH$_SQL_BIND_METADATA validate structure cascade online;
analyze table SYS.WRH$_SQL_PLAN validate structure cascade online;
analyze table SYS.WRH$_SQL_SUMMARY validate structure cascade online;
analyze table SYS.WRH$_SQL_WORKAREA_HISTOGRAM validate structure cascade online;
analyze table SYS.WRH$_STAT_NAME validate structure cascade online;
analyze table SYS.WRH$_STREAMS_APPLY_SUM validate structure cascade online;
analyze table SYS.WRH$_STREAMS_CAPTURE validate structure cascade online;
analyze table SYS.WRH$_STREAMS_POOL_ADVICE validate structure cascade online;
analyze table SYS.WRH$_SYSMETRIC_HISTORY validate structure cascade online;
analyze table SYS.WRH$_SYSMETRIC_SUMMARY validate structure cascade online;
analyze table SYS.WRH$_SYSSTAT_BL validate structure cascade online;
analyze table SYS.WRH$_SYSTEM_EVENT_BL validate structure cascade online;
analyze table SYS.WRH$_SYS_TIME_MODEL_BL validate structure cascade online;
analyze table SYS.WRH$_TABLESPACE validate structure cascade online;
analyze table SYS.WRH$_TABLESPACE_SPACE_USAGE validate structure cascade online;
analyze table SYS.WRH$_TABLESPACE_STAT_BL validate structure cascade online;
analyze table SYS.WRH$_TEMPFILE validate structure cascade online;
analyze table SYS.WRH$_TEMPSTATXS validate structure cascade online;
analyze table SYS.WRH$_THREAD validate structure cascade online;
analyze table SYS.WRH$_TOPLEVELCALL_NAME validate structure cascade online;
analyze table SYS.WRH$_UNDOSTAT validate structure cascade online;
analyze table SYS.WRH$_WAITCLASSMETRIC_HISTORY validate structure cascade online;
analyze table SYS.WRH$_WAITSTAT_BL validate structure cascade online;
analyze table SYS.WRI$_ADV_ACTIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_ADDM_FDG validate structure cascade online;
analyze table SYS.WRI$_ADV_ADDM_INST validate structure cascade online;
analyze table SYS.WRI$_ADV_ADDM_TASKS validate structure cascade online;
analyze table SYS.WRI$_ADV_DEFINITIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_DEF_EXEC_TYPES validate structure cascade online;
analyze table SYS.WRI$_ADV_DEF_PARAMETERS validate structure cascade online;
analyze table SYS.WRI$_ADV_DIRECTIVE_DEFS validate structure cascade online;
analyze table SYS.WRI$_ADV_DIRECTIVE_INSTANCES validate structure cascade online;
analyze table SYS.WRI$_ADV_DIRECTIVE_META validate structure cascade online;
analyze table SYS.WRI$_ADV_EXECUTIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_EXEC_PARAMETERS validate structure cascade online;
analyze table SYS.WRI$_ADV_FINDINGS validate structure cascade online;
analyze table SYS.WRI$_ADV_INST_FDG validate structure cascade online;
analyze table SYS.WRI$_ADV_JOURNAL validate structure cascade online;
analyze table SYS.WRI$_ADV_MESSAGE_GROUPS validate structure cascade online;
analyze table SYS.WRI$_ADV_OBJECTS validate structure cascade online;
analyze table SYS.WRI$_ADV_PARAMETERS validate structure cascade online;
analyze table SYS.WRI$_ADV_RATIONALE validate structure cascade online;
analyze table SYS.WRI$_ADV_RECOMMENDATIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_REC_ACTIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_COLVOL validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_FAKE_REG validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_MAP validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_STMTS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_SUM validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_TABLES validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_TABVOL validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLA_TMP validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_BINDS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_PLANS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_PLAN_HASH validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_PLAN_STATS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_RTN_PLAN validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_STATISTICS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLW_COLVOL validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLW_STMTS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLW_SUM validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLW_TABLES validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLW_TABVOL validate structure cascade online;
analyze table SYS.WRI$_ADV_TASKS validate structure cascade online;
analyze table SYS.WRI$_ADV_USAGE validate structure cascade online;
analyze table SYS.WRI$_AGGREGATION_ENABLED validate structure cascade online;
analyze table SYS.WRI$_ALERT_HISTORY validate structure cascade online;
analyze table SYS.WRI$_ALERT_OUTSTANDING validate structure cascade online;
analyze table SYS.WRI$_ALERT_THRESHOLD validate structure cascade online;
analyze table SYS.WRI$_ALERT_THRESHOLD_LOG validate structure cascade online;
analyze table SYS.WRI$_DBU_CPU_USAGE validate structure cascade online;
analyze table SYS.WRI$_DBU_CPU_USAGE_SAMPLE validate structure cascade online;
analyze table SYS.WRI$_DBU_FEATURE_METADATA validate structure cascade online;
analyze table SYS.WRI$_DBU_FEATURE_USAGE validate structure cascade online;
analyze table SYS.WRI$_DBU_HIGH_WATER_MARK validate structure cascade online;
analyze table SYS.WRI$_DBU_HWM_METADATA validate structure cascade online;
analyze table SYS.WRI$_DBU_USAGE_SAMPLE validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_AUX_HISTORY validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_HISTGRM_HISTORY validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_IND_HISTORY validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_OPR validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_SYNOPSIS_HEAD$ validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_SYNOPSIS_PARTGRP validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_TAB_HISTORY validate structure cascade online;
analyze table SYS.WRI$_REPT_COMPONENTS validate structure cascade online;
analyze table SYS.WRI$_REPT_FILES validate structure cascade online;
analyze table SYS.WRI$_REPT_FORMATS validate structure cascade online;
analyze table SYS.WRI$_REPT_REPORTS validate structure cascade online;
analyze table SYS.WRI$_SCH_CONTROL validate structure cascade online;
analyze table SYS.WRI$_SCH_VOTES validate structure cascade online;
analyze table SYS.WRI$_SEGADV_CNTRLTAB validate structure cascade online;
analyze table SYS.WRI$_SEGADV_OBJLIST validate structure cascade online;
analyze table SYS.WRI$_SQLSET_BINDS validate structure cascade online;
analyze table SYS.WRI$_SQLSET_DEFINITIONS validate structure cascade online;
analyze table SYS.WRI$_SQLSET_MASK validate structure cascade online;
analyze table SYS.WRI$_SQLSET_PLANS validate structure cascade online;
analyze table SYS.WRI$_SQLSET_PLANS_TOCAP validate structure cascade online;
analyze table SYS.WRI$_SQLSET_PLAN_LINES validate structure cascade online;
analyze table SYS.WRI$_SQLSET_REFERENCES validate structure cascade online;
analyze table SYS.WRI$_SQLSET_STATEMENTS validate structure cascade online;
analyze table SYS.WRI$_SQLSET_STATISTICS validate structure cascade online;
analyze table SYS.WRI$_SQLSET_WORKSPACE validate structure cascade online;
analyze table SYS.WRI$_SQLSET_WORKSPACE_PLANS validate structure cascade online;
analyze table SYS.WRI$_SQLTEXT_REFCOUNT validate structure cascade online;
analyze table SYS.WRI$_TRACING_ENABLED validate structure cascade online;
analyze table SYS.WRM$_BASELINE validate structure cascade online;
analyze table SYS.WRM$_BASELINE_DETAILS validate structure cascade online;
analyze table SYS.WRM$_BASELINE_TEMPLATE validate structure cascade online;
analyze table SYS.WRM$_COLORED_SQL validate structure cascade online;
analyze table SYS.WRM$_DATABASE_INSTANCE validate structure cascade online;
analyze table SYS.WRM$_SNAPSHOT validate structure cascade online;
analyze table SYS.WRM$_SNAPSHOT_DETAILS validate structure cascade online;
analyze table SYS.WRM$_SNAP_ERROR validate structure cascade online;
analyze table SYS.WRM$_WR_CONTROL validate structure cascade online;
analyze table SYS.WRM$_WR_USAGE validate structure cascade online;
analyze table SYS.WRR$_CAPTURES validate structure cascade online;
analyze table SYS.WRR$_CAPTURE_STATS validate structure cascade online;
analyze table SYS.WRR$_CONNECTION_MAP validate structure cascade online;
analyze table SYS.WRR$_FILTERS validate structure cascade online;
analyze table SYS.WRR$_REPLAYS validate structure cascade online;
analyze table SYS.WRR$_REPLAY_DATA validate structure cascade online;
analyze table SYS.WRR$_REPLAY_DIVERGENCE validate structure cascade online;
analyze table SYS.WRR$_REPLAY_FILTER_SET validate structure cascade online;
analyze table SYS.WRR$_REPLAY_SCN_ORDER validate structure cascade online;
analyze table SYS.WRR$_REPLAY_SEQ_DATA validate structure cascade online;
analyze table SYS.WRR$_REPLAY_SQL_BINDS validate structure cascade online;
analyze table SYS.WRR$_REPLAY_SQL_TEXT validate structure cascade online;
analyze table SYS.WRR$_REPLAY_STATS validate structure cascade online;
analyze table SYS.WRR$_WORKLOAD_ATTRIBUTES validate structure cascade online;
206 rows selected.
**********************************************************************************************************************************************************************
Rebuild all non-partitioned Indexes
******************************************************************************************************************************************
set linesize 150
set pagesize 10000
select 'alter index '||owner||'.'||index_name||' rebuild online;'
from dba_indexes
where TABLE_OWNER='SYS'
and table_name like 'WR%'
AND partitioned='NO'
group by owner, index_name
order by owner, index_name;
'ALTERINDEX'||OWNER||'.'||INDEX_NAME||'REBUILDONLINE;'
-----------------------------------------------------------------------------------------
alter index SYS.I_WRI$_OPTSTAT_AUX_ST rebuild online;
alter index SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST rebuild online;
alter index SYS.I_WRI$_OPTSTAT_HH_ST rebuild online;
alter index SYS.I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST rebuild online;
alter index SYS.I_WRI$_OPTSTAT_H_ST rebuild online;
alter index SYS.I_WRI$_OPTSTAT_IND_OBJ#_ST rebuild online;
alter index SYS.I_WRI$_OPTSTAT_IND_ST rebuild online;
alter index SYS.I_WRI$_OPTSTAT_OPR_STIME rebuild online;
alter index SYS.I_WRI$_OPTSTAT_SYNOPHEAD rebuild online;
alter index SYS.I_WRI$_OPTSTAT_SYNOPPARTGRP rebuild online;
alter index SYS.I_WRI$_OPTSTAT_TAB_OBJ#_ST rebuild online;
alter index SYS.I_WRI$_OPTSTAT_TAB_ST rebuild online;
alter index SYS.SYS_C001800 rebuild online;
alter index SYS.SYS_C001857 rebuild online;
alter index SYS.SYS_C001860 rebuild online;
alter index SYS.SYS_C001863 rebuild online;
alter index SYS.SYS_C003380 rebuild online;
alter index SYS.SYS_IL0000000471C00016$$ rebuild online;
alter index SYS.SYS_IL0000005097C00005$$ rebuild online;
alter index SYS.SYS_IL0000005840C00008$$ rebuild online;
alter index SYS.SYS_IL0000005840C00015$$ rebuild online;
alter index SYS.SYS_IL0000005857C00011$$ rebuild online;
alter index SYS.SYS_IL0000005857C00012$$ rebuild online;
alter index SYS.SYS_IL0000005863C00014$$ rebuild online;
alter index SYS.SYS_IL0000005873C00002$$ rebuild online;
alter index SYS.SYS_IL0000005878C00005$$ rebuild online;
alter index SYS.SYS_IL0000005893C00014$$ rebuild online;
alter index SYS.SYS_IL0000005893C00023$$ rebuild online;
alter index SYS.SYS_IL0000005899C00040$$ rebuild online;
alter index SYS.SYS_IL0000006145C00008$$ rebuild online;
alter index SYS.SYS_IL0000006149C00003$$ rebuild online;
alter index SYS.SYS_IL0000006149C00005$$ rebuild online;
alter index SYS.SYS_IL0000006157C00003$$ rebuild online;
alter index SYS.SYS_IL0000006237C00004$$ rebuild online;
alter index SYS.SYS_IL0000006271C00004$$ rebuild online;
alter index SYS.SYS_IL0000006275C00038$$ rebuild online;
alter index SYS.SYS_IL0000006279C00004$$ rebuild online;
alter index SYS.SYS_IL0000006283C00005$$ rebuild online;
alter index SYS.SYS_IL0000006283C00008$$ rebuild online;
alter index SYS.SYS_IL0000006283C00010$$ rebuild online;
alter index SYS.SYS_IL0000006291C00036$$ rebuild online;
alter index SYS.SYS_IL0000006331C00004$$ rebuild online;
alter index SYS.SYS_IL0000006339C00038$$ rebuild online;
alter index SYS.SYS_IL0000006917C00003$$ rebuild online;
alter index SYS.SYS_IL0000006935C00018$$ rebuild online;
alter index SYS.SYS_IL0000008822C00008$$ rebuild online;
alter index SYS.WRH$_ASH_BL_PK rebuild online;
alter index SYS.WRH$_BG_EVENT_SUMMARY_PK rebuild online;
alter index SYS.WRH$_BUFFERED_QUEUES_PK rebuild online;
alter index SYS.WRH$_BUFFERED_SUBSCRIBERS_PK rebuild online;
alter index SYS.WRH$_BUFFER_POOL_STATS_PK rebuild online;
alter index SYS.WRH$_CLUSTER_INTERCON_PK rebuild online;
alter index SYS.WRH$_COMP_IOSTAT_PK rebuild online;
alter index SYS.WRH$_CR_BLOCK_SERVER_PK rebuild online;
alter index SYS.WRH$_CURRENT_BLOCK_SERVER_PK rebuild online;
alter index SYS.WRH$_DATAFILE_PK rebuild online;
alter index SYS.WRH$_DB_CACHE_ADVICE_BL_PK rebuild online;
alter index SYS.WRH$_DISPATCHER_PK rebuild online;
alter index SYS.WRH$_DLM_MISC_BL_PK rebuild online;
alter index SYS.WRH$_DYN_REMASTER_STATS_PK rebuild online;
alter index SYS.WRH$_ENQUEUE_STAT_PK rebuild online;
alter index SYS.WRH$_EVENT_HISTOGRAM_BL_PK rebuild online;
alter index SYS.WRH$_EVENT_NAME_PK rebuild online;
alter index SYS.WRH$_FILEMETRIC_HISTORY_INDEX rebuild online;
alter index SYS.WRH$_FILESTATXS_BL_PK rebuild online;
alter index SYS.WRH$_IC_CLIENT_STATS_PK rebuild online;
alter index SYS.WRH$_IC_DEVICE_STATS_PK rebuild online;
alter index SYS.WRH$_INSTANCE_RECOVERY_PK rebuild online;
alter index SYS.WRH$_INST_CACHE_TRANSFER_BL_PK rebuild online;
alter index SYS.WRH$_INTERCONNECT_PINGS_BL_PK rebuild online;
alter index SYS.WRH$_IOSTAT_DETAIL_PK rebuild online;
alter index SYS.WRH$_IOSTAT_FILETYPE_NAME_PK rebuild online;
alter index SYS.WRH$_IOSTAT_FILETYPE_PK rebuild online;
alter index SYS.WRH$_IOSTAT_FUNCTION_NAME_PK rebuild online;
alter index SYS.WRH$_IOSTAT_FUNCTION_PK rebuild online;
alter index SYS.WRH$_JAVA_POOL_ADVICE_PK rebuild online;
alter index SYS.WRH$_LATCH_BL_PK rebuild online;
alter index SYS.WRH$_LATCH_CHILDREN_BL_PK rebuild online;
alter index SYS.WRH$_LATCH_MISSES_SUMRY_BL_PK rebuild online;
alter index SYS.WRH$_LATCH_NAME_PK rebuild online;
alter index SYS.WRH$_LATCH_PARENT_BL_PK rebuild online;
alter index SYS.WRH$_LIBRARYCACHE_PK rebuild online;
alter index SYS.WRH$_LOG_PK rebuild online;
alter index SYS.WRH$_MEMORY_RESIZE_OPS_PK rebuild online;
alter index SYS.WRH$_MEMORY_TARGET_ADVICE_PK rebuild online;
alter index SYS.WRH$_MEM_DYNAMIC_COMP_PK rebuild online;
alter index SYS.WRH$_METRIC_NAME_PK rebuild online;
alter index SYS.WRH$_MUTEX_SLEEP_PK rebuild online;
alter index SYS.WRH$_MVPARAMETER_BL_PK rebuild online;
alter index SYS.WRH$_OPTIMIZER_ENV_PK rebuild online;
alter index SYS.WRH$_OSSTAT_BL_PK rebuild online;
alter index SYS.WRH$_OSSTAT_NAME_PK rebuild online;
alter index SYS.WRH$_PARAMETER_BL_PK rebuild online;
alter index SYS.WRH$_PARAMETER_NAME_PK rebuild online;
alter index SYS.WRH$_PERSISTENT_QMN_CACHE_PK rebuild online;
alter index SYS.WRH$_PERSISTENT_QUEUES_PK rebuild online;
alter index SYS.WRH$_PERSISTENT_SUBSCRIBERS_PK rebuild online;
alter index SYS.WRH$_PGASTAT_PK rebuild online;
alter index SYS.WRH$_PGA_TARGET_ADVICE_PK rebuild online;
alter index SYS.WRH$_PLAN_OPERATION_NAME_PK rebuild online;
alter index SYS.WRH$_PLAN_OPTION_NAME_PK rebuild online;
alter index SYS.WRH$_PROCESS_MEM_SUMMARY_PK rebuild online;
alter index SYS.WRH$_RESOURCE_LIMIT_PK rebuild online;
alter index SYS.WRH$_ROWCACHE_SUMMARY_BL_PK rebuild online;
alter index SYS.WRH$_RSRC_CONSUMER_GROUP_PK rebuild online;
alter index SYS.WRH$_RSRC_PLAN_PK rebuild online;
alter index SYS.WRH$_RULE_SET_PK rebuild online;
alter index SYS.WRH$_SEG_STAT_BL_PK rebuild online;
alter index SYS.WRH$_SEG_STAT_OBJ_INDEX rebuild online;
alter index SYS.WRH$_SEG_STAT_OBJ_PK rebuild online;
alter index SYS.WRH$_SERVICE_NAME_PK rebuild online;
alter index SYS.WRH$_SERVICE_STAT_BL_PK rebuild online;
alter index SYS.WRH$_SERVICE_WAIT_CLASS_BL_PK rebuild online;
alter index SYS.WRH$_SESSMETRIC_HISTORY_INDEX rebuild online;
alter index SYS.WRH$_SESS_TIME_STATS_PK rebuild online;
alter index SYS.WRH$_SGASTAT_BL_U rebuild online;
alter index SYS.WRH$_SGA_PK rebuild online;
alter index SYS.WRH$_SGA_TARGET_ADVICE_PK rebuild online;
alter index SYS.WRH$_SHARED_POOL_ADVICE_PK rebuild online;
alter index SYS.WRH$_SHARED_SERVER_SUMMARY_PK rebuild online;
alter index SYS.WRH$_SQLCOMMAND_NAME_PK rebuild online;
alter index SYS.WRH$_SQLSTAT_BL_INDEX rebuild online;
alter index SYS.WRH$_SQLSTAT_BL_PK rebuild online;
alter index SYS.WRH$_SQLTEXT_PK rebuild online;
alter index SYS.WRH$_SQL_BIND_METADATA_PK rebuild online;
alter index SYS.WRH$_SQL_PLAN_PK rebuild online;
alter index SYS.WRH$_SQL_SUMMARY_PK rebuild online;
alter index SYS.WRH$_SQL_WORKAREA_HIST_PK rebuild online;
alter index SYS.WRH$_STAT_NAME_PK rebuild online;
alter index SYS.WRH$_STREAMS_APPLY_SUM_PK rebuild online;
alter index SYS.WRH$_STREAMS_CAPTURE_PK rebuild online;
alter index SYS.WRH$_STREAMS_POOL_ADVICE_PK rebuild online;
alter index SYS.WRH$_SYSMETRIC_HISTORY_INDEX rebuild online;
alter index SYS.WRH$_SYSMETRIC_SUMMARY_INDEX rebuild online;
alter index SYS.WRH$_SYSSTAT_BL_PK rebuild online;
alter index SYS.WRH$_SYSTEM_EVENT_BL_PK rebuild online;
alter index SYS.WRH$_SYS_TIME_MODEL_BL_PK rebuild online;
alter index SYS.WRH$_TABLESPACE_PK rebuild online;
alter index SYS.WRH$_TABLESPACE_STAT_BL_PK rebuild online;
alter index SYS.WRH$_TEMPFILE_PK rebuild online;
alter index SYS.WRH$_TEMPSTATXS_PK rebuild online;
alter index SYS.WRH$_THREAD_PK rebuild online;
alter index SYS.WRH$_TOPLEVELCALL_NAME_PK rebuild online;
alter index SYS.WRH$_TS_SPACE_USAGE_IND rebuild online;
alter index SYS.WRH$_UNDOSTAT_PK rebuild online;
alter index SYS.WRH$_WAITCLASSMETRIC_HIST_IND rebuild online;
alter index SYS.WRH$_WAITSTAT_BL_PK rebuild online;
alter index SYS.WRI$_ADV_ACTIONS_PK rebuild online;
alter index SYS.WRI$_ADV_ADDM_TASKS_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_DEFINITIONS_PK rebuild online;
alter index SYS.WRI$_ADV_DEF_ACTION_PK rebuild online;
alter index SYS.WRI$_ADV_DEF_PARAMETERS_PK rebuild online;
alter index SYS.WRI$_ADV_DIRINST_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_DIRINST_IDX_02 rebuild online;
alter index SYS.WRI$_ADV_DIRM_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_DIR_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_DIR_IDX_02 rebuild online;
alter index SYS.WRI$_ADV_EXECS_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_EXECS_IDX_02 rebuild online;
alter index SYS.WRI$_ADV_EXECS_IDX_03 rebuild online;
alter index SYS.WRI$_ADV_EXECS_PK rebuild online;
alter index SYS.WRI$_ADV_EXEC_PARAMETERS_PK rebuild online;
alter index SYS.WRI$_ADV_FINDINGS_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_FINDINGS_IDX_02 rebuild online;
alter index SYS.WRI$_ADV_FINDINGS_PK rebuild online;
alter index SYS.WRI$_ADV_JOURNAL rebuild online;
alter index SYS.WRI$_ADV_MESSAGE_GROUPS_PK rebuild online;
alter index SYS.WRI$_ADV_MSG_GRPS_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_OBJECTS_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_OBJECTS_PK rebuild online;
alter index SYS.WRI$_ADV_PARAMETERS_PK rebuild online;
alter index SYS.WRI$_ADV_RATIONALE_PK rebuild online;
alter index SYS.WRI$_ADV_RECS_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_RECS_IDX_02 rebuild online;
alter index SYS.WRI$_ADV_REC_ACTIONS_PK rebuild online;
alter index SYS.WRI$_ADV_REC_PK rebuild online;
alter index SYS.WRI$_ADV_SQLA_CV_PK rebuild online;
alter index SYS.WRI$_ADV_SQLA_FREG_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_SQLA_MAP_01 rebuild online;
alter index SYS.WRI$_ADV_SQLA_STMTS_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_SQLA_STMTS_IDX_02 rebuild online;
alter index SYS.WRI$_ADV_SQLA_SUM_PK rebuild online;
alter index SYS.WRI$_ADV_SQLA_TABLES_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_SQLA_TMP_PK rebuild online;
alter index SYS.WRI$_ADV_SQLA_TV_PK rebuild online;
alter index SYS.WRI$_ADV_SQLT_BINDS_PK rebuild online;
alter index SYS.WRI$_ADV_SQLT_PLANS_PK rebuild online;
alter index SYS.WRI$_ADV_SQLT_PLAN_HASH_01 rebuild online;
alter index SYS.WRI$_ADV_SQLT_PLAN_HASH_PK rebuild online;
alter index SYS.WRI$_ADV_SQLT_PLAN_STATS_PK rebuild online;
alter index SYS.WRI$_ADV_SQLT_RTN_PLAN_PK rebuild online;
alter index SYS.WRI$_ADV_SQLT_STATISTICS_PK rebuild online;
alter index SYS.WRI$_ADV_SQLW_CV_PK rebuild online;
alter index SYS.WRI$_ADV_SQLW_STMTS_PK rebuild online;
alter index SYS.WRI$_ADV_SQLW_SUM_PK rebuild online;
alter index SYS.WRI$_ADV_SQLW_TABLES_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_SQLW_TV_PK rebuild online;
alter index SYS.WRI$_ADV_TASKS_IDX_01 rebuild online;
alter index SYS.WRI$_ADV_TASKS_IDX_02 rebuild online;
alter index SYS.WRI$_ADV_TASKS_IDX_03 rebuild online;
alter index SYS.WRI$_ADV_TASKS_IDX_04 rebuild online;
alter index SYS.WRI$_ADV_TASKS_PK rebuild online;
alter index SYS.WRI$_ADV_USAGE_PK rebuild online;
alter index SYS.WRI$_AGGREGATION_IND1 rebuild online;
alter index SYS.WRI$_ALERTS_OUTSTANDING_PK rebuild online;
alter index SYS.WRI$_ALERT_HISTORY_PK rebuild online;
alter index SYS.WRI$_ALERT_THRESHOLD_LOG_PK rebuild online;
alter index SYS.WRI$_ALERT_THRESHOLD_PK rebuild online;
alter index SYS.WRI$_DBU_CPU_USAGE_PK rebuild online;
alter index SYS.WRI$_DBU_CPU_USAGE_SAMPLE_PK rebuild online;
alter index SYS.WRI$_DBU_FEATURE_METADATA_PK rebuild online;
alter index SYS.WRI$_DBU_FEATURE_USAGE_PK rebuild online;
alter index SYS.WRI$_DBU_HIGH_WATER_MARK_PK rebuild online;
alter index SYS.WRI$_DBU_HWM_METADATA_PK rebuild online;
alter index SYS.WRI$_DBU_USAGE_SAMPLE_PK rebuild online;
alter index SYS.WRI$_REPT_COMPONENTS_IDX_01 rebuild online;
alter index SYS.WRI$_REPT_COMPONENTS_PK rebuild online;
alter index SYS.WRI$_REPT_FILES_IDX_01 rebuild online;
alter index SYS.WRI$_REPT_FILES_PK rebuild online;
alter index SYS.WRI$_REPT_FORMATS_IDX_01 rebuild online;
alter index SYS.WRI$_REPT_FORMATS_PK rebuild online;
alter index SYS.WRI$_REPT_REPORTS_IDX_01 rebuild online;
alter index SYS.WRI$_REPT_REPORTS_PK rebuild online;
alter index SYS.WRI$_SEGADV_CNTRLTAB_PK rebuild online;
alter index SYS.WRI$_SEGADV_OBJLIST_IDX_AID rebuild online;
alter index SYS.WRI$_SEGADV_OBJLIST_IDX_OBJ rebuild online;
alter index SYS.WRI$_SEGADV_OBJLIST_IDX_OBJD rebuild online;
alter index SYS.WRI$_SEGADV_OBJLIST_IDX_TS rebuild online;
alter index SYS.WRI$_SQLSET_BINDS_PK rebuild online;
alter index SYS.WRI$_SQLSET_DEFINITIONS_IDX_01 rebuild online;
alter index SYS.WRI$_SQLSET_DEFINITIONS_PK rebuild online;
alter index SYS.WRI$_SQLSET_MASK_PK rebuild online;
alter index SYS.WRI$_SQLSET_PLANS_PK rebuild online;
alter index SYS.WRI$_SQLSET_PLANS_TOCAP_PK rebuild online;
alter index SYS.WRI$_SQLSET_PLAN_LINES_PK rebuild online;
alter index SYS.WRI$_SQLSET_REFERENCES_PK rebuild online;
alter index SYS.WRI$_SQLSET_STATEMENTS_IDX_01 rebuild online;
alter index SYS.WRI$_SQLSET_STATEMENTS_IDX_02 rebuild online;
alter index SYS.WRI$_SQLSET_STATEMENTS_PK rebuild online;
alter index SYS.WRI$_SQLSET_STATISTICS_PK rebuild online;
alter index SYS.WRI$_SQLSET_WORKSPACE_PK rebuild online;
alter index SYS.WRI$_SQLSET_WORKSPACE_PLANS_PK rebuild online;
alter index SYS.WRI$_SQLTEXT_REFCOUNT_PK rebuild online;
alter index SYS.WRI$_TRACING_IND1 rebuild online;
alter index SYS.WRM$_BASELINE_DETAILS_PK rebuild online;
alter index SYS.WRM$_BASELINE_PK rebuild online;
alter index SYS.WRM$_BASELINE_TEMPLATE_PK rebuild online;
alter index SYS.WRM$_COLORED_SQL_PK rebuild online;
alter index SYS.WRM$_DATABASE_INSTANCE_PK rebuild online;
alter index SYS.WRM$_SCH_CONTROL_PK rebuild online;
alter index SYS.WRM$_SCH_VOTES_PK rebuild online;
alter index SYS.WRM$_SNAPSHOT_DETAILS_INDEX rebuild online;
alter index SYS.WRM$_SNAPSHOT_PK rebuild online;
alter index SYS.WRM$_SNAP_ERROR_PK rebuild online;
alter index SYS.WRM$_WR_CONTROL_PK rebuild online;
alter index SYS.WRM$_WR_USAGE_INDEX rebuild online;
alter index SYS.WRR$_CAPTURES_PK rebuild online;
alter index SYS.WRR$_CAPTURE_STATS_PK rebuild online;
alter index SYS.WRR$_CONNECTION_MAP_PK rebuild online;
alter index SYS.WRR$_FILTERS_PK rebuild online;
alter index SYS.WRR$_REPLAYS_PK rebuild online;
alter index SYS.WRR$_REPLAY_DATA_PK rebuild online;
alter index SYS.WRR$_REPLAY_DIVERGENCE_PK rebuild online;
alter index SYS.WRR$_REPLAY_FILTER_SET_PK rebuild online;
alter index SYS.WRR$_REPLAY_SCN_ORDER_PK rebuild online;
alter index SYS.WRR$_REPLAY_SEQ_DATA_PK rebuild online;
alter index SYS.WRR$_REPLAY_SQL_BINDS_PK rebuild online;
alter index SYS.WRR$_REPLAY_SQL_TEXT_PK rebuild online;
alter index SYS.WRR$_REPLAY_STATS_PK rebuild online;
alter index SYS.WRR$_WORKLOAD_ATTRIBUTES_PK rebuild online;
270 rows selected.