conn sa/sa@11_2_0_3sol64
spool c:\000\scrout11g_fts.txt
@spid

set linesize 200
set pagesize 999
col PLAN_TABLE_OUTPUT for a100

--alter session set sql_trace;

alter session set "_serial_direct_read"=never;
alter session set events 'sql_trace[sql:5ymq7bbd9da47]';

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