oracle ora_p0,ORA-12801: error signaled in parallel query server P005

在Oracle数据库中,执行了大量分区表的交换操作后,尝试收集统计信息时遇到错误。错误信息显示某个索引或其分区处于不可用状态。这可能由于交换操作导致索引损坏或未正确更新。解决方法可能包括重建受影响的索引,或者检查并修复表和索引的状态。
摘要由CSDN通过智能技术生成

昨天有个分区表,交换了30多个分区(将业务表30多个分区交换到历史表,然后删除业务表这30多个分区),然后今天早上收集统计信息的时候报错了,请教各位,这个需要重建索引吗?为什么收集统计信息的时候会报错?请各位指教,alterlog和trace信息如下:

alertlog:

Mon Mar 03 22:46:36 CST 2014

GATHER_STATS_JOB encountered errors.  Check the trace file.

Mon Mar 03 22:46:36 CST 2014

Errors in file /Data/apps/oracle/admin/detail/bdump/detail_j003_5334.trc:

ORA-12801: error signaled in parallel query server P005

ORA-01502: index 'REPORTUSER.IDX_PROVINCE_DAY' or partition of such index is in unusable state

/Data/apps/oracle/admin/detail/bdump/detail_j003_5334.trc信息:

/Data/apps/oracle/admin/detail/bdump/detail_j003_5334.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /Data/apps/oracle/product/10.2.0/db_1

System name:    Linux

Node name:      localhost.localdomain

Release:        2.6.18-348.el5

Version:        #1 SMP Tue Jan 8 17:53:53 EST 2013

Machine:        x86_64

Instance name: detail

Redo thread mounted by this instance: 1

Oracle process number: 30

Unix process pid: 5334, image: oracle@localhost.localdomain (J003)

*** 2014-03-03 22:46:36.917

*** ACTION NAME:(GATHER_STATS_JOB) 2014-03-03 22:46:36.895

*** MODULE NAME:(DBMS_SCHEDULER) 2014-03-03 22:46:36.895

*** SERVICE NAME:(SYS$USERS) 2014-03-03 22:46:36.895

*** SESSION ID:(134.941) 2014-03-03 22:46:36.895

ORA-12801: error signaled in parallel query server P005

ORA-01502: index 'REPORTUSER.IDX_PROVINCE_DAY' or partition of such index is in unusable state

*** 2014-03-03 22:46:36.917

GATHER_STATS_JOB: GATHER_TABLE_STATS('"REPORTUSER"','"STATIC_AGG_PROVINCE_DAY"','""', ...)

ORA-12801: error signaled in parallel query server P005

ORA-01502: index 'REPORTUSER.IDX_PROVINCE_DAY' or partition of such index is in unusable state

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值