Hallo,
I made test with 2 tables about 700M in 11.2.0.4 and 12.1.0.2
dbms_stats.gather_table_stats(,,estimate_percent=>1, block_sample=>false) used
on both DBs 'direct path read'
dbms_stats.gather_table_stats(,,estimate_percent=>1, block_sample=>true) used
on 11.2 'db file sequential read' , on 12.1 mix of 'direct path read' and 'db
file sequential read'.
It is just pure coincidence or known change of implemention ?
Best Regards,
Petr
--
//www.freelists.org/webpage/oracle-l