MOATS-like sqlplus “top” utility for RAC
So, you think MOATS was cool?! Check this out by Jagjeet Singh 
Oradebug hanganalyze with a prelim connection and “ERROR: Can not perform hang analysis dump without a process state object and a session state object.”
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 sy…
RSS
Email