Friday, August 15, 2008

How to suspend and resume a running Oracle process

SQL> select spid, pid from v$process where addr = (select paddr from v$session where sid = 1871);

------------ ----------
729304 32

SQL> oradebug setospid 729304
Oracle pid: 32, Unix process pid: 729304, image: oracle@p-test-oranode-30 (TNS V1-V3)
SQL> oradebug suspend
Statement processed.
SQL> oradebug resume
Statement processed.