Inconsistent Results For Query When _query_execution_time_limit Is Set To A Value Lower Then The Necessary Query Completion Time

(Doc ID 2386482.1)

Last updated on MAY 04, 2018

Applies to:

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

Symptoms

E.q. :

-- _query_execution_time_limit = 0 (default value)

SQL> set timing on
SQL> select count(*) from dba_objects,dba_users;

  COUNT(*)
----------
   4282698

Elapsed: 00:00:01.62  -->  Query completes in 1.62 seconds and returns 4282698 rows

-- _query_execution_time_limit = 1

SQL> select count(*) from dba_objects,dba_users;

  COUNT(*)
----------
   1311629

Elapsed: 00:00:01.13   -->  Due to parameter setting, query is forced to return results in around 1 second

SQL> /

  COUNT(*)
----------
   1400076

Elapsed: 00:00:00.86   -->  Due to parameter setting, query is forced to return results in around 1 second
SQL> /

  COUNT(*)
----------
   1382928          

Elapsed: 00:00:00.85   -->  Due to parameter setting, query is forced to return results in around 1 second

Changes

 Set parameter _query_execution_time_limit  to a lower value then the time needed to finish execution of a query

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