ORA-07445 [_IO_vsprintf_internal()+224] from query with large IN-list (Doc ID 563489.1)

Last updated on MAY 22, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 10.2.0.3
This problem can occur on any platform.

Symptoms

A query that has a large IN-list fails with

ORA-07445: exception encountered: core dump [_IO_vsprintf_internal()+224] [SIGSEGV] [unknown code][0x200000000332C000] [] []

Sample query is below

SELECT DISTINCT tab1.col2, tab2.col2
FROM tab1, tab2
WHERE tab1.col1 = tab2.col1
AND (tab1.col3 IN (90264,90265,90266,90267,90268,90269,90270,90271,
...
<snip>
...
90601,90602,90603,90604,90605,90606,90607,90608,90609,90610,90611))

The IN-list in the above failing sql has 34760 values.

Call stack is

ksedst ksedmp ssexhd IO_vsprintf_internal GI_sprintf
kkslrpl kestb_gen_keys kestb_lookup opiSem opiDeferredSem
opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock

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