ORA-07445 core dump [] [SIGBUS] Error When Attempting To Run Dbms_frequent_itemset (Doc ID 728908.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Getting the following error while running a query

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [] [SIGBUS] [unknown code] [0x000000038] [] []
Current SQL statement for this session:
SELECT
bt.setid, bt.support trans_count, nt.*
FROM
(SELECT cast(Itemset as FI_VARCHAR_NT) itemset, rownum setid, support, length
FROM table(
DBMS_FREQUENT_ITEMSET.FI_TRANSACTIONAL(
CURSOR(select trans_nbr, sku_id from sales_fact where wh_id =9 and part_date = 2006 and
da_id = 7293),
0.0001,
2,
3,
NULL, NULL))) bt,
table(bt.itemset) nt
order by trans_count desc

With call stack similar to

kkqsMMVCopyQbcWithFlags <- kkqsMMVCopyQbcWithNoWhere <- kkqsProcessRegion <- kkqsInitialRegionEligibilityCk <- kkqsAddCMapsRegion <- kkqsInstantiateRegions <- kkqsInstantiateRegionManager <- kkqsBldRegMgr <- kkqsGetContainsQryDisjunctRegMgr <- kkqsPickBestMMVPlan <- kkqsMMVGeneralContD <- kkqsMultiMVContDrv <- kkqsedrv <- kkqseqb <- kkqsrqb <- kkqsrmav <- ..........

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