SQL*Plus "timing" command in SQL Developer

Yes.

This is my script:

       SPOOL 3-t.txt

         SET TIMING ON

EXEC pmsmmi.rpt.rpt_ethncty_race_smry (15);

       SPOOL OFF

And its returns in 3-t.txt:

SQL> SET TIMING ON

SQL> EXEC pmsmmi.rpt.rpt_ethncty_race_smry (15)

PL/SQL procedure successfully completed.

SQL> SPOOL OFF

• As you can see, there is no timing info in the script output log.

• I then searched the discussion forum, found it can be enabled in "Tool> Preference> Database > Start up script" and set the startup script as:

   set serveroutput on 

   set timing on

• However, 2 issues found:

1. the timing it returned is NOT the elapsed time of my stored procedure run. It just pick any 2 points of time and its elapsed time, not the point Before and After SP run. Therefore, set timing on is not a solution to me.
2. it did not follow the instructions in startup script. After I set timing off in startup script, shutdown & restart SQL Developer, even reboot laptop, timing still on. The only way to turn it off now is by configure NOT to use

       any startup script.

• I then developed my own solution by coding as:

       SPOOL 3-t.txt

         VAR bv_start_ts VARCHAR2 (30)

         VAR bv_end_ts   VARCHAR2 (30)

         VAR bv_elps_ts  VARCHAR2 (30)

       DECLARE

          v_start_ts VARCHAR2 (30);

       BEGIN

          SELECT TO_CHAR (SYSTIMESTAMP, 'yyyymmddfxDyhh24miss.ff6') INTO v_start_ts FROM DUAL;

          :bv_start_ts := v_start_ts;

       END;

       /

       PRINT bv_start_ts

EXEC pmsmmi.rpt.rpt_ethncty_race_smry (15);

       DECLARE 

          v_end_ts   VARCHAR2 (30);

       BEGIN

          SELECT TO_CHAR (SYSTIMESTAMP, 'yyyymmddfxDyhh24miss.ff6') INTO v_end_ts FROM DUAL;

          :bv_end_ts := v_end_ts;

       END;

       /

       PRINT bv_end_ts

       EXEC :bv_elps_ts := TO_CHAR (TO_TIMESTAMP (:bv_end_ts, 'yyyymmddfxDyhh24miss.ff6') - TO_TIMESTAMP (:bv_start_ts, 'yyyymmddfxDyhh24miss.ff6'), 'hh:mi:ss.ff6');

       PRINT bv_elps_ts

       SPOOL OFF

• Then I got what I want, the answer is in the "PRINT bv_elps_ts":

SQL> VAR bv_start_ts VARCHAR2 (30)

SQL> VAR bv_end_ts   VARCHAR2 (30)

SQL> VAR bv_elps_ts  VARCHAR2 (30)

SQL> DECLARE

          v_start_ts VARCHAR2 (30);

       BEGIN

          SELECT TO_CHAR (SYSTIMESTAMP, 'yyyymmddfxDyhh24miss.ff6') INTO v_start_ts FROM DUAL;

          :bv_start_ts := v_start_ts;

       END;

/

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.031

SQL> PRINT bv_start_ts

BV_START_TS

-----------

20150702Thu112617.775545

SQL> EXEC pmsmmi.rpt.rpt_ethncty_race_smry (15)

PL/SQL procedure successfully completed.

SQL> DECLARE 

          v_end_ts   VARCHAR2 (30);

       BEGIN

          SELECT TO_CHAR (SYSTIMESTAMP, 'yyyymmddfxDyhh24miss.ff6') INTO v_end_ts FROM DUAL;

          :bv_end_ts := v_end_ts;

       END;

/

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.062

SQL> PRINT bv_end_ts

BV_END_TS

---------

20150702Thu112630.805786

SQL> EXEC :bv_elps_ts := TO_CHAR (TO_TIMESTAMP (:bv_end_ts, 'yyyymmddfxDyhh24miss.ff6') - TO_TIMESTAMP (:bv_start_ts, 'yyyymmddfxDyhh24miss.ff6'), 'hh:mi:ss.ff6')

PL/SQL procedure successfully completed.

SQL> PRINT bv_elps_ts

BV_ELPS_TS

----------

+000000 00:00:13.030241000

SQL> SPOOL OFF