ORA-00600

根据内部参数区分,很多是属于Oracle的BUG。

1.  参数: [13011], [67714], [8420412], [2], [8470828], [0], [], [], [], [], [], [] 

索引问题

出现版本: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

出现平台:  Windows XP Version V5.1 Service Pack 3 

处理方法:

 根据object_id(67714)查询索引:

15:28:56 SYS@orcl> select object_type,object_name,owner from dba_objects where DATA_OBJECT_ID=67714;

OBJECT_TYPE
-------------------
OBJECT_NAME
----------------------------------------------------------------------------------------------------
OWNER
------------------------------
TABLE
MGMT_SYSTEM_PERFORMANCE_LOG
SYSMAN


已用时间:  00: 00: 00.21
15:29:34 SYS@orcl> select index_name,owner from dba_indexes where table_name='MGMT_SYSTEM_PERFORMANCE_LOG';

INDEX_NAME                     OWNER
------------------------------ ------------------------------
MGMT_SYSTEM_PERF_LOG_IDX_02    SYSMAN
MGMT_SYSTEM_PERF_LOG_IDX_01    SYSMAN

已用时间:  00: 00: 00.04
15:29:54 SYS@orcl> alter index SYSMAN.MGMT_SYSTEM_PERF_LOG_IDX_02 rebuild online;

索引已更改。

已用时间:  00: 00: 04.90
15:30:08 SYS@orcl> alter index SYSMAN.MGMT_SYSTEM_PERF_LOG_IDX_01 rebuild online;

索引已更改。

已用时间:  00: 00: 00.56