MYDBA@ORCL > create table test(a number, b char(100));

Table created.

MYDBA@ORCL > insert into test select rownum, 'x' from all_objects where rownum <= 10000;

10000 rows created.

MYDBA@ORCL > explain plan for select * from test where a = :1;

Explained.

MYDBA@ORCL > select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------------------

Plan hash value: 1357081020

--------------------------------------------------------------------------
| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |      |   117 | 13455 |     2   (0)| 00:00:01 |
|*  1 |  TABLE ACCESS FULL| TEST |   117 | 13455 |     2   (0)| 00:00:01 |
--------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter("A"=TO_NUMBER(:1))

Note
-----
   - dynamic sampling used for this statement

17 rows selected.

MYDBA@ORCL >