RE: _query_execution_time_limit

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_at_psbank.ru] Sent: Monday, June 15, 2015 8:45 AM
To: Leroy Kemnitz
Cc: Oracle-l Digest Users; oracle-l-bounce_at_freelists.org Subject: Re: _query_execution_time_limit

Very interesting parameter. I see it on 12.1.0.2 only:

SQL> _at_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(*)

Elapsed: 00:00:06.35

--

Best regards,
Sayan Malakshinov
http://orasql.org<http://orasql.org/>

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jun 15 2015 - 15:48:12 CEST