ORA-600 kdsgrp1

最新推荐文章于 2024-03-23 11:54:30 发布

cuiding8243

最新推荐文章于 2024-03-23 11:54:30 发布

阅读量117

点赞数

OS: AIX Version 6.1

ORACLE: 10.2.0.4.0

alert日志里出现了

ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []

查看trace文件

*** 2011-05-11 20:38:05.287
*** ACTION NAME:() 2011-05-11 20:38:05.277
*** MODULE NAME:(xxxxxx (TNS V1-V3)) 2011-05-11 20:38:05.277
*** SERVICE NAME:(xxxx) 2011-05-11 20:38:05.277
*** SESSION ID:(1923.23947) 2011-05-11 20:38:05.277
row 0668b4c5.ffffffff continuation at
file# 25 block# 2667717 slot 0 not found
**************************************************
KDSTABN_GET: 0 ..... ntab: 1
curSlot: 0 ..... nrows: 1
**************************************************
*** 2011-05-11 20:38:05.288
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []
Current SQL statement for this session:
SELECT * FROM CUSTOMER WHERE CUSTOMER_ID=:param1

trace文件里面还可以找到绑定的变量。

用绑定的值查询了发现没有问题。

暂且搁置。

查了些资料，可以分析一下索引是否有问题。

SQL> ANALYZE TABLE CUSTOMER VALIDATE STRUCTURE CASCADE ONLINE;

顺便看了下文档上（10gr2）的语法。

Validating Tables, Indexes, Clusters, and Materialized Views

To verify the integrity of the structure of a table, index, cluster, or materialized view, use the ANALYZE statement with the VALIDATE STRUCTURE option. If the structure is valid, no error is returned. However, if the structure is corrupt, you receive an error message.

使用 ANALYZE .. VALIDATE STRUCTURE 可以检查table, index, cluster, materialized view结构上的一致性。如果有效，不返回错误。无效则返回错误信息。

For example, in rare cases such as hardware or other system failures, an index can become corrupted and not perform. correctly. When validating the index, you can confirm that every entry in the index points to the correct row of the associated table. If the index is corrupt, you can drop and re-create it.

检验索引，看是否正确指到了表的对应行。如果索引损坏，可以删掉再重建。

If a table, index, or cluster is corrupt, you should drop it and re-create it. If a materialized view is corrupt, perform. a complete refresh and ensure that you have remedied the problem. If the problem is not corrected, drop and re-create the materialized view.

物化视图损坏可以做一次完全刷新，如果还是没解决，可以删掉再重建。

The following statement analyzes the emp table:

ANALYZE TABLE emp VALIDATE STRUCTURE;

You can validate an object and all related objects (for example, indexes) by including the CASCADE option. The following statement validates the emp table and all associated indexes:

ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE;

使用CASCADE选项可以分析object以及其相关的object（比如索引）的有效性。

You can specify that you want to perform. structure validation online while DML is occurring against the object being validated. There can be a slight performance impact when validating with ongoing DML affecting the object, but this is offset by the flexibility of being able to perform. ANALYZE online. The following statement validates the emp table and all associated indexes online:

ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE ONLINE;

如果想检查的object有DML操作，可以指定online。这个可能会对性能有轻微的影响，但对于可以online 分析（进行DML）带来的灵活性，可以不计这种影响。