Re: Suspend session?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 17 Jun 2002 14:36:58 +0100
Message-ID: <1024321017.23697.0.nnrp-12.9e984b29@news.demon.co.uk>

Yes.

connect / as sysdba
oradebug setospid {o/s process id of shadow} oradebug suspend

After you've done this, make sure that the session you have suspended isn't holding any locks or latches or other processes may suffer. (select from v$lock, select from v$latchholder)

To resurrect the suspended session:

oradebug resume

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            June / July
        Australia      July / August
http://www.jlcomp.demon.co.uk/seminar.html

Chuck wrote in message ...


>Is there a way to suspend a session without killing it in 8.1.7?

>

>

Received on Mon Jun 17 2002 - 08:36:58 CDT