Why would a UNUSABLE function based index be causing "db file sequential" read waits with a direct l
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 ?