Is just the INSERT hung? Can you do other operations on other sessions? If you have not enabled automatic archival, the entire instance will hang until you archive logs manually (although I don't think there is a good chance of that happening on a production database without being noticed before).

Hard to guess without further details.