SET TIMING in SQL* Plus

SET TIMING in SQL* Plus   ( Watch the Video Version )

SET TIMING: Controls the Display of elapsed time of SQL Statement or PL/SQL Block.

Syntax: SET TIMING {ON | OFF}

ON - Displays the Elapsed time after each SQL command or PL/SQL Block Execution. 

          It does not show the elapsed time for SQL*Plus commands (such as any SET commands).
OFF - Disables the display of Elapsed time. OFF is the Default.

Example:

SQL>

SQL> select * from dual;

D

-

X

SQL> set timing ON

SQL> select * from dual;

D

-

X

Elapsed: 00:00:00.00

SQL>

=======================================================================

 ** Email to info@shreyantech.com to get the Tip of the Day in your mailbox.