I would help for my query which is slow

hello Gurus,

     I try to improve my query, for improve I use tkprof .
>>>>>I have a file temporaire, T_TCLOD_P0151F#6_qlt, without key. But I think key is not necessary because I have to update all my record.
                                                                                                                                                 times    Max         Total
                                                                                                                                                Waited   Wait         Waited

>>>>>I see I have time on redolog to small, but the indice :  log file switch (checkpoint incomplete) 68        0.97         32.98

                                                                                     log file switch completion                     64         0.97         18.00

1 - What do you think about it ?

2 - I join you the result after it.

3 - I have an error "The following statement encountered a error during parse:" What is it.

4 - I have not join my query because it's very big.