dbms_stats block_sample 11.2 ->12.1
From: Petr Novak <Petr.Novak_at_trivadis.com>
Date: Thu, 9 Mar 2017 08:57:14 +0000
Message-ID: <AM3PR05MB4672D6BCAD09B4FD4AB4F8DF3210_at_AM3PR05MB467.eurprd05.prod.outlook.com>
Date: Thu, 9 Mar 2017 08:57:14 +0000
Message-ID: <AM3PR05MB4672D6BCAD09B4FD4AB4F8DF3210_at_AM3PR05MB467.eurprd05.prod.outlook.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 09 2017 - 09:57:14 CET