Re: _query_execution_time_limit

From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Mon, 15 Jun 2015 16:44:37 +0300
Message-ID: <OF2214854B.24A0BE80-ON43257E65.004AA152-43257E65.004B7F29_at_psbank.ru>

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://www.freelists.org/webpage/oracle-l Received on Mon Jun 15 2015 - 15:44:37 CEST