ORA-07445 core dump [kttuser0()+393] [INT_DIVIDE_BY_ZERO] [] [PC:0x160A463] [] []

最新推荐文章于 2024-02-27 15:53:00 发布

hoopfor

最新推荐文章于 2024-02-27 15:53:00 发布

阅读量694

点赞数

飞总：

os：windows 2008 rac 11.2.0.1。

Dump continued from file: d:\app\administrator\diag\rdbms\dbrac\dbrac1\trace\dbrac1_ora_13472.trc
ORA-07445: exception encountered: core dump [kttuser0()+393] [INT_DIVIDE_BY_ZERO] [] [PC:0x160A463] [] []

========= Dump for incident 96385 (ORA 7445 [kttuser0()+393]) ========
—-- Beginning of Customized Incident Dump(s) —--
Exception [type: INT_DIVIDE_BY_ZERO, ] [] [PC:0x160A463, kttuser0()+393]

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
Process Id: 0x00001848 Thread Id : 0x000034a0 Time : Mon Jul 08 16:47:51
Excp. Code: 0xc0000094 Excp. Type: INT_DIVIDE Flags: 0x00000000

——————- Registers —————————-
ip=000000000160A463 sp=000000002EA21C90 rp=000000002EA21DA0
r1=0000000000000030 r2=0000000000006A58 r3=0000000000000000
r4=000000002933C9E0 r5=000000002EA21C90 r6=000000002EA21DA0 r7=0000000015764660
r8=000000002B18FAE0 r9=0000000000000000 r10=0000000000400000 r11=0000000000000004
r12=0000000000000000 r13=0000000035952A38 r14=0000000000020B78 r15=0000000000000000
——————- End of Registers ———————

*** 2013-07-08 16:47:51.241
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
—-- Current SQL Statement for this session (sql_id=cxt1cbqk1jrkp) —--
SELECT DECODE(COUNT(*), 0, 'DISABLED', 'ENABLED') STATUS FROM DBA_AUTOTASK_WINDOW_CLIENTS WHERE SQL_TUNE_ADVISOR = 'ENABLED' AND AUTOTASK_STATUS = 'ENABLED'
—-- PL/SQL Stack —--
—-- PL/SQL Call Stack —--
object line object
handle number name
000007FFFB3B8E90 10970 package body SYS.DBMS_SQLTUNE_INTERNAL
000007FFFB3B8E90 11338 package body SYS.DBMS_SQLTUNE_INTERNAL
000007FFE2771CD8 145 SYS.WRI$_REPT_SQLT
000007FFFC145B68 706 package body SYS.DBMS_REPORT
000007FFFC145B68 729 package body SYS.DBMS_REPORT
000007FFFC17CD28 20 anonymous block

其中有大量的

SO: 0x000007FFFC229D10, type: 74, owner: 0x000007FFFADD81F8, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x000007FFFDB0DC68, name=LIBRARY OBJECT LOCK, file=kgl.h LINE:8348, pg=0

LibraryObjectLock: Address=fc229d10 Handle=fc159e88 Mode=N CanBeBrokenCount=1 Incarnation=1 ExecutionCount=1

User=fadd81f8 Session=fadd81f8 ReferenceCount=1 Flags=CNB/[0001] SavepointNum=51da7cb6
LibraryHandle: Address=fc159e88 Hash=21f6ec47 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD

这的语句有多个

ObjectName: Name=
/* OracleOEM */
DECLARE
rept varchar2(4000);
rref varchar2(4000);
key_enable varchar2(20);
autoimpl_enable varchar2(20);
key_count number;
TYPE data_cursor_type IS REF CURSOR;
data_cursor data_cursor_type;
BEGIN

oem的东西

2013 年 07 月 15 日
15:11

惜分飞

Admin

Forum Posts: 340

Member Since:
2010 年 07 月 31 日

Online

从错误上看和sql tuning advisor相关，在11g中，我们一般建议禁用sql tuning advisor，你可以尝试使用下面方法

禁用sql tuning advisor

BEGIN
   dbms_auto_task_admin.disable(
   client_name => 'sql tuning advisor',
   operation => NULL,
   window_name => NULL);
     END;
    /

如果要启用请执行

BEGIN
       dbms_auto_task_admin.enable(
       client_name => 'sql tuning advisor',
       operation => NULL,
       window_name => NULL);
     END;
     /

Q Q:107644445

Tel:13429648788

个人Blog(惜分飞)

提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)

点击打开链接