Oracle故障应急处理
-
编辑 删除
两种解决Oracle进程hang的办法
以下两种方法通过process、全局两个层面，对hang住的process做重新激活的操作，思路很新颖，如果真的有作用，不失为一种较为方便有效的办法，记录下以便日后查阅。Workaround: oradebug setospid+unlimit to free the hanging process: 1、identify the Unix process id of the hanging process2、use oradebug on it as follows (the unlimit command is sufficient to stop the hang) SQL> oradebug setospid SQL> oradebug unlimit 3、alternatively, if there are many processes hanging on 'cursor: pin S wait on X', or tim
