Error ORA-07445 Qsmmixcomputeclusteringfactor From SQL Tuning (Doc ID 1359148.1)

Last updated on MARCH 11, 2015

Applies to:

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

Symptoms

When SQL Tuning a query undergoing OR expansion can suffer a dump
under qsmmixComputeClusteringFactor, or get other unpredictable results.

Failing SQL could be like:

/* SQL Analyze(972,1) */ SELECT /*+ rule */ D.PRGR_UPSELLING_RETAIL, D.CODE_ORDINE_UPSELLING, A.CODE_COMPENSO, D.CODE_TIPO_TECNOLOGIA, D.DATA_VENDITA, B.ID_EVENTO, A.CODE_ACCOUNT, D.CODE_CLUSTER_RETAIL, F.DESC_TIPO_TECNOLOGIA, G.DESC_CLUSTER_RETAIL FROM VISP_COMPENSI A, VISP_COMPENSO_DETT B, VISP_CAUSALI C, VISP_UPSELLING_RETAIL D, VISP_EVENTI E, VISP_TIPI_TECNOLOGIA F, VISP_CLUSTER_RETAIL G WHERE D.CODE_ORDINE_UPSELLING = NVL(:B3 , D.CODE_ORDINE_UPSELLING) AND D.CODE_STATO_RETAIL = NVL(:B2 ,D.CODE_STATO_RETAIL) AND A.CODE_COMPENSO = B.CODE_COMPENSO AND A.ID_CAUSALE = C.ID_CAUSALE AND A.CODE_CONTRATTO = TO_CHAR(D.PRGR_UPSELLING_RETAIL) AND A.ACCOUNT_PROG = D.CODE_ORDINE_UPSELLING AND C.ID_PROCEDURA = :B1 AND B.ID_STATO_MOVIMENTO = 43 AND B.ID_EVENTO = E.ID_EVENTO AND E.DESC_EVENTO LIKE '%ATTIVAZIONE%' AND D.CODE_TIPO_TECNOLOGIA = F.CODE_TIPO_TECNOLOGIA AND D.DATA_VENDITA BETWEEN F.DATA_INIZIO_TIPO_TECNOLOGIA AND F.DATA_FINE_TIPO_TECNOLOGIA AND D.CODE_CLUSTER_RETAIL = G.CODE_CLUSTER_RETAIL

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x54ba3f200 11816 package body SYS.DBMS_SQLTUNE_INTERNAL
0x553418948 7 SYS.WRI$_ADV_SQLTUNE
0x54ba735c8 587 package body SYS.PRVT_ADVISOR
0x54ba735c8 2655 package body SYS.PRVT_ADVISOR


STACK:

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp<- ssexhd <- sighandler <- qsmmixComputeClusteringFactor <- qsmmixGenFakeIdxStats <- qsmmixPopulateIdxStats <- qsmmixSetKkotbixtqsmmixReturnCandToOpt<qsmmixOptimizerGenIdxCand <- qsmmixOptimizerSetupIdxCandResponse

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