Check all partioned tables & Indexes
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.
