Database Administration (MOSC)

MOSC Banner

Optimizer Gather Stats on Load

edited Aug 8, 2020 5:00AM in Database Administration (MOSC) 6 commentsAnswered

As per below oracle document from 12c when we do CTAS or IAS it should collect the statistics.

Online Statistics Gathering for Bulk Loads (Doc ID 2019634.1)

We have Oracle EXADATA 12.2.0.1 (April2020 CPU). When i do the explain plan for ctas it does not show the optimizer gather statistics. Please see below. Also after CTAS it did not gather the stats and NUM_ROWS is empty.

I can see _OPTIMIZER_GATHER_STATS_ON_LOAD is already set to True

explain plan for create table psoprdefn_test as select * from psoprdefn

select * from table(DBMS_XPLAN.DISPLAY);

Plan hash value: 342619065

---------------------------------------------------------------------------------------------

| Id  | Operation                  | Name           | Rows  | Bytes | Cost (%CPU)| Time     |

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center