Get time elapsed of an SQL query

In SQL plus, use:

SQL> set timing on;