SQL> set autotrace on explain
SQL> select sysdate from dual;

SYSDATE
-------------------
2011-07-21 07:20:25


Execution Plan
----------------------------------------------------------
Plan hash value: 1388734953

-----------------------------------------------------------------
| Id  | Operation	 | Name | Rows	| Cost (%CPU)| Time	|
-----------------------------------------------------------------
|   0 | SELECT STATEMENT |	|     1 |     2   (0)| 00:00:01 |
|   1 |  FAST DUAL	 |	|     1 |     2   (0)| 00:00:01 |
-----------------------------------------------------------------

SQL> 

********************************************************************************

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      0      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        0      0.00       0.00          0          0          0           0

Misses in library cache during parse: 0

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  db file scattered read                        133        0.37          4.21
  db file sequential read                         1        0.00          0.00


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse     3110      0.04       0.11          1          2         20           0
Execute   3110    872.93    1444.55    1984225   43191547      22326           0
Fetch     2491      0.98       1.27         15     182635          0        2491
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     8711    873.96    1445.94    1984241   43374184      22346        2491

Misses in library cache during parse: 6
Misses in library cache during execute: 6

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  db file scattered read                      26132        0.56        511.40
  db file sequential read                     11411        0.36         60.29
  latch free                                      1        0.00          0.00
  latch: cache buffers chains                    19        0.00          0.00

  619  user  SQL statements in session.
 2491  internal SQL statements in session.
 3110  SQL statements in session.
********************************************************************************
Trace file: pismnwrk_ora_4664.trc
Trace file compatibility: 11.1.0.7
Sort options: default

       1  session in tracefile.
     619  user  SQL statements in trace file.
    2491  internal SQL statements in trace file.
    3110  SQL statements in trace file.
       6  unique SQL statements in trace file.
   80053  lines in trace file.
 2097469  elapsed seconds in trace file.