Query Fails With ORA-7445 [_intel_fast_memcmp()+30] on 18C (Doc ID 2663131.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• The select statement below fails with ORA-07445:  [_intel_fast_memcmp()+30] [SIGSEGV]
  SELECT
  *
  FROM
  (
  SELECT
  a.*,
  ROWNUM rnum
  FROM
  (
  SELECT
  *
  FROM
  <TABLENAME>
  WHERE
  ( ( <COL1> IN (441, 1201, 7, 421, 101 ,1501, 781, 1421, 2, 801, 1661, 1481, 1 ) )
  )
  ) a
  WHERE
  ROWNUM <= 100
  );
  
  sslssSynchHdlr sslsshandler _intel_fast_memcmp evadcdrset qesvwrsEvalRowVector qervwRelease
  qecrlssub opifch2 opifch opiodr
   

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.