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.