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: to
This problem can occur on any platform.


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,

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


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