Database Administration (MOSC)

MOSC Banner

LOB Index || Last_Analyzed Not updated

edited Oct 6, 2025 7:19AM in Database Administration (MOSC) 1 commentAnswered

Hello,
I used both gather index stats and gather table stat for tables having these LOB indexes and still the Last_Analyzed is NULL for them.

select count(*) from dba_indexes i where i.owner = 'xx'
AND (i.last_analyzed IS NULL OR i.last_analyzed < ADD_MONTHS(SYSDATE,-3))
ORDER BY i.index_name;

COUNT(*)

 33318

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