set echo on
set autotrace traceonly
spool run_flip.log
exec dbms_stats.gather_table_stats(ownname=>user, tabname=>'t_inc2', method_opt=>'for all columns size 254', cascade => true);
select * from t_inc2 a, t_inc2 b where a.x = 5 and a.x = b.x;
exec dbms_stats.gather_table_stats(ownname=>user, tabname=>'t_inc2', method_opt=>'for all columns size 254', cascade => true);
select * from t_inc2 a, t_inc2 b where a.x = 5 and a.x = b.x;
exec dbms_stats.gather_table_stats(ownname=>user, tabname=>'t_inc2', method_opt=>'for all columns size 254', cascade => true);
select * from t_inc2 a, t_inc2 b where a.x = 5 and a.x = b.x;
exec dbms_stats.gather_table_stats(ownname=>user, tabname=>'t_inc2', method_opt=>'for all columns size 254', cascade => true);
select * from t_inc2 a, t_inc2 b where a.x = 5 and a.x = b.x;
exec dbms_stats.gather_table_stats(ownname=>user, tabname=>'t_inc2', method_opt=>'for all columns size 254', cascade => true);
select * from t_inc2 a, t_inc2 b where a.x = 5 and a.x = b.x;
exec dbms_stats.gather_table_stats(ownname=>user, tabname=>'t_inc2', method_opt=>'for all columns size 254', cascade => true);
select * from t_inc2 a, t_inc2 b where a.x = 5 and a.x = b.x;
exec dbms_stats.gather_table_stats(ownname=>user, tabname=>'t_inc2', method_opt=>'for all columns size 254', cascade => true);
select * from t_inc2 a, t_inc2 b where a.x = 5 and a.x = b.x;
exec dbms_stats.gather_table_stats(ownname=>user, tabname=>'t_inc2', method_opt=>'for all columns size 254', cascade => true);
select * from t_inc2 a, t_inc2 b where a.x = 5 and a.x = b.x;
exec dbms_stats.gather_table_stats(ownname=>user, tabname=>'t_inc2', method_opt=>'for all columns size 254', cascade => true);
select * from t_inc2 a, t_inc2 b where a.x = 5 and a.x = b.x;
exec dbms_stats.gather_table_stats(ownname=>user, tabname=>'t_inc2', method_opt=>'for all columns size 254', cascade => true);
select * from t_inc2 a, t_inc2 b where a.x = 5 and a.x = b.x;
spool off
quit