Database DataWarehousing (MOSC)

MOSC Banner

Why would a UNUSABLE function based index be causing "db file sequential" read waits with a direct l

edited Feb 23, 2015 10:01AM in Database DataWarehousing (MOSC) 4 commentsAnswered

Hi there

Just a background, I see a load process that uses sqlldr with direct=y, which spends lots of time on wait event "db file sequential read" on function based indexes that have been made UNUSABLE.

I would expect UNUSABLE indexes to be mostly ignore with a load - so I am wondering whether this FBI is actually unusable - if I select STATUS and FUNCIDX_STATUS I see that STATUS=UNUSABLE, but FUNCIDX_STATUS=ENABLED, so I am wondering whether the FUNCIDX_STATUS shouldn't also be DISABLED.

"

This is not my process, so I cannot change it myself to test it, so this question is more about "Is the FBI actaully disabled ?" and if so - then why are there so many db_file_sequential_reads agains this index if it is disabled ?

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