ORA-7445 [msqcol] with Redaction Rules (Doc ID 1662219.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

The following error is encountered in the alert log and trace file:

ORA-07445: exception encountered: core dump [msqcol()+754] [SIGSEGV] [ADDR:0x10] [PC:0x201AE46] [Address not mapped to object] []


The trace file shows that the process is executing the following SQL:

----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10] [PC:0x20472CE, msqcol()+754] [flags: 0x0, count: 1]
Registers:
%rax: 0x00007ff29ade6160 %rbx: 0x00007ff29ac21db8 %rcx: 0x0000000000000004
%rdx: 0x00007ff29b17e4c0 %rdi: 0x00007ff29b0253c6 %rsi: 0x00007ff29b1da458
%rsp: 0x00007fff70cc25a0 %rbp: 0x00007fff70cc2600 %r8: 0x0000000000000001
%r9: 0x0000000031305f2e %r10: 0x0000000000000b33 %r11: 0x00000000047edc2f
%r12: 0x0000000000000000 %r13: 0x00007fff70cc2d00 %r14: 0x00007ff29b1ba440
%r15: 0x000000000000001e %rip: 0x00000000020472ce %efl: 0x0000000000010246
msqcol()+741 (0x20472c1) mov (%r12),%r12
msqcol()+745 (0x20472c5) add $1,%r15d
msqcol()+749 (0x20472c9) test %r12,%r12
msqcol()+752 (0x20472cc) jne 0x20472ba
> msqcol()+754 (0x20472ce) mov 0x10(%r12),%rcx
msqcol()+759 (0x20472d3) test %rcx,%rcx
msqcol()+762 (0x20472d6) je 0x20472e1
msqcol()+764 (0x20472d8) cmp $0x2710,%r15d
msqcol()+771 (0x20472df) jl 0x2047302

----- Current SQL Statement for this session -----

/* SQL Analyze(653,1) */ SELECT..

----- PL/SQL Stack -----

----- PL/SQL Call Stack -----
object line object
handle number name
0xc2e4f7e0 11816 package body SYS.DBMS_SQLTUNE_INTERNAL
0xbe3ddc78 7 SYS.WRI$_ADV_SQLTUNE
0xdd80bdb0 587 package body SYS.PRVT_ADVISOR
0xdd80bdb0 2655 package body SYS.PRVT_ADVISOR
0xde4c8808 241 package body SYS.DBMS_ADVISOR
0xbe42a300 821 package body SYS.DBMS_SQLTUNE
0xbe622760 4 anonymous block


The 'Call Stack' section of the trace file includes functions like:

... msqcol  msqopnws  msqsellst  msqsel  kkzgctdrv  kkzgctcb  kkzpcbk  opikkzprs1 ...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms