How to Suspend an Oracle Session

  • by
Given a session was consuming lots of resource on Oracle database server, what should we do about the session? Killing the session might be an option for DBA, but all the uncommitted transactions will be rolled back and there could be no one knows how to continue the job.

Set the target PID for debug.
SQL> oradebug setorapid 75;
Unix process pid: 2394570, image: oracle@localhost (TNS V1-V3)

Suspend the PID
SQL> oradebug suspend;
Statement processed.

I saw IO busy percentage was dropping at the moment.

Resume the PID
SQL> oradebug resume;
Statement processed.

Leave a Reply

Your email address will not be published. Required fields are marked *