Yes, very strange.
My error tells me that the value needs to be between 1886419563 and 1433628233
values. I attempt to set it to 1886419565, and get the same error.
--------------------
SQL> alter system set "_query_execution_time_limit"=1886419565 scope=both;
alter system set "_query_execution_time_limit"=1886419565 scope=both
*
ERROR at line 1:
ORA-00068: invalid value 1886419565 for parameter _query_execution_time_limit,
must be between 1886419563 and 1433628233
---------------------
LeRoy
From: Sayan Sergeevich Malakshinov [mailto:malakshinovss@xxxxxxxxx]
Sent: Monday, June 15, 2015 8:45 AM
To: Leroy Kemnitz
Cc: Oracle-l Digest Users; oracle-l-bounce@xxxxxxxxxxxxx
Subject: Re: _query_execution_time_limit
Very interesting parameter. I see it on 12.1.0.2 only:
SQL> @param_ _query_execution_time_limit
NAME VALUE DEFLT TYPE
DESCRIPTION
---------------------------------------- ------------ ------------ ------------
------------------------------------------------------------
_query_execution_time_limit 0 TRUE number
Query execution time limit in seconds
SQL> alter session set "_query_execution_time_limit" = 10;
Session altered.
Elapsed: 00:00:00.01
SQL> select count(*) from xmltable('1 to 10000000');
COUNT(*)
----------
2145142
Elapsed: 00:00:05.21
SQL> alter session set "_query_execution_time_limit" = 0;
Session altered.
Elapsed: 00:00:00.00
SQL> select count(*) from xmltable('1 to 10000000');
COUNT(*)
----------
10000000
Elapsed: 00:00:06.35
--
Best regards,
Sayan Malakshinov
http://orasql.org<http://orasql.org/>