Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Suspend session?
Is there a way to do this "post transaction" so I catch it between
transactions? I don't want to have anything locked with what I am trying to
do.
-- Chuck Hamilton QVC Inc. http://www.qvc.com ----- Original Message ----- From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> Newsgroups: comp.databases.oracle.server Sent: Monday, June 17, 2002 9:36 AM Subject: Re: Suspend session?Received on Tue Jun 18 2002 - 09:29:27 CDT
>
> 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?
> >
> >
>
>