Suspend and Resume your query execution without killing the session using oradebug utility

You can suspend and resume of your query execution without killing the session using oradebug utility.

SELECT pid FROM v$process
WHERE addr IN
(
SELECT paddr FROM v$session
WHERE sid = &sid
);

ORADEBUG SETORAPID
ORADEBUG SUSPEND
ORADEBUG RESUME