Query Fails with ORA-7445[kkoosoel] (Doc ID 2549114.1)

Last updated on MAY 01, 2020

Applies to:

Symptoms

• Query fails with ORA-7445[kkoosoel] when using COUNT function and ORDER BY clause
• The following is an example testcase:
  TEST CASE:
  CREATE TABLE t1 (c1 VARCHAR2(5));
  CREATE INDEX t1_idx1 ON t1 (c1);

  SELECT count(*) FROM t1
  WHERE c1 BETWEEN 'AAA01' AND 'AAA03' OR c1 BETWEEN 'AAA05' AND 'AAA07'
  ORDER BY c1;

  [Terminal error message]
  SQL> SELECT count(*) FROM t1
  2 WHERE c1 BETWEEN 'AAA01' AND 'AAA03' OR c1 BETWEEN 'AAA05' AND 'AAA07'
  3 ORDER BY c1;
  WHERE c1 BETWEEN 'AAA01' AND 'AAA03' OR c1 BETWEEN 'AAA05' AND 'AAA07'
  *
  ERROR at line 2:
  ORA-03113: end-of-file on communication channel
  Process ID: 90597
  Session ID: 22 Serial number: 31691

    
  
  

Changes

Cause

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