Validate the database
set linesize 150
select 'alter index '||owner||'.'||table_name||' rebuild online;'
from dba_indexes
where TABLE_OWNER='SYS'
and table_name='WRH$_MEM_DYNAMIC_COMP';
analyze table AUD_OWNER.AUD_COPY validate structure cascade online;
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%'
order by owner, table_name;
'ANALYZETABLE'||OWNER||'.'||TABLE_NAME||'VALIDATESTRUCTURECASCADEONLINE;'
--------------------------------------------------------------------------------------------------------------
analyze table SYS.WRH$_ACTIVE_SESSION_HISTORY validate structure cascade online;
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 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 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 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 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 validate structure cascade online;
analyze table SYS.WRH$_INST_CACHE_TRANSFER_BL validate structure cascade online;
analyze table SYS.WRH$_INTERCONNECT_PINGS 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 validate structure cascade online;
analyze table SYS.WRH$_LATCH_BL validate structure cascade online;
analyze table SYS.WRH$_LATCH_CHILDREN validate structure cascade online;
analyze table SYS.WRH$_LATCH_CHILDREN_BL validate structure cascade online;
analyze table SYS.WRH$_LATCH_MISSES_SUMMARY 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 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 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 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 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 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 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$_SEG_STAT_OBJ validate structure cascade online;
analyze table SYS.WRH$_SERVICE_NAME validate structure cascade online;
analyze table SYS.WRH$_SERVICE_STAT validate structure cascade online;
analyze table SYS.WRH$_SERVICE_STAT_BL validate structure cascade online;
analyze table SYS.WRH$_SERVICE_WAIT_CLASS 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 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 validate structure cascade online;
analyze table SYS.WRH$_SQLSTAT validate structure cascade online;
analyze table SYS.WRH$_SQLSTAT_BL 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$_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_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 validate structure cascade online;
analyze table SYS.WRH$_SYSSTAT_BL validate structure cascade online;
analyze table SYS.WRH$_SYSTEM_EVENT validate structure cascade online;
analyze table SYS.WRH$_SYSTEM_EVENT_BL validate structure cascade online;
analyze table SYS.WRH$_SYS_TIME_MODEL 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 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 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_ACTIONS 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_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_DEFS validate structure cascade online;
analyze table SYS.WRI$_ADV_DIRECTIVE_INSTANCES validate structure cascade online;
analyze table SYS.WRI$_ADV_DIRECTIVE_INSTANCES 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_DIRECTIVE_META validate structure cascade online;
analyze table SYS.WRI$_ADV_EXECUTIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_EXECUTIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_EXECUTIONS 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_FINDINGS 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_MESSAGE_GROUPS validate structure cascade online;
analyze table SYS.WRI$_ADV_OBJECTS validate structure cascade online;
analyze table SYS.WRI$_ADV_OBJECTS validate structure cascade online;
analyze table SYS.WRI$_ADV_OBJECTS 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_RATIONALE validate structure cascade online;
analyze table SYS.WRI$_ADV_RECOMMENDATIONS validate structure cascade online;
analyze table SYS.WRI$_ADV_RECOMMENDATIONS 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_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_BINDS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_PLANS 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_HASH validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_PLAN_STATS validate structure cascade online;
analyze table SYS.WRI$_ADV_SQLT_PLAN_STATS 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_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_TASKS validate structure cascade online;
analyze table SYS.WRI$_ADV_TASKS validate structure cascade online;
analyze table SYS.WRI$_ADV_TASKS 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_METADATA 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_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_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_HISTGRM_HISTORY validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY validate structure cascade online;
analyze table SYS.WRI$_OPTSTAT_HISTHEAD_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_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_HEAD$ 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$_OPTSTAT_TAB_HISTORY validate structure cascade online;
analyze table SYS.WRI$_REPT_COMPONENTS 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_FILES 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_FORMATS validate structure cascade online;
analyze table SYS.WRI$_REPT_REPORTS 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$_SEGADV_OBJLIST validate structure cascade online;
analyze table SYS.WRI$_SEGADV_OBJLIST 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_BINDS validate structure cascade online;
analyze table SYS.WRI$_SQLSET_DEFINITIONS 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_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_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_STATEMENTS 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 validate structure cascade online;
analyze table SYS.WRI$_SQLSET_WORKSPACE 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$_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_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;
296 rows selected.
SHPMLS@oracle@shaahspmldbp1 [PRD ACTIVE]:/data/oracle/SHPMLS/backup
$ cd /data/oracle/SHPMLS/backup
$ vi /tmp/analyze_table_wr.sql
$ sqlplus / as sysdba;
SQL> spool analyze_table_wr.log
SQL> @/tmp/analyze_table_wr.sql
SQL> spool off
SHPMLS@oracle@shaahspmldbp1 [PRD ACTIVE]:/data/oracle/SHPMLS/backup
$ ls -lrt
-rw-r--r-- 1 oracle dba 9852 Jun 11 14:23 analyze_table_wr.log
scp analyze_table_wr.log laiyong@hkginsathp1.hk.db.com:/tmp/yong
analyze table SYS.WRH$_BG_EVENT_SUMMARY validate structure cascade online;
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file
SQL> analyze table SYS.WRH$_BG_EVENT_SUMMARY validate structure cascade online;
analyze table SYS.WRH$_BG_EVENT_SUMMARY validate structure cascade online
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file
SQL> set linesize 150
select 'alter index '||owner||'.'||index_name||' rebuild online;'
from dba_indexes
where TABLE_OWNER='SYS'
and TABLE_NAME='WRH$_BG_EVENT_SUMMARY';
'ALTERINDEX'||OWNER||'.'||INDEX_NAME||'REBUILDONLINE;'
-----------------------------------------------------------------------------------------
alter index SYS.WRH$_BG_EVENT_SUMMARY_PK rebuild online;
SQL> alter index SYS.WRH$_BG_EVENT_SUMMARY_PK rebuild online;
Index altered.
SQL> analyze table SYS.WRH$_BG_EVENT_SUMMARY validate structure cascade online;
Table analyzed.
**********************************************************************************************************************************
analyze table SYS.WRH$_BUFFER_POOL_STATISTICS validate structure cascade online
analyze table SYS.WRH$_BUFFER_POOL_STATISTICS validate structure cascade online
analyze table SYS.WRH$_BUFFER_POOL_STATISTICS validate structure cascade online
analyze table SYS.WRH$_BUFFER_POOL_STATISTICS validate structure cascade online
analyze table SYS.WRH$_BUFFER_POOL_STATISTICS validate structure cascade online
analyze table SYS.WRH$_BUFFER_POOL_STATISTICS validate structure cascade online
analyze table SYS.WRH$_BUFFER_POOL_STATISTICS validate structure cascade online
SQL> 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 'WRH$%';
'ALTERINDEX'||OWNER||'.'||INDEX_NAME||'REBUILDONLINE;'
-----------------------------------------------------------------------------------------
alter index SYS.WRH$_FILESTATXS_PK rebuild online;
alter index SYS.WRH$_FILESTATXS_BL_PK rebuild online;
alter index SYS.WRH$_TEMPSTATXS_PK rebuild online;
alter index SYS.WRH$_DATAFILE_PK rebuild online;
alter index SYS.WRH$_TEMPFILE_PK rebuild online;
alter index SYS.WRH$_COMP_IOSTAT_PK rebuild online;
alter index SYS.WRH$_IOSTAT_FUNCTION_PK rebuild online;
alter index SYS.WRH$_IOSTAT_FUNCTION_NAME_PK rebuild online;
alter index SYS.WRH$_IOSTAT_FILETYPE_PK rebuild online;
alter index SYS.WRH$_IOSTAT_FILETYPE_NAME_PK rebuild online;
alter index SYS.WRH$_IOSTAT_DETAIL_PK rebuild online;
alter index SYS.WRH$_SQLSTAT_PK rebuild online;
alter index SYS.WRH$_SQLSTAT_INDEX rebuild online;
alter index SYS.WRH$_SQLSTAT_BL_PK rebuild online;
alter index SYS.WRH$_SQLSTAT_BL_INDEX rebuild online;
alter index SYS.WRH$_SQLTEXT_PK rebuild online;
alter index SYS.SYS_IL0000006331C00004$$ rebuild online;
alter index SYS.WRH$_SQL_SUMMARY_PK rebuild online;
alter index SYS.WRH$_SQL_PLAN_PK rebuild online;
alter index SYS.SYS_IL0000006339C00038$$ rebuild online;
alter index SYS.WRH$_SQL_BIND_METADATA_PK rebuild online;
alter index SYS.WRH$_OPTIMIZER_ENV_PK rebuild online;
alter index SYS.WRH$_SYSTEM_EVENT_PK rebuild online;
alter index SYS.WRH$_SYSTEM_EVENT_BL_PK rebuild online;
alter index SYS.WRH$_EVENT_NAME_PK rebuild online;
alter index SYS.WRH$_LATCH_NAME_PK rebuild online;
alter index SYS.WRH$_BG_EVENT_SUMMARY_PK rebuild online;
alter index SYS.WRH$_WAITSTAT_PK rebuild online;
alter index SYS.WRH$_WAITSTAT_BL_PK rebuild online;
alter index SYS.WRH$_ENQUEUE_STAT_PK rebuild online;
alter index SYS.WRH$_LATCH_PK rebuild online;
alter index SYS.WRH$_LATCH_BL_PK rebuild online;
alter index SYS.WRH$_LATCH_CHILDREN_PK rebuild online;
alter index SYS.WRH$_LATCH_CHILDREN_BL_PK rebuild online;
alter index SYS.WRH$_LATCH_PARENT_PK rebuild online;
alter index SYS.WRH$_LATCH_PARENT_BL_PK rebuild online;
alter index SYS.WRH$_LATCH_MISSES_SUMMARY_PK rebuild online;
alter index SYS.WRH$_LATCH_MISSES_SUMRY_BL_PK rebuild online;
alter index SYS.WRH$_EVENT_HISTOGRAM_PK rebuild online;
alter index SYS.WRH$_EVENT_HISTOGRAM_BL_PK rebuild online;
alter index SYS.WRH$_MUTEX_SLEEP_PK rebuild online;
alter index SYS.WRH$_LIBRARYCACHE_PK rebuild online;
alter index SYS.WRH$_DB_CACHE_ADVICE_PK rebuild online;
alter index SYS.WRH$_DB_CACHE_ADVICE_BL_PK rebuild online;
alter index SYS.WRH$_BUFFER_POOL_STATS_PK rebuild online;
alter index SYS.WRH$_ROWCACHE_SUMMARY_PK rebuild online;
alter index SYS.WRH$_ROWCACHE_SUMMARY_BL_PK rebuild online;
alter index SYS.WRH$_SGA_PK rebuild online;
alter index SYS.WRH$_SGASTAT_U rebuild online;
alter index SYS.WRH$_SGASTAT_BL_U rebuild online;
alter index SYS.WRH$_PGASTAT_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$_SHARED_POOL_ADVICE_PK rebuild online;
alter index SYS.WRH$_STREAMS_POOL_ADVICE_PK rebuild online;
alter index SYS.WRH$_SQL_WORKAREA_HIST_PK rebuild online;
alter index SYS.WRH$_PGA_TARGET_ADVICE_PK rebuild online;
alter index SYS.WRH$_SGA_TARGET_ADVICE_PK rebuild online;
alter index SYS.WRH$_MEMORY_TARGET_ADVICE_PK rebuild online;
alter index SYS.WRH$_MEMORY_RESIZE_OPS_PK rebuild online;
alter index SYS.WRH$_INSTANCE_RECOVERY_PK rebuild online;
alter index SYS.WRH$_JAVA_POOL_ADVICE_PK rebuild online;
alter index SYS.WRH$_THREAD_PK rebuild online;
alter index SYS.WRH$_SYSSTAT_PK rebuild online;
alter index SYS.WRH$_SYSSTAT_BL_PK rebuild online;
alter index SYS.WRH$_SYS_TIME_MODEL_PK rebuild online;
alter index SYS.WRH$_SYS_TIME_MODEL_BL_PK rebuild online;
alter index SYS.WRH$_OSSTAT_PK rebuild online;
alter index SYS.WRH$_OSSTAT_BL_PK rebuild online;
alter index SYS.WRH$_PARAMETER_PK rebuild online;
alter index SYS.WRH$_MVPARAMETER_PK rebuild online;
alter index SYS.WRH$_PARAMETER_BL_PK rebuild online;
alter index SYS.WRH$_MVPARAMETER_BL_PK rebuild online;
alter index SYS.WRH$_STAT_NAME_PK rebuild online;
alter index SYS.WRH$_OSSTAT_NAME_PK rebuild online;
alter index SYS.WRH$_PARAMETER_NAME_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$_SQLCOMMAND_NAME_PK rebuild online;
alter index SYS.WRH$_TOPLEVELCALL_NAME_PK rebuild online;
alter index SYS.WRH$_UNDOSTAT_PK rebuild online;
alter index SYS.WRH$_SEG_STAT_PK rebuild online;
alter index SYS.WRH$_SEG_STAT_BL_PK rebuild online;
alter index SYS.WRH$_SEG_STAT_OBJ_PK rebuild online;
alter index SYS.WRH$_SEG_STAT_OBJ_INDEX rebuild online;
alter index SYS.WRH$_METRIC_NAME_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$_SESSMETRIC_HISTORY_INDEX rebuild online;
alter index SYS.WRH$_FILEMETRIC_HISTORY_INDEX rebuild online;
alter index SYS.WRH$_WAITCLASSMETRIC_HIST_IND rebuild online;
alter index SYS.WRH$_DLM_MISC_PK rebuild online;
alter index SYS.WRH$_DLM_MISC_BL_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$_INST_CACHE_TRANSFER_PK rebuild online;
alter index SYS.WRH$_INST_CACHE_TRANSFER_BL_PK rebuild online;
alter index SYS.WRH$_ACTIVE_SESSION_HISTORY_PK rebuild online;
alter index SYS.WRH$_ASH_BL_PK rebuild online;
alter index SYS.WRH$_TABLESPACE_STAT_PK rebuild online;
alter index SYS.WRH$_TABLESPACE_STAT_BL_PK rebuild online;
alter index SYS.WRH$_LOG_PK rebuild online;
alter index SYS.WRH$_TABLESPACE_PK rebuild online;
alter index SYS.WRH$_TS_SPACE_USAGE_IND rebuild online;
alter index SYS.WRH$_SERVICE_NAME_PK rebuild online;
alter index SYS.WRH$_SERVICE_STAT_PK rebuild online;
alter index SYS.WRH$_SERVICE_STAT_BL_PK rebuild online;
alter index SYS.WRH$_SERVICE_WAIT_CLASS_PK rebuild online;
alter index SYS.WRH$_SERVICE_WAIT_CLASS_BL_PK rebuild online;
alter index SYS.WRH$_SESS_TIME_STATS_PK rebuild online;
alter index SYS.WRH$_STREAMS_CAPTURE_PK rebuild online;
alter index SYS.WRH$_STREAMS_APPLY_SUM_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$_PERSISTENT_QUEUES_PK rebuild online;
alter index SYS.WRH$_PERSISTENT_SUBSCRIBERS_PK rebuild online;
alter index SYS.WRH$_RULE_SET_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$_CLUSTER_INTERCON_PK rebuild online;
alter index SYS.WRH$_IC_DEVICE_STATS_PK rebuild online;
alter index SYS.WRH$_IC_CLIENT_STATS_PK rebuild online;
alter index SYS.WRH$_MEM_DYNAMIC_COMP_PK rebuild online;
alter index SYS.WRH$_INTERCONNECT_PINGS_PK rebuild online;
alter index SYS.WRH$_INTERCONNECT_PINGS_BL_PK rebuild online;
alter index SYS.WRH$_DISPATCHER_PK rebuild online;
alter index SYS.WRH$_SHARED_SERVER_SUMMARY_PK rebuild online;
alter index SYS.WRH$_DYN_REMASTER_STATS_PK rebuild online;
alter index SYS.WRH$_PERSISTENT_QMN_CACHE_PK rebuild online;
129 rows selected.
$ cd /data/oracle/SHPMLS/backup
$ vi /tmp/rebuild_index_wr.sql
$ sqlplus / as sysdba;
SQL> spool rebuild_index.log
SQL> @/tmp/rebuild_index_wr.sql
SQL> spool off
SQL> spool analyze_table_wr2.log
SQL> @/tmp/analyze_table_wr.sql
SQL> spool off
scp
scp analyze_table_wr2.log rebuild_index.log laiyong@hkginsathp1.hk.db.com:/tmp/yong
**************************************************************************************************************************
analyze table SYS.WRM$_SNAPSHOT_DETAILS validate structure cascade online;
SQL> analyze table SYS.WRM$_SNAPSHOT_DETAILS validate structure cascade online;
analyze table SYS.WRM$_SNAPSHOT_DETAILS validate structure cascade online
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file
SQL> set linesize 150
select 'alter index '||owner||'.'||index_name||' rebuild online;'
from dba_indexes
where TABLE_OWNER='SYS'
and TABLE_NAME='WRM$_SNAPSHOT_DETAILS';
'ALTERINDEX'||OWNER||'.'||INDEX_NAME||'REBUILDONLINE;'
-----------------------------------------------------------------------------------------
alter index SYS.WRM$_SNAPSHOT_DETAILS_INDEX rebuild online;
SQL> analyze table SYS.WRM$_SNAPSHOT_DETAILS validate structure cascade online;
Table analyzed.
**************************************************************************************************************************
analyze table SYS.WRH$_SQLSTAT validate structure cascade online
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found
analyze table SYS.WRH$_SQLSTAT validate structure cascade online
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found
analyze table SYS.WRH$_SGASTAT validate structure cascade online
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found
analyze table SYS.WRH$_SERVICE_WAIT_CLASS validate structure cascade online
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found
analyze table SYS.WRH$_SERVICE_STAT validate structure cascade online
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found
analyze table SYS.WRH$_SEG_STAT validate structure cascade online
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found
**********************************************************************************************************************************************************************************************
analyze table SYS.WRH$_SEG_STAT validate structure cascade online
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found
**********************************************************************************************************************************************************************************************
SQL> analyze table SYS.WRH$_SEG_STAT validate structure cascade online;
analyze table SYS.WRH$_SEG_STAT validate structure cascade online
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found
SQL> set linesize 150
column OWNER format a20
column INDEX_NAME format a20
column INDEX_TYPE format a10
column TABLE_OWNER format a15
column TABLE_NAME format a15
select owner,index_name, index_type, table_owner,
table_name, partitioned, status,
TO_CHAR(last_analyzed, 'DD-MON-YYYY HH24:MI:SS') AS last_analyzed
from dba_indexes
where table_owner='SYS'
and table_name='WRH$_SEG_STAT';
OWNER INDEX_NAME INDEX_TYPE TABLE_OWNER TABLE_NAME PAR STATUS LAST_ANALYZED
-------------------- -------------------- ---------- --------------- --------------- --- -------- --------------------------
SYS WRH$_SEG_STAT_PK NORMAL SYS WRH$_SEG_STAT YES N/A 10-JUN-2018 06:00:53
Generate script to rebuild the Partitioned indexes
SQL> set linesize 150
select 'alter index '||index_name||' rebuild partition '||partition_name||' online;'
from dba_ind_partitions
where index_name='WRH$_SEG_STAT_PK';
'ALTERINDEX'||INDEX_NAME||'REBUILDPARTITION'||PARTITION_NAME||'ONLINE;'
---------------------------------------------------------------------------------------------------
alter index WRH$_SEG_STAT_PK rebuild partition WRH$_SEG_STAT_MXDB_MXSN online;
alter index WRH$_SEG_STAT_PK rebuild partition WRH$_SEG_ST_2038560152_51584 online;
alter index WRH$_SEG_STAT_PK rebuild partition WRH$_SEG_ST_2038560152_51608 online;
alter index WRH$_SEG_STAT_PK rebuild partition WRH$_SEG_ST_2038560152_51632 online;
alter index WRH$_SEG_STAT_PK rebuild partition WRH$_SEG_ST_2038560152_51656 online;
alter index WRH$_SEG_STAT_PK rebuild partition WRH$_SEG_ST_2038560152_51680 online;
alter index WRH$_SEG_STAT_PK rebuild partition WRH$_SEG_ST_2038560152_51704 online;
alter index WRH$_SEG_STAT_PK rebuild partition WRH$_SEG_ST_2038560152_51728 online;
alter index WRH$_SEG_STAT_PK rebuild partition WRH$_SEG_ST_2038560152_51752 online;
alter index WRH$_SEG_STAT_PK rebuild partition WRH$_SEG_ST_2038560152_51798 online;
10 rows selected.
$ vi /tmp/rebuild_par_index_wr.sql
$ sqlplus / as sysdba;
SQL> @/tmp/rebuild_par_index_wr.sql
Index altered.
Index altered.
Index altered.
Index altered.
Index altered.
Index altered.
Index altered.
Index altered.
Index altered.
Index altered.
SQL> set linesize 150
column OWNER format a20
column INDEX_NAME format a20
column INDEX_TYPE format a10
column TABLE_OWNER format a15
column TABLE_NAME format a15
select owner,index_name, index_type, table_owner,
table_name, partitioned, status,
TO_CHAR(last_analyzed, 'DD-MON-YYYY HH24:MI:SS') AS last_analyzed
from dba_indexes
where table_owner='SYS'
and table_name='WRH$_SEG_STAT';
OWNER INDEX_NAME INDEX_TYPE TABLE_OWNER TABLE_NAME PAR STATUS LAST_ANALYZED
-------------------- -------------------- ---------- --------------- --------------- --- -------- --------------------------
SYS WRH$_SEG_STAT_PK NORMAL SYS WRH$_SEG_STAT YES N/A 10-JUN-2018 06:00:53
SQL> analyze table SYS.WRH$_SEG_STAT validate structure cascade online;
analyze table SYS.WRH$_SEG_STAT validate structure cascade online
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found
SQL> @?/rdbms/admin/utlvalid.sql
Table created.
SQL> analyze table sh.sales partition (SALES_Q4_2000) validate structure cascade;
SQL> analyze table
select dba_tables
PARTITIONED
set linesize 150
column table_name format a20
column tablespace_name format a20
column partitioned format a20
SELECT table_name, tablespace_name, partitioned
FROM dba_tables
WHERE table_name='WRH$_SEG_STAT';
TABLE_NAME TABLESPACE_NAME PARTITIONED
-------------------- -------------------- --------------------
WRH$_SEG_STAT YES
set linesize 150
set pagesize 10000
column table_name format a30
column tablespace_name format a20
column partitioned format a20
SELECT table_name, tablespace_name, partitioned
FROM dba_tables
WHERE table_name LIKE 'WRH$%'
AND partitioned='YES'
ORDER BY table_name;
TABLE_NAME TABLESPACE_NAME PARTITIONED
------------------------------ -------------------- --------------------
WRH$_ACTIVE_SESSION_HISTORY YES
WRH$_DB_CACHE_ADVICE YES
WRH$_DLM_MISC YES
WRH$_EVENT_HISTOGRAM YES
WRH$_FILESTATXS YES
WRH$_INST_CACHE_TRANSFER YES
WRH$_INTERCONNECT_PINGS YES
WRH$_LATCH YES
WRH$_LATCH_CHILDREN YES
WRH$_LATCH_MISSES_SUMMARY YES
WRH$_LATCH_PARENT YES
WRH$_MVPARAMETER YES
WRH$_OSSTAT YES
WRH$_PARAMETER YES
WRH$_ROWCACHE_SUMMARY YES
WRH$_SEG_STAT YES
WRH$_SERVICE_STAT YES
WRH$_SERVICE_WAIT_CLASS YES
WRH$_SGASTAT YES
WRH$_SQLSTAT YES
WRH$_SYSSTAT YES
WRH$_SYSTEM_EVENT YES
WRH$_SYS_TIME_MODEL YES
WRH$_TABLESPACE_STAT YES
WRH$_WAITSTAT YES
25 rows selected.
SQL> set linesize 150
column part_name format a35
column tbsp_name format a9
column high_value format a90
SELECT partition_name PART_NAME, tablespace_name TBSP_NAME
FROM user_tab_partitions
WHERE table_name = 'WRH$_SEG_STAT';
PART_NAME TBSP_NAME
----------------------------------- ---------
WRH$_SEG_STAT_MXDB_MXSN SYSAUX
WRH$_SEG_ST_2038560152_51584 SYSAUX
WRH$_SEG_ST_2038560152_51608 SYSAUX
WRH$_SEG_ST_2038560152_51632 SYSAUX
WRH$_SEG_ST_2038560152_51656 SYSAUX
WRH$_SEG_ST_2038560152_51680 SYSAUX
WRH$_SEG_ST_2038560152_51704 SYSAUX
WRH$_SEG_ST_2038560152_51728 SYSAUX
WRH$_SEG_ST_2038560152_51752 SYSAUX
WRH$_SEG_ST_2038560152_51798 SYSAUX
10 rows selected.
SQL> analyze table
SQL> set linesize 150
select 'analyze table '||table_name||' partition ('||partition_name||') validate structure cascade into invalid_rows;'
from user_tab_partitions
where table_name = 'WRH$_SEG_STAT';
'ANALYZETABLE'||TABLE_NAME||'PARTITION('||PARTITION_NAME||')VALIDATESTRUCTURECASCADEINTOINVALID_ROWS;'
-------------------------------------------------------------------------------------------------------------------------------------
analyze table WRH$_SEG_STAT partition (WRH$_SEG_STAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51798) validate structure cascade into invalid_rows;
10 rows selected.
vi /tmp/analyze_par_table.sql
sqlplus / as sysdba;
SQL> @/tmp/analyze_par_table.sql
Table analyzed.
Table analyzed.
Table analyzed.
Table analyzed.
Table analyzed.
Table analyzed.
Table analyzed.
Table analyzed.
Table analyzed.
Table analyzed.
******************************************************************************************************************************************************
SQL> set linesize 150
set pagesize 1000
select 'analyze table '||table_name||' partition ('||partition_name||') validate structure cascade into invalid_rows;'
from user_tab_partitions
where table_name IN (SELECT table_name
FROM dba_tables
WHERE table_name LIKE 'WRH$%'
AND partitioned='YES')
order by table_name;
'ANALYZETABLE'||TABLE_NAME||'PARTITION('||PARTITION_NAME||')VALIDATESTRUCTURECASCADEINTOINVALID_ROWS;'
-------------------------------------------------------------------------------------------------------------------------------------
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_SES_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CACHE_AD_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_DLM_MISC partition (WRH$_DLM_MI_2038560152_0) validate structure cascade into invalid_rows;
analyze table WRH$_DLM_MISC partition (WRH$_DLM_MISC_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT_HISTO_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILESTATXS_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_INST_CACHE_TRANSFER partition (WRH$_INST_CACHE_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_INST_CACHE_TRANSFER partition (WRH$_INST_C_2038560152_0) validate structure cascade into invalid_rows;
analyze table WRH$_INTERCONNECT_PINGS partition (WRH$_IC_PINGS_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_INTERCONNECT_PINGS partition (WRH$_INTERC_2038560152_0) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_CHILDREN partition (WRH$_LATCH__2038560152_0) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_CHILDREN partition (WRH$_LATCH_CHILD_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH_MISSE_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_PARENT partition (WRH$_LATCH_PAREN_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_PARENT partition (WRH$_LATCH__2038560152_0) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARAMETER_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAMETER_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCACHE_SU_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_STAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVICE_STAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVICE_WAIT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_EVEN_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TIME_MO_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLESPACE_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITSTAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51680) validate structure cascade into invalid_rows;
210 rows selected.
cd /data/oracle/SHPMLS/backup
vi /tmp/analyze_par_table_all.sql
sqlplus / as sysdba;
SQL> spool analyze_par_table_all.log
SQL> @/tmp/analyze_par_table_all.sql
SQL> spool off
SQL> set linesize 150
set pagesize 1000
select 'analyze table '||table_name||' partition ('||partition_name||') validate structure cascade into invalid_rows;'
from user_tab_partitions
where table_name IN (SELECT table_name
FROM dba_tables
WHERE table_name LIKE 'WR%'
AND partitioned='YES')
order by table_name;
'ANALYZETABLE'||TABLE_NAME||'PARTITION('||PARTITION_NAME||')VALIDATESTRUCTURECASCADEINTOINVALID_ROWS;'
-------------------------------------------------------------------------------------------------------------------------------------
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_SES_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CACHE_AD_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_DLM_MISC partition (WRH$_DLM_MI_2038560152_0) validate structure cascade into invalid_rows;
analyze table WRH$_DLM_MISC partition (WRH$_DLM_MISC_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT_HISTO_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILESTATXS_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_INST_CACHE_TRANSFER partition (WRH$_INST_CACHE_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_INST_CACHE_TRANSFER partition (WRH$_INST_C_2038560152_0) validate structure cascade into invalid_rows;
analyze table WRH$_INTERCONNECT_PINGS partition (WRH$_IC_PINGS_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_INTERCONNECT_PINGS partition (WRH$_INTERC_2038560152_0) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH partition (WRH$_LATCH_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_CHILDREN partition (WRH$_LATCH__2038560152_0) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_CHILDREN partition (WRH$_LATCH_CHILD_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH_MISSE_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_PARENT partition (WRH$_LATCH_PAREN_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_PARENT partition (WRH$_LATCH__2038560152_0) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARAMETER_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAMETER_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCACHE_SU_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_STAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SEG_STAT partition (WRH$_SEG_ST_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVICE_STAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVICE_WAIT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_WAIT_CLASS partition (WRH$_SERVIC_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTA_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SQLSTAT partition (WRH$_SQLSTAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SYSTEM_EVENT partition (WRH$_SYSTEM_EVEN_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TIME_MO_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRH$_TABLESPACE_STAT partition (WRH$_TABLESPACE_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51680) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51798) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51752) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51728) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51704) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITSTAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51656) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51632) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51608) validate structure cascade into invalid_rows;
analyze table WRH$_WAITSTAT partition (WRH$_WAITST_2038560152_51584) validate structure cascade into invalid_rows;
analyze table WRI$_OPTSTAT_SYNOPSIS$ partition (P0) validate structure cascade into invalid_rows;
211 rows selected.
SQL> analyze table WRI$_OPTSTAT_SYNOPSIS$ partition (P0) validate structure cascade into invalid_rows;
Table analyzed.
cd /data/oracle/SHPMLS/backup
vi /tmp/analyze_par_table_all.sql
sqlplus / as sysdba;
SQL> spool analyze_par_table_all.log
SQL> @/tmp/analyze_par_table_all.sql
SQL> spool off
set linesize 150
set pagesize 10000
select 'analyze table '||owner||'.'||table_name||' validate structure cascade online;'
from dba_tables
where owner='SYS'
and table_name like 'WR%'
and partitioned='NO'
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$_MTTR_TARGET_ADVICE 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_ASA_RECO_DATA 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_OBJSPACE_CHROW_DATA validate structure cascade online;
analyze table SYS.WRI$_ADV_OBJSPACE_TREND_DATA 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$_SQLMON_USAGE 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_STS_TOPACK 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$_CAPTURE_UC_GRAPH 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_CALL_FILTER validate structure cascade online;
analyze table SYS.WRR$_REPLAY_COMMITS validate structure cascade online;
analyze table SYS.WRR$_REPLAY_DATA validate structure cascade online;
analyze table SYS.WRR$_REPLAY_DEP_GRAPH 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_REFERENCES 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$_REPLAY_UC_GRAPH validate structure cascade online;
analyze table SYS.WRR$_SEQUENCE_EXCEPTIONS validate structure cascade online;
analyze table SYS.WRR$_WORKLOAD_ATTRIBUTES validate structure cascade online;
219 rows selected.
cd /data/oracle/SHPMLS/backup
vi /tmp/analyze_normal_table_all.sql
sqlplus / as sysdba;
SQL> spool analyze_normal_table_all.log
SQL> @/tmp/analyze_normal_table_all.sql
SQL> spool off