Wednesday, September 3, 2008

oradebug to suspend and resume another user's session

# You can suspend and resume another user's session using the oradebug command in sqlplus.

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

SPID PID
------------ ----------
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.