0 积分	1 好友	8 主题

发消息

[常规总体性能调优] ora-600 internal error code, arguments: [insdrv_20], [83972], [0], [1], [], [...

1^#

发表于 2014-6-26 10:11:35 | 查看: 4681| 回复: 5

本帖最后由 qq69033472 于 2014-6-26 10:18 编辑

addata_ora_7216.rar (433.43 KB, 下载次数: 1047)

os version : CentOS release 5.9 (Final)
oracle version : 10.2.0.5 单实例

请大神们帮忙看下

Thu Jun 26 02:00:09 CST 2014
Errors in file /Data/apps/oracle/admin/addata/udump/addata_ora_7216.trc:
ORA-00600: internal error code, arguments: [insdrv_20], [83972], [0], [1], [], [], [], []
ORA-12899: value too large for column "REPORTUSER"."STATIC_10MIN"."CITY" (actual: 40, maximum: 32)
kupprdp: master process DM00 started with pid=34, OS id=7320
to execute - SYS.KUPM$MCP.MAIN('REPORTDUMP', 'REPORTUSER', 'KUPC$C_1_20140626020007', 'KUPC$S_1_20140626020007', 0);
kupprdp: worker process DW01 started with worker id=1, pid=24, OS id=7339
to execute - SYS.KUPW$WORKER.MAIN('REPORTDUMP', 'REPORTUSER');

现在oracle就是在做一个入库操作，每5分钟入库一次数据，入库程序是写的php调用oracle package实现insert。
前天凌晨2点出过一次这个600错误，今天2点又出现了，下面一个ora12899说明是static_10min表city字段不够，很极少量的数据ciyt字段确实特长，但是city作为分区字段，没法增加city字段的长度，这些因长度过长无法入库的数据可以被忽略掉。
但是我感觉应该不完全是字段不够长引起的，因为每5分钟入库基本都有几条city比较长的数据，2天的错误，都是在2点的时候，2点的时候，有个job去汇总static前一天的数据，然后插入到另一个day表。而且单单的insert字段不够长，应该也不会被写到alterlog里面吧。。。看addata_ora_7216.trc文件看不懂。。。所以，请大神们帮忙看看，或者发个关于如何查看trace的文档

分享0

收藏0 回复只看该作者道具举报

吃着猫的蛋挞

2^#

发表于 2014-6-26 11:28:21

秒回复看不懂啊看不懂，但是祝你好运

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2014-7-3 21:05:17

ORA-00600: internal error code, arguments: [insdrv_20], [83972], [0], [1], [], [], [], []
ORA-12899: value too large for column "REPORTUSER"."STATIC_10MIN"."CITY" (actual: 40, maximum: 32)
Current SQL statement for this session:
INSERT INTO

"REPORTUSER"."STATIC_10MIN"."CITY"

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2014-7-3 21:07:44

Bug 14799925  ORA-600 [insdrv_20] When Doing Batch Insert - superseded

Description

If in 10.2.0.x an ORA-00600 [insdrv_20] is being raised and
a) the user is using a batch INSERT using SAVE EXCEPTIONS
b) into a partitioned table
If so you are likely hitting his bug.

Workaround
avoid partition maintenance jobs while the load job is running.

Note:
  This fix can cause the problem described in bug 16388649.
  For interim patches use that fix instead of this one to address both issues.

STATIC_10MIN是分区表吗？

回复只看该作者道具举报