When this happens, I usually have the DBA restart the database.
DBA? Man you might as well be speaking Chinese to me. What does that mean?