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 that I catch it between
transactions? For what I'm trying to do I don't want any locks left on the
database.
"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?
> >
> >
>
>