Skip to content

Instantly share code, notes, and snippets.

@xtender
Last active August 29, 2015 14:23
Show Gist options
  • Select an option

  • Save xtender/b76e0b68469454a4e9cc to your computer and use it in GitHub Desktop.

Select an option

Save xtender/b76e0b68469454a4e9cc to your computer and use it in GitHub Desktop.
Funny timing
set echo on time on timing on;
alter session set "_query_execution_time_limit"=10;
select count(*),systimestamp from xmltable('1 to 10000000');
/
/
set echo on time off timing off;
SQL> set echo on time on timing on;
22:34:10 SQL> alter session set "_query_execution_time_limit"=10;
Elapsed: 00:00:00.05
22:34:10 SQL> select count(*),systimestamp from xmltable('1 to 10000000');
2160549 2015-06-15 23:42:23.479328 +04:00
Elapsed: 00:00:05.37
22:34:15 SQL> /
2153258 2015-06-15 23:42:28.650549 +04:00
Elapsed: 00:00:05.11
22:34:20 SQL> /
2181076 2015-06-15 23:42:33.750163 +04:00
Elapsed: 00:00:05.09
22:34:26 SQL> set echo on time off timing off;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment