0 积分	1 好友	10 主题

发消息

[常规总体性能调优] ora_00600(附log,trc),帮忙看看！

1^#

发表于 2013-1-10 11:03:12 | 查看: 4880| 回复: 6

ora_00600(附log,trc),帮忙看看！

log截图.jpg (780.31 KB, 下载次数: 388)

alert.log

gishs1_ora_176930.trc.txt

4.83 MB, 下载次数: 577

trc

分享0

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

whtm8868

2^#

发表于 2013-1-10 11:04:49

aix version 5.3 oracle 10g 10.2.4 两节点RAC

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2013-1-10 22:30:33

ksedmp: internal or fatal error
ORA-00600: 内部错误代码, 参数: [12406], [], [], [], [], [], [], []
Current SQL statement for this session:
SELECT 1 SHAPE, SX_MZSX_PG.OBJECTID, SX_MZSX_PG.SHAPE.points,SX_MZSX_PG.SHAPE.numpts,SX_MZSX_PG.SHAPE.entity,SX_MZSX_PG.SHAPE.minx,SX_MZSX_PG.SHAPE.miny,SX_MZSX_PG.SHAPE.maxx,SX_MZSX_PG.SHAPE.maxy,SX_MZSX_PG.rowid FROM GIS420200000000.SX_MZSX_PG SX_MZSX_PG WHERE SDE.ST_EnvIntersects(SX_MZSX_PG.SHAPE,:1,:2,:3,:4) = 1
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst+001c bl ksedst1 1003F6748 ?
2442208400000063 ?
ksedmp+0290 bl ksedst 104A2C690 ?
ksfdmp+0018 bl 03F26C3C
kgeriv+0108 bl _ptrgl
kgesiv+0080 bl kgeriv BB8043F7FE1A7 ? 1105F0708 ?
FFFFFFFFFFF8890 ? 1050AC028 ?
002420243 ?
ksesic0+0060 bl kgesiv 000000001 ? 104BB6A00 ?
000000000 ? 104BB6A00 ?
1105EE6F0 ?
qertbFetchByRowID+0 bl 03F26600
310
opifch2+141c bl 03F2574C
kpoal8+1608 bl opifch2 FFFFFFFFFFFB964 ?
FFFFFFFFFFFB4A0 ?
FFFFFFFFFFF9A70 ?
opiodr+0ae0 bl _ptrgl
ttcpip+1020 bl _ptrgl
opitsk+1124 bl 01F96AC8
opiino+0990 bl opitsk 1E00000000 ? 000000000 ?
opiodr+0ae0 bl _ptrgl
opidrv+0484 bl 01F95914
sou2o+0090 bl opidrv 3C02D99B7C ? 44065F000 ?

复制代码

Content of other_xml column
===========================
db_version : 10.2.0.4

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2013-1-10 22:32:52

12400 sqlexec/rowsrc table row source access

ORA-00600: 内部错误代码, 参数: [12406], [], [], [], [], [], [], []

12406+ qertbFetchByRowID+DOMAIN

执行计划：

============
Plan Table
============
-------------------------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 3 | |
| 1 | TABLE ACCESS BY INDEX ROWID | SX_MZSX_PG| 59 | 135K | 3 | 00:00:01 |
| 2 | DOMAIN INDEX (Sel: Default - No Stats) | A523_IX1 | | | 0 | |
-------------------------------------------------------------+-----------------------------------+

复制代码

回复只看该作者道具举报

Maclean Liu(刘相兵

5^#

发表于 2013-1-10 22:36:35

12406+ qertbFetchByRowID+DOMAIN =>
Hdr: 8200966 10.1.0.5 RDBMS 10.1.0.5 EXTENSIBILITY PRODID-5 PORTID-46 3813983
Abstract: ORA-600 [12406] ON A QUERY THAT USES ORACLE TEXT INDEXES

考虑先 validate该表和索引

analyze table SX_MZSX_PG validate structure;
analyze index A523_IX1 validate structure;

回复只看该作者道具举报

whtm8868

6^#

发表于 2013-1-11 09:04:28

analyze table SX_MZSX_PG validate structure;
没法执行，sx_mzsx_pg表创建时调用了sde的外库函数，不是普通的数据库表
analyze时报错！

回复只看该作者道具举报

Maclean Liu(刘相兵

7^#

发表于 2013-1-11 09:33:22

analyze index A523_IX1 validate structure; 这个执行一下

Ora-600 [12406] During Select From Table Using Oracle Text (Doc ID 559051.1)

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册