• Did you specify 'with rollback immediate' or anything like that (to roll back uncommitted transactions)? Because if not it can take ages.