Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

4.2 EA2 SQL Developer - SET TIMING ON - ISSUE

Sanal Krishnan NarayananMar 24 2017 — edited Mar 27 2017

Hello,

I was running the below script in Sql Developer and noticed that the "Elapsed" timing on the "Script Output" tab seems to be cumulative.

create or replace procedure proc1

as

begin

for i in 1 .. 10000

loop

execute immediate

'insert into t values ( :y )' using i;

end loop;

end;

create or replace procedure proc2

as

begin

for i in 1 .. 10000

loop

execute immediate

'insert into t values ( ' || i || ' )' ;

end loop;

end;

set serverout on size 100000

set time on

set timing on

exec proc1

exec proc2

(PS: I selected the above and kept hitting F5 multiple times)

----------------------------------------------------

Procedure PROC1 compiled

Procedure PROC2 compiled

PL/SQL procedure successfully completed.

Elapsed: 00:00:40.977

PL/SQL procedure successfully completed.

Elapsed: 00:00:45.865

PL/SQL procedure successfully completed.

Elapsed: 00:01:13.801

PL/SQL procedure successfully completed.

Elapsed: 00:01:19.177

PL/SQL procedure successfully completed.

Elapsed: 00:01:28.975

PL/SQL procedure successfully completed.

Elapsed: 00:01:38.759

PL/SQL procedure successfully completed.

Elapsed: 00:01:42.291

PL/SQL procedure successfully completed.

Elapsed: 00:01:44.096

PL/SQL procedure successfully completed.

Elapsed: 00:01:45.504

PL/SQL procedure successfully completed.

Elapsed: 00:01:47.110

PL/SQL procedure successfully completed.

Elapsed: 00:01:48.768

PL/SQL procedure successfully completed.

Elapsed: 00:01:50.453

PL/SQL procedure successfully completed.

Elapsed: 00:02:00.200

I wrote this post and hit F5 again :

Elapsed: 00:13:15.482

PL/SQL procedure successfully completed.

Elapsed: 00:13:22.987

This post has been answered by Gary Graham-Oracle on Mar 24 2017
Jump to Answer

Comments

Gary Graham-Oracle
Answer

This has been fixed for the 4.2 production release.

Marked as Answer by Sanal Krishnan Narayanan · Sep 27 2020

Thanks Gary,  When will it be released ?

thatJeffSmith-Oracle

When it's ready

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 24 2017
Added on Mar 24 2017
3 comments
551 views