SQL Performance (MOSC)

MOSC Banner

Stale index statistics but not analyzed

edited Mar 24, 2015 12:48PM in SQL Performance (MOSC) 16 commentsAnswered

Hello guys.

We have Oracle 10g where it's supposed the statistics are collected automatically. Probably this question has been discussed previously.

Some times we have performance problems and the other day I got a query which I analysed with the SQL Tunning Advisor. It said to optimizer statistics for some indexes because they are stale. Then I check it and the last analysed where on 2013, I also check the statistics status and the indexes are market as stale.

select index_name,last_analyzed, stale_stats

from dba_ind_statistics

where index_name = 'FRJ901';

INDEX_NAME                 LAST_ANALYZED STALE_STATS

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