扫码关注官方微信

扫码下载APP
返回顶部
首页 > 资讯 > 数据库 >Check all partioned tables & Indexes
  • 945

0
分享到

Check all partioned tables & Indexes

2024-04-02 19:04:59 945人浏览 薄情痞子
摘要

sql> set linesize 150 set pagesize 10000 column table_name fORMat a30 column tablespace_name f


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.

您可能感兴趣的文档:

--结束END--

本文标题: Check all partioned tables & Indexes

本文链接: https://lsjlt.com/news/48564.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

猜你喜欢
软考高级职称资格查询
热门wiki
近期文章
推荐阅读
热门问答
热门标签
编程网，编程工程师的家园，是目前国内优秀的开源技术社区之一，形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容，为IT开发者提供了一个发现、使用、并交流开源技术的平台。

  • 官方手机版

  • 微信公众号

  • 商务合作