SQL Performance (MOSC)

MOSC Banner

Why is GATHER STATS AUTO_SAMPLE_SIZE always 100% (Compute) in 12c

edited Mar 18, 2016 5:04AM in SQL Performance (MOSC) 3 commentsAnswered

Hello at all,

we have a strange phenomenon in our databases.

The statistic collection of our tables starts usually in the automatic maintenance windows.

We use the default with auto_sample_size:

ESTIMATE_PERCENT    DBMS_STATS.AUTO_SAMPLE_SIZE

SInce we graded up our databases to 12c from 11gr2 we realized that we need much more time for gathering table stats for our tables.

In the past we never need more than about 2h for our biggest tables.

Since 12c we need for the same tables about 8h.

We saw the auto sample size in dba_tables was the same like the num_rows. So we guess the sample auto uses 100% (compute statistics) to analyze our tables.

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