set autotrace on;
set timing on;
select count(*) from table;
  COUNT(*)
----------
 164078859

Elapsed: 00:01:02.02

Execution Plan
----------------------------------------------------------
Plan hash value: 2319838783

-----------------------------------------------------------------------------
| Id  | Operation	      | Name	    | Rows  | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------
|   0 | SELECT STATEMENT      | 	    |	  1 | 87965   (2)| 00:17:36 |
|   1 |  SORT AGGREGATE       | 	    |	  1 |		 |	    |
|   2 |   INDEX FAST FULL SCAN| PRICE_IDX18 |	152M| 87965   (2)| 00:17:36 |
-----------------------------------------------------------------------------


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