SQL Performance (MOSC)

MOSC Banner

How do I remove a table's statistics preferences?

edited Feb 19, 2016 4:00AM in SQL Performance (MOSC) 1 commentAnswered

Hi,

We had estimate_percent set at 30% for some very large tables where the sample_size was way too small (below 1%).

However, we are currently migrating to 12c and tested a schema migration recently. We found out that the stats table preferences had migrated too.

DBMS_STATS.GET_PREFS('ESTIMATE_PERCENT','<SCHEMA>','<TEST_TABLE>')                

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

  30.000000                                                                   

1 row selected.

How do I remove this completely?

Note that DBMS_STATS.RESET_GLOBAL_PREF_DEFAULTS; only impact global settings and doesn't change the tables or schema settings.

Thank you

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