Re: Suspend session?

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Mon, 17 Jun 2002 22:02:50 +0800
Message-ID: <aekq8n$emu$1@violet.singnet.com.sg>

Jonathan,

Does this work in 8.0 and 8.1 ?

Hemant
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1024321017.23697.0.nnrp-12.9e984b29_at_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 - 09:02:50 CDT