its not hanging period

you might as well look yoour cursors explain plan

if it was hanging you would see latch free, enqueue which are blocking mechanisms otherwise it´s doing work but if your cursor is slow then you see what you see