SQL Performance (MOSC)

MOSC Banner

gather stats on tables with stale stats < 10%

edited Jul 12, 2016 4:45PM in SQL Performance (MOSC) 4 commentsAnswered ✓

whenever i have a sql performance issue ..i generally run SQLT xtract and one of areas i see is "Observations".Most of the times SQLT suggests to consider gathering stats on tables using

    estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, 

even though there are no stale statistics on the indexes or tables or the modifications on those tables are less than 5%.

Is it really beneficial by anyways to collect gathering stats in such case?

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