Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: anyway to commit/rollback for another session?
andreyNSPAM_at_bookexchange.net (NetComrade) wrote in message news:<3f147231.700423726_at_nyc.news.speakeasy.net>...
> On 14 Jul 2003 19:27:46 -0700, Mark.Powell_at_eds.com (Mark D Powell)
> wrote:
>
>
> >
> >Netcomrade, I do not believe there is any way to commit or rollback
> >for another user's session.
> >
> >Are you sure that the distributed applications 1- all got changed, 2-
> >that the changes got moved into production, and 3- in the case of
> >desktop software all users received the new version?
>
>
> Mark,
> I've read and re-read your questions, and I think you misunderstood my
> problem.
> All distributed SELECTS require a TX lock which can only be taken off
> by a commit. All DML is committed already, I just want to commit for
> idle sessions that could potentially be preventing a rollback segment
> from recycling.
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email
your only option is to kill the sessions involved which will roll everythign back and release the locks. Received on Wed Jul 16 2003 - 05:54:59 CDT