ORA-7445 [smboQbNxt] Running SQLTuning Advisor Job

(Doc ID 1567617.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

While running SQLTuning Advisor job, you can get the internal error
     ORA-07445: exception encountered: core dump [smboQbNxt()+103] [SIGSEGV] [ADDR:0x0] [PC:0x8F41497] [Address not mapped to object] []


The failing statement reported in the inciden trace file looks like:

/* SQL Analyze(72,1) */ select DECODE(:b0,'P',iamdate,iamrefd) ,DECODE(:b0,'P',TO_CHAR(iamdate,'DD-MON-YYYY'),TO_CHAR(iamrefd,'DD-MON-YYYY')) ,iamrefno ,DECODE(:b2,'Y',iamforval,iamamt) ,DECODE(:b3,'A',fclaltnote,fclnote) ,iamtype ,NVL(SUBSTR(iamnote,1,26),DECODE(:b3,'A',fclaltnote,fclnote)) ,DECODE(:b0,'P',TO_NUMBER(TO_CHAR(iamdate,'YYYYMMDD')),TO_NUMBER(TO_CHAR(iamrefd,'YYYYMMDD'))) ,IAMCODE ,IAMEVNT ,IAMORIGSEQ ,null from stud.iamlog a ,finc.fcltrn e ,finc.fujacd where (((((((((iamstno=:b6 and iamcode=e.FCLTRN(+)) and NVL(e.fclevnt,'x') not in ('26','36')) and ((NVL(e.fclevnt,'x') in ('TC','TD') and exists (select 1 from stud.iamlog b ,finc.fujacd c ,finc.fcltrn d where (((((((b.iamstno=a.iamstno and b.iamacctyp=c.fujacctyp) and b.iamrefno=a.iamrefno) and b.iamamt=a.iamamt) and nvl(c.fujfee,'F')='D') and ((:b7='N' and nvl(c.fujshowacctyp,'N')='Y') or :b7='Y')) and d.fcltrn=b.iamcode) and NVL(d.fclevnt,'x') in ('TC','TD')))) or NVL(e.fclevnt,'x') not in ('TC','TD'))) and IAMACCTYP=FUJACCTYP) and NVL(fujfee,'F')='F') and ((:b7='N' and NVL(fujshowacctyp,'N')='Y') or :b7='Y')) and NVL(iamshow,'Y')<>'N') and ((:b0='P' and iamdate'N') and ((:b0='P' and iamdate

The Call Stack Trace is:


smboQbNxt ksxb1buf rworofprFastUnpackRow qersoFetch opifch2 kpoal8 opiodr kpoodrc rpiswu2 kpoodr upirtrc kpurcsc kpufch0kpufch OCIStmtFetch2 qksanExecSql qksanAnalyzeSql qksanAnalyzeSegSql kestseDoOneExec

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