conn sa/sa@10_2_0_5
spool c:\000\scrout10g_fts.txt
@spid

set pagesize 999
set linesize 200
col PLAN_TABLE_OUTPUT for a100

alter session set sql_trace=true;

set timing on

-- cache data
select count(pad)
  from test;

-- we start here
-- default _rowsource_statistics_sampfreq
select count(pad)
  from test;

select * from table(dbms_xplan.display_cursor(null, null, 'allstats last'));

alter session set "_rowsource_statistics_sampfreq"=0;

select count(pad)
  from test;

select * from table(dbms_xplan.display_cursor(null, null, 'allstats last'));


alter session set "_rowsource_statistics_sampfreq"=128;

select count(pad)
  from test;

select * from table(dbms_xplan.display_cursor(null, null, 'allstats last'));

alter session set "_rowsource_statistics_sampfreq"=16;

select count(pad)
  from test;

select * from table(dbms_xplan.display_cursor(null, null, 'allstats last'));

alter session set "_rowsource_statistics_sampfreq"=8;

select count(pad)
  from test;

select * from table(dbms_xplan.display_cursor(null, null, 'allstats last'));

alter session set "_rowsource_statistics_sampfreq"=4;

select count(pad)
  from test;

select * from table(dbms_xplan.display_cursor(null, null, 'allstats last'));

alter session set "_rowsource_statistics_sampfreq"=2;

select count(pad)
  from test;

select * from table(dbms_xplan.display_cursor(null, null, 'allstats last'));

alter session set "_rowsource_statistics_sampfreq"=1;

select count(pad)
  from test;

select * from table(dbms_xplan.display_cursor(null, null, 'allstats last'));

spool off