SQL> set timing on
SQL> create table test as select * from all_objects
  2  where object_id=100;

Table created.

Elapsed: 00:00:01.37 <<--
SQL> select * from test;

OWNER                          OBJECT_NAME
------------------------------ ------------------------------
SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S
--------- --------- ------------------- ------- - - -
SYS                            I_TYPED_VIEW1
                                      100            100 INDEX
31-JAN-08 31-JAN-08 2008-01-31:17:18:24 VALID   N N N


Elapsed: 00:00:00.09 <<--
SQL>

SQL>select sql_id, elapsed_time from v$sql
where sql_id like '5%'
/
SQL_ID        ELAPSED_TIME
------------- ------------
5j35wpppf003m         6386
5rh0tbv3d80bh       574401
5f4fxcnw8h15g        17190
5rgfh8a8bc1n1        28775
5mpk55t8bw1y7       487774
5apa5r99y027p       593894
5dgt7zg1bc2ur         7769