Oradebug hanganalyze with a prelim connection and ‘ERROR: Can not perform hang analysis dump without a process state object and a session state object.’

(Tanel Poder) Back in the (really) old days, systemstate dumps had to be used for diagnosing hangs and finding blockers of hung databases. Basically you just identified which resource your waiting sessions were waiting for and then scanned through the rest of the system state dump to see which sessi

Read More - Register for Free Membership