check for latch wait ratio that may be redo log latch or buffer latch for that reason your transaction is to be wait and not suffecient resources found os goes into dump state