I think alot of the time what you are really waiting for is for Oracle to ROLLBACK whatever transactions took place.
Keep the rollback in mind.

MH