I found an answer on oracle.com where someone stated that, on any sql command, the database will hang if the redo log files are full. There will be no error message. So my question to you now is:
what command can I use to query how full the redo logs are?