Database DataWarehousing (MOSC)

MOSC Banner

After HCC Compression (Query Low). The first stats gather is taking too long. Is that expected?

edited Sep 22, 2020 11:02PM in Database DataWarehousing (MOSC) 7 commentsAnswered

Engineered Systems : Exadata

Database version: 12.1.0.2

Table size: 1TB (Before Compression) , 150GB (After Compression)

No's of Indexes: 4

First time Stats gather after Compression: 15 hrs

Stats query:

BEGIN

  DBMS_STATS.GATHER_TABLE_STATS

   (ownname => '<SCHEMA>',

    tabname => '<TABLE_NAME>',

    cascade => TRUE,

    estimate_percent => 100,                    <<< Tried with Auto on another table with same size, that is also took 12+ hrs.

    method_opt => 'FOR ALL INDEXED COLUMNS SIZE AUTO',

    degree => 72);

END;

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