You will never understand what's truly going on until you dump the GUI.

Trace the process that is hanging. It most likely has nothing to do with SGA size or open_cursors.