Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.