溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
SQL> 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 'WR%'
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
WRI$_OPTSTAT_SYNOPSIS$ YES
26 rows selected.
SQL> set linesize 180
set pagesize 10000
column owner format a10
column index_type format a25
column table_name format a35
column index_name format a35
column partitioned format a10
column tablespace_name format a15
column partitioned format a20
SELECT dt.table_name,
di.owner,
di.INDEX_NAME,
di.INDEX_TYPE,
di.partitioned,
di.tablespace_name,
di.STATUS
FROM DBA_INDEXES di , DBA_TABLES dt
WHERE dt.table_name = di.table_name
AND di.table_name LIKE 'WR%'
AND di.partitioned='YES'
order by di.partitioned, di.owner, dt.table_name;
TABLE_NAME OWNER INDEX_NAME INDEX_TYPE PARTITIONED TABLESPACE_NAME STATUS
----------------------------------- ---------- ----------------------------------- ------------------------- -------------------- --------------- --------
WRH$_ACTIVE_SESSION_HISTORY SYS WRH$_ACTIVE_SESSION_HISTORY_PK NORMAL YES N/A
WRH$_DB_CACHE_ADVICE SYS WRH$_DB_CACHE_ADVICE_PK NORMAL YES N/A
WRH$_DLM_MISC SYS WRH$_DLM_MISC_PK NORMAL YES N/A
WRH$_EVENT_HISTOGRAM SYS WRH$_EVENT_HISTOGRAM_PK NORMAL YES N/A
WRH$_FILESTATXS SYS WRH$_FILESTATXS_PK NORMAL YES N/A
WRH$_INST_CACHE_TRANSFER SYS WRH$_INST_CACHE_TRANSFER_PK NORMAL YES N/A
WRH$_INTERCONNECT_PINGS SYS WRH$_INTERCONNECT_PINGS_PK NORMAL YES N/A
WRH$_LATCH SYS WRH$_LATCH_PK NORMAL YES N/A
WRH$_LATCH_CHILDREN SYS WRH$_LATCH_CHILDREN_PK NORMAL YES N/A
WRH$_LATCH_MISSES_SUMMARY SYS WRH$_LATCH_MISSES_SUMMARY_PK NORMAL YES N/A
WRH$_LATCH_PARENT SYS WRH$_LATCH_PARENT_PK NORMAL YES N/A
WRH$_MVPARAMETER SYS WRH$_MVPARAMETER_PK NORMAL YES N/A
WRH$_OSSTAT SYS WRH$_OSSTAT_PK NORMAL YES N/A
WRH$_PARAMETER SYS WRH$_PARAMETER_PK NORMAL YES N/A
WRH$_ROWCACHE_SUMMARY SYS WRH$_ROWCACHE_SUMMARY_PK NORMAL YES N/A
WRH$_SEG_STAT SYS WRH$_SEG_STAT_PK NORMAL YES N/A
WRH$_SERVICE_STAT SYS WRH$_SERVICE_STAT_PK NORMAL YES N/A
WRH$_SERVICE_WAIT_CLASS SYS WRH$_SERVICE_WAIT_CLASS_PK NORMAL YES N/A
WRH$_SGASTAT SYS WRH$_SGASTAT_U NORMAL YES N/A
WRH$_SQLSTAT SYS WRH$_SQLSTAT_INDEX NORMAL YES N/A
WRH$_SQLSTAT SYS WRH$_SQLSTAT_PK NORMAL YES N/A
WRH$_SYSSTAT SYS WRH$_SYSSTAT_PK NORMAL YES N/A
WRH$_SYSTEM_EVENT SYS WRH$_SYSTEM_EVENT_PK NORMAL YES N/A
WRH$_SYS_TIME_MODEL SYS WRH$_SYS_TIME_MODEL_PK NORMAL YES N/A
WRH$_TABLESPACE_STAT SYS WRH$_TABLESPACE_STAT_PK NORMAL YES N/A
WRH$_WAITSTAT SYS WRH$_WAITSTAT_PK NORMAL YES N/A
26 rows selected.
************************************************************************************************************************
Generate Script to Analyze on all Partitioned Tables
************************************************************************************************************************
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_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_2038560152_51680) 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_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_51822) 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$_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_51798) 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_51608) 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_51822) 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$_DB_CACHE_ADVICE partition (WRH$_DB_CAC_2038560152_51752) 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_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_51656) validate structure cascade into invalid_rows;
analyze table WRH$_EVENT_HISTOGRAM partition (WRH$_EVENT__2038560152_51822) 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_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$_FILESTATXS partition (WRH$_FILESTATXS_MXDB_MXSN) 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_51656) validate structure cascade into invalid_rows;
analyze table WRH$_FILESTATXS partition (WRH$_FILEST_2038560152_51822) 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_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$_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_51822) 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_51752) 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_51798) 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 partition (WRH$_LATCH_2038560152_51728) 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_51798) validate structure cascade into invalid_rows;
analyze table WRH$_LATCH_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51822) 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_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_MISSES_SUMMARY partition (WRH$_LATCH__2038560152_51752) 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_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_51656) validate structure cascade into invalid_rows;
analyze table WRH$_MVPARAMETER partition (WRH$_MVPARA_2038560152_51822) 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_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$_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_2038560152_51680) 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_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_51822) validate structure cascade into invalid_rows;
analyze table WRH$_OSSTAT partition (WRH$_OSSTAT_2038560152_51704) 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_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_51656) validate structure cascade into invalid_rows;
analyze table WRH$_PARAMETER partition (WRH$_PARAME_2038560152_51822) 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_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$_ROWCACHE_SUMMARY partition (WRH$_ROWCACHE_SU_MXDB_MXSN) 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_51656) validate structure cascade into invalid_rows;
analyze table WRH$_ROWCACHE_SUMMARY partition (WRH$_ROWCAC_2038560152_51822) 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_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$_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_STAT_MXDB_MXSN) 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_51822) 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$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51798) 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$_SERVICE_STAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SERVICE_STAT partition (WRH$_SERVIC_2038560152_51822) 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_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_51822) 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$_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$_SERVICE_WAIT_MXDB_MXSN) 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$_SGASTAT partition (WRH$_SGASTA_2038560152_51822) 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$_SGASTAT_MXDB_MXSN) validate structure cascade into invalid_rows;
analyze table WRH$_SGASTAT partition (WRH$_SGASTA_2038560152_51608) 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_51822) 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_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$_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_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_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SYSSTAT partition (WRH$_SYSSTA_2038560152_51822) 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_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$_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_2038560152_51822) 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_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_51656) validate structure cascade into invalid_rows;
analyze table WRH$_SYS_TIME_MODEL partition (WRH$_SYS_TI_2038560152_51822) 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_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$_TABLESPACE_STAT partition (WRH$_TABLES_2038560152_51822) 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$_TABLESPACE_MXDB_MXSN) 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$_WAITST_2038560152_51822) 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$_WAITSTAT_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_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 WRI$_OPTSTAT_SYNOPSIS$ partition (P0) validate structure cascade into invalid_rows;
211 rows selected.
**********************************************************************************************************************************************************************
Rebuild all partitioned Indexes
******************************************************************************************************************************************
set linesize 150
column index_name format a40
select index_name
from dba_indexes
where TABLE_OWNER='SYS'
and table_name like 'WR%'
AND partitioned='YES'
order by index_name;
INDEX_NAME
----------------------------------------
WRH$_ACTIVE_SESSION_HISTORY_PK
WRH$_DB_CACHE_ADVICE_PK
WRH$_DLM_MISC_PK
WRH$_EVENT_HISTOGRAM_PK
WRH$_FILESTATXS_PK
WRH$_INST_CACHE_TRANSFER_PK
WRH$_INTERCONNECT_PINGS_PK
WRH$_LATCH_CHILDREN_PK
WRH$_LATCH_MISSES_SUMMARY_PK
WRH$_LATCH_PARENT_PK
WRH$_LATCH_PK
WRH$_MVPARAMETER_PK
WRH$_OSSTAT_PK
WRH$_PARAMETER_PK
WRH$_ROWCACHE_SUMMARY_PK
WRH$_SEG_STAT_PK
WRH$_SERVICE_STAT_PK
WRH$_SERVICE_WAIT_CLASS_PK
WRH$_SGASTAT_U
WRH$_SQLSTAT_INDEX
WRH$_SQLSTAT_PK
WRH$_SYSSTAT_PK
WRH$_SYSTEM_EVENT_PK
WRH$_SYS_TIME_MODEL_PK
WRH$_TABLESPACE_STAT_PK
WRH$_WAITSTAT_PK
26 rows selected.
SQL> set linesize 150
select 'alter index '||index_name||' rebuild partition '||partition_name||' online;'
from dba_ind_partitions
where index_name IN (select index_name
from dba_indexes
where TABLE_OWNER='SYS'
and table_name like 'WR%'
AND partitioned='YES')
order by index_name;
'ALTERINDEX'||INDEX_NAME||'REBUILDPARTITION'||PARTITION_NAME||'ONLINE;'
---------------------------------------------------------------------------------------------------
alter index WRH$_ACTIVE_SESSION_HISTORY_PK rebuild partition WRH$_ACTIVE_2038560152_51608 online;
alter index WRH$_ACTIVE_SESSION_HISTORY_PK rebuild partition WRH$_ACTIVE_2038560152_51632 online;
alter index WRH$_ACTIVE_SESSION_HISTORY_PK rebuild partition WRH$_ACTIVE_2038560152_51656 online;
alter index WRH$_ACTIVE_SESSION_HISTORY_PK rebuild partition WRH$_ACTIVE_2038560152_51680 online;
alter index WRH$_ACTIVE_SESSION_HISTORY_PK rebuild partition WRH$_ACTIVE_SES_MXDB_MXSN online;
alter index WRH$_ACTIVE_SESSION_HISTORY_PK rebuild partition WRH$_ACTIVE_2038560152_51728 online;
alter index WRH$_ACTIVE_SESSION_HISTORY_PK rebuild partition WRH$_ACTIVE_2038560152_51752 online;
alter index WRH$_ACTIVE_SESSION_HISTORY_PK rebuild partition WRH$_ACTIVE_2038560152_51798 online;
alter index WRH$_ACTIVE_SESSION_HISTORY_PK rebuild partition WRH$_ACTIVE_2038560152_51822 online;
alter index WRH$_ACTIVE_SESSION_HISTORY_PK rebuild partition WRH$_ACTIVE_2038560152_51704 online;
alter index WRH$_DB_CACHE_ADVICE_PK rebuild partition WRH$_DB_CACHE_AD_MXDB_MXSN online;
alter index WRH$_DB_CACHE_ADVICE_PK rebuild partition WRH$_DB_CAC_2038560152_51608 online;
alter index WRH$_DB_CACHE_ADVICE_PK rebuild partition WRH$_DB_CAC_2038560152_51632 online;
alter index WRH$_DB_CACHE_ADVICE_PK rebuild partition WRH$_DB_CAC_2038560152_51656 online;
alter index WRH$_DB_CACHE_ADVICE_PK rebuild partition WRH$_DB_CAC_2038560152_51680 online;
alter index WRH$_DB_CACHE_ADVICE_PK rebuild partition WRH$_DB_CAC_2038560152_51704 online;
alter index WRH$_DB_CACHE_ADVICE_PK rebuild partition WRH$_DB_CAC_2038560152_51822 online;
alter index WRH$_DB_CACHE_ADVICE_PK rebuild partition WRH$_DB_CAC_2038560152_51728 online;
alter index WRH$_DB_CACHE_ADVICE_PK rebuild partition WRH$_DB_CAC_2038560152_51752 online;
alter index WRH$_DB_CACHE_ADVICE_PK rebuild partition WRH$_DB_CAC_2038560152_51798 online;
alter index WRH$_DLM_MISC_PK rebuild partition WRH$_DLM_MISC_MXDB_MXSN online;
alter index WRH$_DLM_MISC_PK rebuild partition WRH$_DLM_MI_2038560152_0 online;
alter index WRH$_EVENT_HISTOGRAM_PK rebuild partition WRH$_EVENT_HISTO_MXDB_MXSN online;
alter index WRH$_EVENT_HISTOGRAM_PK rebuild partition WRH$_EVENT__2038560152_51608 online;
alter index WRH$_EVENT_HISTOGRAM_PK rebuild partition WRH$_EVENT__2038560152_51632 online;
alter index WRH$_EVENT_HISTOGRAM_PK rebuild partition WRH$_EVENT__2038560152_51656 online;
alter index WRH$_EVENT_HISTOGRAM_PK rebuild partition WRH$_EVENT__2038560152_51822 online;
alter index WRH$_EVENT_HISTOGRAM_PK rebuild partition WRH$_EVENT__2038560152_51704 online;
alter index WRH$_EVENT_HISTOGRAM_PK rebuild partition WRH$_EVENT__2038560152_51728 online;
alter index WRH$_EVENT_HISTOGRAM_PK rebuild partition WRH$_EVENT__2038560152_51752 online;
alter index WRH$_EVENT_HISTOGRAM_PK rebuild partition WRH$_EVENT__2038560152_51798 online;
alter index WRH$_EVENT_HISTOGRAM_PK rebuild partition WRH$_EVENT__2038560152_51680 online;
alter index WRH$_FILESTATXS_PK rebuild partition WRH$_FILESTATXS_MXDB_MXSN online;
alter index WRH$_FILESTATXS_PK rebuild partition WRH$_FILEST_2038560152_51608 online;
alter index WRH$_FILESTATXS_PK rebuild partition WRH$_FILEST_2038560152_51632 online;
alter index WRH$_FILESTATXS_PK rebuild partition WRH$_FILEST_2038560152_51656 online;
alter index WRH$_FILESTATXS_PK rebuild partition WRH$_FILEST_2038560152_51822 online;
alter index WRH$_FILESTATXS_PK rebuild partition WRH$_FILEST_2038560152_51704 online;
alter index WRH$_FILESTATXS_PK rebuild partition WRH$_FILEST_2038560152_51728 online;
alter index WRH$_FILESTATXS_PK rebuild partition WRH$_FILEST_2038560152_51752 online;
alter index WRH$_FILESTATXS_PK rebuild partition WRH$_FILEST_2038560152_51798 online;
alter index WRH$_FILESTATXS_PK rebuild partition WRH$_FILEST_2038560152_51680 online;
alter index WRH$_INST_CACHE_TRANSFER_PK rebuild partition WRH$_INST_CACHE_MXDB_MXSN online;
alter index WRH$_INST_CACHE_TRANSFER_PK rebuild partition WRH$_INST_C_2038560152_0 online;
alter index WRH$_INTERCONNECT_PINGS_PK rebuild partition WRH$_IC_PINGS_MXDB_MXSN online;
alter index WRH$_INTERCONNECT_PINGS_PK rebuild partition WRH$_INTERC_2038560152_0 online;
alter index WRH$_LATCH_CHILDREN_PK rebuild partition WRH$_LATCH_CHILD_MXDB_MXSN online;
alter index WRH$_LATCH_CHILDREN_PK rebuild partition WRH$_LATCH__2038560152_0 online;
alter index WRH$_LATCH_MISSES_SUMMARY_PK rebuild partition WRH$_LATCH__2038560152_51632 online;
alter index WRH$_LATCH_MISSES_SUMMARY_PK rebuild partition WRH$_LATCH__2038560152_51656 online;
alter index WRH$_LATCH_MISSES_SUMMARY_PK rebuild partition WRH$_LATCH__2038560152_51680 online;
alter index WRH$_LATCH_MISSES_SUMMARY_PK rebuild partition WRH$_LATCH__2038560152_51704 online;
alter index WRH$_LATCH_MISSES_SUMMARY_PK rebuild partition WRH$_LATCH__2038560152_51728 online;
alter index WRH$_LATCH_MISSES_SUMMARY_PK rebuild partition WRH$_LATCH__2038560152_51752 online;
alter index WRH$_LATCH_MISSES_SUMMARY_PK rebuild partition WRH$_LATCH__2038560152_51798 online;
alter index WRH$_LATCH_MISSES_SUMMARY_PK rebuild partition WRH$_LATCH__2038560152_51608 online;
alter index WRH$_LATCH_MISSES_SUMMARY_PK rebuild partition WRH$_LATCH_MISSE_MXDB_MXSN online;
alter index WRH$_LATCH_MISSES_SUMMARY_PK rebuild partition WRH$_LATCH__2038560152_51822 online;
alter index WRH$_LATCH_PARENT_PK rebuild partition WRH$_LATCH_PAREN_MXDB_MXSN online;
alter index WRH$_LATCH_PARENT_PK rebuild partition WRH$_LATCH__2038560152_0 online;
alter index WRH$_LATCH_PK rebuild partition WRH$_LATCH_2038560152_51656 online;
alter index WRH$_LATCH_PK rebuild partition WRH$_LATCH_MXDB_MXSN online;
alter index WRH$_LATCH_PK rebuild partition WRH$_LATCH_2038560152_51704 online;
alter index WRH$_LATCH_PK rebuild partition WRH$_LATCH_2038560152_51728 online;
alter index WRH$_LATCH_PK rebuild partition WRH$_LATCH_2038560152_51752 online;
alter index WRH$_LATCH_PK rebuild partition WRH$_LATCH_2038560152_51798 online;
alter index WRH$_LATCH_PK rebuild partition WRH$_LATCH_2038560152_51822 online;
alter index WRH$_LATCH_PK rebuild partition WRH$_LATCH_2038560152_51632 online;
alter index WRH$_LATCH_PK rebuild partition WRH$_LATCH_2038560152_51608 online;
alter index WRH$_LATCH_PK rebuild partition WRH$_LATCH_2038560152_51680 online;
alter index WRH$_MVPARAMETER_PK rebuild partition WRH$_MVPARAMETER_MXDB_MXSN online;
alter index WRH$_MVPARAMETER_PK rebuild partition WRH$_MVPARA_2038560152_51608 online;
alter index WRH$_MVPARAMETER_PK rebuild partition WRH$_MVPARA_2038560152_51632 online;
alter index WRH$_MVPARAMETER_PK rebuild partition WRH$_MVPARA_2038560152_51656 online;
alter index WRH$_MVPARAMETER_PK rebuild partition WRH$_MVPARA_2038560152_51822 online;
alter index WRH$_MVPARAMETER_PK rebuild partition WRH$_MVPARA_2038560152_51704 online;
alter index WRH$_MVPARAMETER_PK rebuild partition WRH$_MVPARA_2038560152_51728 online;
alter index WRH$_MVPARAMETER_PK rebuild partition WRH$_MVPARA_2038560152_51752 online;
alter index WRH$_MVPARAMETER_PK rebuild partition WRH$_MVPARA_2038560152_51798 online;
alter index WRH$_MVPARAMETER_PK rebuild partition WRH$_MVPARA_2038560152_51680 online;
alter index WRH$_OSSTAT_PK rebuild partition WRH$_OSSTAT_2038560152_51608 online;
alter index WRH$_OSSTAT_PK rebuild partition WRH$_OSSTAT_2038560152_51632 online;
alter index WRH$_OSSTAT_PK rebuild partition WRH$_OSSTAT_2038560152_51656 online;
alter index WRH$_OSSTAT_PK rebuild partition WRH$_OSSTAT_2038560152_51680 online;
alter index WRH$_OSSTAT_PK rebuild partition WRH$_OSSTAT_MXDB_MXSN online;
alter index WRH$_OSSTAT_PK rebuild partition WRH$_OSSTAT_2038560152_51728 online;
alter index WRH$_OSSTAT_PK rebuild partition WRH$_OSSTAT_2038560152_51752 online;
alter index WRH$_OSSTAT_PK rebuild partition WRH$_OSSTAT_2038560152_51798 online;
alter index WRH$_OSSTAT_PK rebuild partition WRH$_OSSTAT_2038560152_51822 online;
alter index WRH$_OSSTAT_PK rebuild partition WRH$_OSSTAT_2038560152_51704 online;
alter index WRH$_PARAMETER_PK rebuild partition WRH$_PARAMETER_MXDB_MXSN online;
alter index WRH$_PARAMETER_PK rebuild partition WRH$_PARAME_2038560152_51608 online;
alter index WRH$_PARAMETER_PK rebuild partition WRH$_PARAME_2038560152_51632 online;
alter index WRH$_PARAMETER_PK rebuild partition WRH$_PARAME_2038560152_51656 online;
alter index WRH$_PARAMETER_PK rebuild partition WRH$_PARAME_2038560152_51822 online;
alter index WRH$_PARAMETER_PK rebuild partition WRH$_PARAME_2038560152_51704 online;
alter index WRH$_PARAMETER_PK rebuild partition WRH$_PARAME_2038560152_51728 online;
alter index WRH$_PARAMETER_PK rebuild partition WRH$_PARAME_2038560152_51752 online;
alter index WRH$_PARAMETER_PK rebuild partition WRH$_PARAME_2038560152_51798 online;
alter index WRH$_PARAMETER_PK rebuild partition WRH$_PARAME_2038560152_51680 online;
alter index WRH$_ROWCACHE_SUMMARY_PK rebuild partition WRH$_ROWCACHE_SU_MXDB_MXSN online;
alter index WRH$_ROWCACHE_SUMMARY_PK rebuild partition WRH$_ROWCAC_2038560152_51608 online;
alter index WRH$_ROWCACHE_SUMMARY_PK rebuild partition WRH$_ROWCAC_2038560152_51632 online;
alter index WRH$_ROWCACHE_SUMMARY_PK rebuild partition WRH$_ROWCAC_2038560152_51656 online;
alter index WRH$_ROWCACHE_SUMMARY_PK rebuild partition WRH$_ROWCAC_2038560152_51822 online;
alter index WRH$_ROWCACHE_SUMMARY_PK rebuild partition WRH$_ROWCAC_2038560152_51704 online;
alter index WRH$_ROWCACHE_SUMMARY_PK rebuild partition WRH$_ROWCAC_2038560152_51728 online;
alter index WRH$_ROWCACHE_SUMMARY_PK rebuild partition WRH$_ROWCAC_2038560152_51752 online;
alter index WRH$_ROWCACHE_SUMMARY_PK rebuild partition WRH$_ROWCAC_2038560152_51798 online;
alter index WRH$_ROWCACHE_SUMMARY_PK rebuild partition WRH$_ROWCAC_2038560152_51680 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_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;
alter index WRH$_SEG_STAT_PK rebuild partition WRH$_SEG_ST_2038560152_51822 online;
alter index WRH$_SERVICE_STAT_PK rebuild partition WRH$_SERVIC_2038560152_51656 online;
alter index WRH$_SERVICE_STAT_PK rebuild partition WRH$_SERVIC_2038560152_51632 online;
alter index WRH$_SERVICE_STAT_PK rebuild partition WRH$_SERVIC_2038560152_51608 online;
alter index WRH$_SERVICE_STAT_PK rebuild partition WRH$_SERVICE_STAT_MXDB_MXSN online;
alter index WRH$_SERVICE_STAT_PK rebuild partition WRH$_SERVIC_2038560152_51822 online;
alter index WRH$_SERVICE_STAT_PK rebuild partition WRH$_SERVIC_2038560152_51704 online;
alter index WRH$_SERVICE_STAT_PK rebuild partition WRH$_SERVIC_2038560152_51728 online;
alter index WRH$_SERVICE_STAT_PK rebuild partition WRH$_SERVIC_2038560152_51752 online;
alter index WRH$_SERVICE_STAT_PK rebuild partition WRH$_SERVIC_2038560152_51798 online;
alter index WRH$_SERVICE_STAT_PK rebuild partition WRH$_SERVIC_2038560152_51680 online;
alter index WRH$_SERVICE_WAIT_CLASS_PK rebuild partition WRH$_SERVIC_2038560152_51656 online;
alter index WRH$_SERVICE_WAIT_CLASS_PK rebuild partition WRH$_SERVIC_2038560152_51632 online;
alter index WRH$_SERVICE_WAIT_CLASS_PK rebuild partition WRH$_SERVIC_2038560152_51608 online;
alter index WRH$_SERVICE_WAIT_CLASS_PK rebuild partition WRH$_SERVICE_WAIT_MXDB_MXSN online;
alter index WRH$_SERVICE_WAIT_CLASS_PK rebuild partition WRH$_SERVIC_2038560152_51680 online;
alter index WRH$_SERVICE_WAIT_CLASS_PK rebuild partition WRH$_SERVIC_2038560152_51822 online;
alter index WRH$_SERVICE_WAIT_CLASS_PK rebuild partition WRH$_SERVIC_2038560152_51798 online;
alter index WRH$_SERVICE_WAIT_CLASS_PK rebuild partition WRH$_SERVIC_2038560152_51752 online;
alter index WRH$_SERVICE_WAIT_CLASS_PK rebuild partition WRH$_SERVIC_2038560152_51728 online;
alter index WRH$_SERVICE_WAIT_CLASS_PK rebuild partition WRH$_SERVIC_2038560152_51704 online;
alter index WRH$_SGASTAT_U rebuild partition WRH$_SGASTAT_MXDB_MXSN online;
alter index WRH$_SGASTAT_U rebuild partition WRH$_SGASTA_2038560152_51608 online;
alter index WRH$_SGASTAT_U rebuild partition WRH$_SGASTA_2038560152_51632 online;
alter index WRH$_SGASTAT_U rebuild partition WRH$_SGASTA_2038560152_51656 online;
alter index WRH$_SGASTAT_U rebuild partition WRH$_SGASTA_2038560152_51822 online;
alter index WRH$_SGASTAT_U rebuild partition WRH$_SGASTA_2038560152_51752 online;
alter index WRH$_SGASTAT_U rebuild partition WRH$_SGASTA_2038560152_51728 online;
alter index WRH$_SGASTAT_U rebuild partition WRH$_SGASTA_2038560152_51704 online;
alter index WRH$_SGASTAT_U rebuild partition WRH$_SGASTA_2038560152_51680 online;
alter index WRH$_SGASTAT_U rebuild partition WRH$_SGASTA_2038560152_51798 online;
alter index WRH$_SQLSTAT_INDEX rebuild partition WRH$_SQLSTA_2038560152_51680 online;
alter index WRH$_SQLSTAT_INDEX rebuild partition WRH$_SQLSTA_2038560152_51704 online;
alter index WRH$_SQLSTAT_INDEX rebuild partition WRH$_SQLSTA_2038560152_51728 online;
alter index WRH$_SQLSTAT_INDEX rebuild partition WRH$_SQLSTA_2038560152_51752 online;
alter index WRH$_SQLSTAT_INDEX rebuild partition WRH$_SQLSTA_2038560152_51798 online;
alter index WRH$_SQLSTAT_INDEX rebuild partition WRH$_SQLSTA_2038560152_51822 online;
alter index WRH$_SQLSTAT_INDEX rebuild partition WRH$_SQLSTAT_MXDB_MXSN online;
alter index WRH$_SQLSTAT_INDEX rebuild partition WRH$_SQLSTA_2038560152_51608 online;
alter index WRH$_SQLSTAT_INDEX rebuild partition WRH$_SQLSTA_2038560152_51632 online;
alter index WRH$_SQLSTAT_INDEX rebuild partition WRH$_SQLSTA_2038560152_51656 online;
alter index WRH$_SQLSTAT_PK rebuild partition WRH$_SQLSTA_2038560152_51798 online;
alter index WRH$_SQLSTAT_PK rebuild partition WRH$_SQLSTA_2038560152_51752 online;
alter index WRH$_SQLSTAT_PK rebuild partition WRH$_SQLSTA_2038560152_51728 online;
alter index WRH$_SQLSTAT_PK rebuild partition WRH$_SQLSTA_2038560152_51704 online;
alter index WRH$_SQLSTAT_PK rebuild partition WRH$_SQLSTA_2038560152_51822 online;
alter index WRH$_SQLSTAT_PK rebuild partition WRH$_SQLSTA_2038560152_51656 online;
alter index WRH$_SQLSTAT_PK rebuild partition WRH$_SQLSTA_2038560152_51632 online;
alter index WRH$_SQLSTAT_PK rebuild partition WRH$_SQLSTA_2038560152_51608 online;
alter index WRH$_SQLSTAT_PK rebuild partition WRH$_SQLSTAT_MXDB_MXSN online;
alter index WRH$_SQLSTAT_PK rebuild partition WRH$_SQLSTA_2038560152_51680 online;
alter index WRH$_SYSSTAT_PK rebuild partition WRH$_SYSSTA_2038560152_51798 online;
alter index WRH$_SYSSTAT_PK rebuild partition WRH$_SYSSTA_2038560152_51752 online;
alter index WRH$_SYSSTAT_PK rebuild partition WRH$_SYSSTA_2038560152_51728 online;
alter index WRH$_SYSSTAT_PK rebuild partition WRH$_SYSSTA_2038560152_51704 online;
alter index WRH$_SYSSTAT_PK rebuild partition WRH$_SYSSTA_2038560152_51680 online;
alter index WRH$_SYSSTAT_PK rebuild partition WRH$_SYSSTA_2038560152_51656 online;
alter index WRH$_SYSSTAT_PK rebuild partition WRH$_SYSSTA_2038560152_51632 online;
alter index WRH$_SYSSTAT_PK rebuild partition WRH$_SYSSTA_2038560152_51608 online;
alter index WRH$_SYSSTAT_PK rebuild partition WRH$_SYSSTAT_MXDB_MXSN online;
alter index WRH$_SYSSTAT_PK rebuild partition WRH$_SYSSTA_2038560152_51822 online;
alter index WRH$_SYSTEM_EVENT_PK rebuild partition WRH$_SYSTEM_2038560152_51608 online;
alter index WRH$_SYSTEM_EVENT_PK rebuild partition WRH$_SYSTEM_2038560152_51632 online;
alter index WRH$_SYSTEM_EVENT_PK rebuild partition WRH$_SYSTEM_EVEN_MXDB_MXSN online;
alter index WRH$_SYSTEM_EVENT_PK rebuild partition WRH$_SYSTEM_2038560152_51822 online;
alter index WRH$_SYSTEM_EVENT_PK rebuild partition WRH$_SYSTEM_2038560152_51798 online;
alter index WRH$_SYSTEM_EVENT_PK rebuild partition WRH$_SYSTEM_2038560152_51752 online;
alter index WRH$_SYSTEM_EVENT_PK rebuild partition WRH$_SYSTEM_2038560152_51728 online;
alter index WRH$_SYSTEM_EVENT_PK rebuild partition WRH$_SYSTEM_2038560152_51704 online;
alter index WRH$_SYSTEM_EVENT_PK rebuild partition WRH$_SYSTEM_2038560152_51680 online;
alter index WRH$_SYSTEM_EVENT_PK rebuild partition WRH$_SYSTEM_2038560152_51656 online;
alter index WRH$_SYS_TIME_MODEL_PK rebuild partition WRH$_SYS_TIME_MO_MXDB_MXSN online;
alter index WRH$_SYS_TIME_MODEL_PK rebuild partition WRH$_SYS_TI_2038560152_51798 online;
alter index WRH$_SYS_TIME_MODEL_PK rebuild partition WRH$_SYS_TI_2038560152_51752 online;
alter index WRH$_SYS_TIME_MODEL_PK rebuild partition WRH$_SYS_TI_2038560152_51728 online;
alter index WRH$_SYS_TIME_MODEL_PK rebuild partition WRH$_SYS_TI_2038560152_51822 online;
alter index WRH$_SYS_TIME_MODEL_PK rebuild partition WRH$_SYS_TI_2038560152_51680 online;
alter index WRH$_SYS_TIME_MODEL_PK rebuild partition WRH$_SYS_TI_2038560152_51656 online;
alter index WRH$_SYS_TIME_MODEL_PK rebuild partition WRH$_SYS_TI_2038560152_51632 online;
alter index WRH$_SYS_TIME_MODEL_PK rebuild partition WRH$_SYS_TI_2038560152_51608 online;
alter index WRH$_SYS_TIME_MODEL_PK rebuild partition WRH$_SYS_TI_2038560152_51704 online;
alter index WRH$_TABLESPACE_STAT_PK rebuild partition WRH$_TABLESPACE_MXDB_MXSN online;
alter index WRH$_TABLESPACE_STAT_PK rebuild partition WRH$_TABLES_2038560152_51608 online;
alter index WRH$_TABLESPACE_STAT_PK rebuild partition WRH$_TABLES_2038560152_51632 online;
alter index WRH$_TABLESPACE_STAT_PK rebuild partition WRH$_TABLES_2038560152_51656 online;
alter index WRH$_TABLESPACE_STAT_PK rebuild partition WRH$_TABLES_2038560152_51822 online;
alter index WRH$_TABLESPACE_STAT_PK rebuild partition WRH$_TABLES_2038560152_51704 online;
alter index WRH$_TABLESPACE_STAT_PK rebuild partition WRH$_TABLES_2038560152_51728 online;
alter index WRH$_TABLESPACE_STAT_PK rebuild partition WRH$_TABLES_2038560152_51752 online;
alter index WRH$_TABLESPACE_STAT_PK rebuild partition WRH$_TABLES_2038560152_51798 online;
alter index WRH$_TABLESPACE_STAT_PK rebuild partition WRH$_TABLES_2038560152_51680 online;
alter index WRH$_WAITSTAT_PK rebuild partition WRH$_WAITSTAT_MXDB_MXSN online;
alter index WRH$_WAITSTAT_PK rebuild partition WRH$_WAITST_2038560152_51608 online;
alter index WRH$_WAITSTAT_PK rebuild partition WRH$_WAITST_2038560152_51632 online;
alter index WRH$_WAITSTAT_PK rebuild partition WRH$_WAITST_2038560152_51656 online;
alter index WRH$_WAITSTAT_PK rebuild partition WRH$_WAITST_2038560152_51822 online;
alter index WRH$_WAITSTAT_PK rebuild partition WRH$_WAITST_2038560152_51704 online;
alter index WRH$_WAITSTAT_PK rebuild partition WRH$_WAITST_2038560152_51728 online;
alter index WRH$_WAITSTAT_PK rebuild partition WRH$_WAITST_2038560152_51752 online;
alter index WRH$_WAITSTAT_PK rebuild partition WRH$_WAITST_2038560152_51798 online;
alter index WRH$_WAITSTAT_PK rebuild partition WRH$_WAITST_2038560152_51680 online;
220 rows selected.
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
