This is true. I had a database come down during a remote mv refresh. The rollback sucked up every bit of i/o on the box rendering it useless. I must have hit some sort of bug as the mv was simple and small but it kept rolling back. I finally just dropped the mv owner and recreated. ----- Original Message ----- From: David Sharples To: Abdul.Ebadi@xxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Sent: Wednesday, March 08, 2006 3:10 PM Subject: Re: Shutdown Immediate Hangs rolling back a large transaction -- //www.freelists.org/webpage/oracle-l