Two Ways to Get the Execution Time of an SQL Statement in oracle

If you need to get the execution time of one SQL statement in oracle, you can use the following two ways

 
SQL> set timing on; 
SQL> select count(*) from wea; 

COUNT(*) 
---------- 
39490 

 Elapsed time : 00: 00: 00.06 
SQL> select sql_text, elapsed_time from v$sql 
2 where sql_text like 'select count(*) from wea'; 

 No rows selected  

 Elapsed time : 00: 00: 00.25