温馨提示×

温馨提示×

您好，登录后才能下订单哦！

密码登录×
登录注册×
获取短信验证码
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》
登 录 注册有礼
云服务器 香港服务器 高防服务器
最新更新 网站标签 地图导航
产品

Check all partioned tables & Indexes

发布时间：2020-08-11 11:06:57 来源：ITPUB博客 阅读：126 作者：hadba 栏目：关系型数据库


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.

向AI问一下细节
推荐阅读：
  1. 01 Oracle 简介和安装
  2. 解决ORACLE启动出错ORA-00119，ORA-00132

免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。

check amp partioned

猜你喜欢

最新资讯
相关推荐

相关标签

pt-duplicate-key-checker checkpoint pt-table-checksum checklist checkbox checks checked check_load check_mk crosscheck check_http checkpoin checkboxlist checksum checkout checkpointer jcheckbox unchecked mysqlcheck
AI
助
手
产品服务
地区划分
专题活动
帮助支持
关于我们
售后咨询
7*24小时在线电话：400-100-2938
7*24小时在线 QQ：800811969
关注亿速云

亿速云公众号

手机网站二维码

Copyright © Yisu Cloud Ltd. All Rights Reserved. 2018 版权所有

广州亿速云计算有限公司粤ICP备17096448号-1 粤公网安备 44010402001142号增值电信业务经营许可证编号：B1-20181529