Hi,
After waiting 4+ hours for the Index initialization step in SQL Optimizer I gave up and hit the Stop button - it is now been in the Pausing index data initialization... step for an hour.
I see a line in v$session for the optimizer and it says it has written 112 rows to the redo log and it never seems to flush them out - any ideas?
Thanks