Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Suspend session?

Re: Suspend session?

From: Chuck <chuckh_at_softhome.net>
Date: Tue, 18 Jun 2002 10:29:27 -0400
Message-ID: <aeng48$8dc3o$1@ID-85580.news.dfncis.de>


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?



>
> 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 Tue Jun 18 2002 - 09:29:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US