Skip to content
Home » Oracle » How to Suspend an Oracle Session

How to Suspend an Oracle Session

Given a session which 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 *