Nishanth

• Aug 17th, 2006

 

For ORACLE to display the amount of time it takes to execute a statement or procedure in the SQL window you need to set some environmental,in this case you have to execute the following statement

SQL> set timing on

after doing this execute a simple satement like

SQL> select sysdate from dual;

You will get the output as follows with the elapsed time below it as follows...

SYSDATE
---------
17-AUG-06

Elapsed: 00:00:00.62