here is the quote from the Oracle forum:

"If the database is hanging on any sql command, check the volume where the logs and archives are kept. If they run out of room, the database will hang, waiting for space to become available."


We are not running in archivelogmode.