Very Headache Problem .
We got 2 database server . Live server and report server .
the report server is using MV to get the data from Life server .
the refresh mode is 'F' .

There is some housekeeping batch running in life server .
BUt actually , no data is purged because there is no 'old enough
data' in life server . So when the housekeeping procedure running ,
actually the delete statement is not purging anything .
the funny things is although there is nothing deleted in life server , the MV refresh report server is hanging ! it simply executing for ever !

Is there any thoughts to figure out what is the problem ?

Oracle Database is 9.2.0.1.0 in unix .