odd behavior of gather stats
This is a 11.2.0.3 Rac database with two nodes on Linux 5.2
There is something odd happening with the stats job on database. In the AWR, I can see the PL/SQL call to dbms_stats taking 12s:
Buffer Gets Elapsed
Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id
----------- ----------- ------------ ------ ---------- ----- ----- -------------
192,838 1 192,838.0 0.3 11.4 18.4 .6 gu839f0pwb5pc
Module: DBMS_SCHEDULER
begin dbms_stats.gather_table_stats(ownname=>'PCO',tabname=>'CLOCKRESULTS',partn
ame=>'SYS_P2824',estimate_percent=>30,degree=> 16,granularity=>'APPROX_GLOBAL AN
D PARTITION', cascade=>true); end;
But something is causing dbms_stats to scan the whole table:
There is something odd happening with the stats job on database. In the AWR, I can see the PL/SQL call to dbms_stats taking 12s:
Buffer Gets Elapsed
Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id
----------- ----------- ------------ ------ ---------- ----- ----- -------------
192,838 1 192,838.0 0.3 11.4 18.4 .6 gu839f0pwb5pc
Module: DBMS_SCHEDULER
begin dbms_stats.gather_table_stats(ownname=>'PCO',tabname=>'CLOCKRESULTS',partn
ame=>'SYS_P2824',estimate_percent=>30,degree=> 16,granularity=>'APPROX_GLOBAL AN
D PARTITION', cascade=>true); end;
But something is causing dbms_stats to scan the whole table:
0