timed_statistics                     boolean     TRUE
statistics_level                     string      TYPICAL

create table t1 as select 1 x, level y from dual connect by level <= 10;

create table t2 (x int primary key, z int );

insert into t2 values ( 1, 0 );

exec dbms_stats.set_table_stats( user, 'T1', numrows => 1000000, numblks => 10000 );

exec dbms_stats.set_table_stats( user, 'T2', numrows => 1000000, numblks => 10000 );

select /*+ first_rows(10) */ *  from t1, t2   where t1.x = t2.x;

select /*+ first_rows(10) */ *
      from t1, t2
     where t1.x = t2.x

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.02          0          9          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        2      0.00       0.00          1         16          0          10
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        4      0.00       0.02          1         25          0          10

Misses in library cache during parse: 1
Optimizer mode: FIRST_ROWS
Parsing user id: 5

Rows     Row Source Operation
-------  ---------------------------------------------------
     10  NESTED LOOPS  (cr=16 pr=1 pw=0 time=200 us)
     10   TABLE ACCESS FULL T1 (cr=4 pr=1 pw=0 time=193 us)
     10   TABLE ACCESS BY INDEX ROWID T2 (cr=12 pr=0 pw=0 time=153 us)
     10    INDEX UNIQUE SCAN SYS_C0096225 (cr=2 pr=0 pw=0 time=80 us)(object id 4669518)


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                       2        0.00          0.00
  db file sequential read                         1        0.00          0.00
  SQL*Net message from client                     2        9.31          9.31
********************************************************************************