Suspend a running process SQL> oradebug setorapid 12 Unix process pid: 10932, image: oracle@localhost.localdomain (TNS V1-V3) SQL> oradebug suspend Statement processed. Resume a process SQL> oradebug resume Statement processed. If you have trace turned on a suspended and resume session you will see the following messages in the trace file. FETCH #5:c=54992,e=55962,p=0,cr=2334,cu=0,mis=0,r=1,dep=1,og=1,tim=1249098751175228 EXEC #5:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=1249098751175408 Received … Continue reading How to suspend/resume a process using oradebug? →