飞总:
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的东西
从错误上看和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;
/
dbms_auto_task_admin.enable(
client_name => 'sql tuning advisor',
operation => NULL,
window_name => NULL);
END;
/