> YES , Absolutely 24X7 , DB
>
> first i can understand what table BUT i have multiple index for this
> table then can not understand what index(s) of this table have
> problem...
> then how use ALTER INDEX ... ACTIVE; COMMIT ?
>
> one note i point to it : i have *always* problem with one table of over
> thousand of tables in my db only one table
> also other note this table have used in one *heavy load* recursive
> stored procedure (get over 50 sec to finish) one other *hungry*
> user work with this table ...
>
>

why don't you just show use the table structure for this table, including
index declarations and the recursive procedure for it.
That may shed some light on possible issues
Alan