D:\>sqlplus hr/hr

SQL*Plus: Release 10.2.0.1.0 - Production on Cmt Eyl 15 22:47:24 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> set timing on
SQL> set autot on
SQL> drop table t1 purge ;

Table dropped.

Elapsed: 00:00:00.37
SQL> create table t1 nologging as
  2         select text c1,
  3                text c2
  4         from dba_source ;

Table created.

Elapsed: 00:00:05.68
SQL> exec dbms_stats.gather_table_stats(user, 't1') ;

PL/SQL procedure successfully completed.

Elapsed: 00:00:17.01
SQL> select count(c1) from t1 ;

 COUNT(C1)
----------
    154033

Elapsed: 00:00:00.07

Execution Plan
----------------------------------------------------------
Plan hash value: 3724264953

---------------------------------------------------------------------------
| Id  | Operation          | Name | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |      |     1 |   256 |  5104   (1)| 00:01:02 |
|   1 |  SORT AGGREGATE    |      |     1 |   256 |            |          |
|   2 |   TABLE ACCESS FULL| T1   |   154K|    37M|  5104   (1)| 00:01:02 |
---------------------------------------------------------------------------


Statistics
----------------------------------------------------------
          1  recursive calls
          0  db block gets
      18575  consistent gets
          0  physical reads
          0  redo size
        414  bytes sent via SQL*Net to client
        384  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

SQL> select count(c2) from t1 ;

 COUNT(C2)
----------
    154033

Elapsed: 00:00:00.10

Execution Plan
----------------------------------------------------------
Plan hash value: 3724264953

---------------------------------------------------------------------------
| Id  | Operation          | Name | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |      |     1 |   256 |  5105   (1)| 00:01:02 |
|   1 |  SORT AGGREGATE    |      |     1 |   256 |            |          |
|   2 |   TABLE ACCESS FULL| T1   |   154K|    37M|  5105   (1)| 00:01:02 |
---------------------------------------------------------------------------


Statistics
----------------------------------------------------------
          1  recursive calls
          0  db block gets
      26811  consistent gets
          0  physical reads
          0  redo size
        414  bytes sent via SQL*Net to client
        384  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed