RE: _query_execution_time_limit
Date: Mon, 15 Jun 2015 14:30:40 +0000
Message-ID: <BN3PR0701MB16372A5DE8952004543D79D4B6B80_at_BN3PR0701MB1637.namprd07.prod.outlook.com>
Daniel,
Thanks for pointing that out! I missed that. A few other people also mentioned it. Thank you.
I think I might be passed this error now – I bounced the database. I applied patches over the weekend and missed the final bounce.
Weird that this parameter isn’t mentioned anywhere in OTN. It is not even listed in the view of hidden parameters. Obviously, I am not perfect – so maybe it is listed and I didn’t see it. Will be double-checking.
Thanks for all the help.
LeRoy
From: Daniel Westermann [mailto:daniel.westermann_at_dbi-services.com]
Sent: Monday, June 15, 2015 9:25 AM
To: Leroy Kemnitz
Cc: Oracle-l Digest Users; oracle-l-bounce_at_freelists.org; Sayan Sergeevich Malakshinov
Subject: Re: _query_execution_time_limit
did you try to set it less? e.g. 1886419561 ? These numbers are somehow flipped, the left number is higher than the right number
Cheers,
Daniel
From: "Leroy Kemnitz" <lkemnitz_at_uwsa.edu<mailto:lkemnitz_at_uwsa.edu>> To: "Sayan Sergeevich Malakshinov" <malakshinovss_at_psbank.ru<mailto:malakshinovss_at_psbank.ru>> Cc: "Oracle-l Digest Users" <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>, oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> Sent: Monday, June 15, 2015 3:48:12 PM
Subject: RE: _query_execution_time_limit 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_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<mailto: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(*)
10000000
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 - 16:30:40 CEST