We are using 10.2.0.5.0 on Linux.
We are using Fast Refresh materialized view to synch data with remote database. By looking into USER_JOBS table, it is seen that the MV refresh job is stuck since 10/27/2013. Can you please guide me how to find the root cause for this issue.
Moreover, the UNDO, REDO tablespace is available and archiving is going fine. Also, we could not find any waiting session in session_wait event.