Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: anyway to commit/rollback for another session?
NetComrade wrote:
> 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
The answer to your question ... is No!
But I should add that unless you have evidence to the contrary I don't think the problem you imagine can possibly exist and am inclined to refer you to the Concepts and Architecture manuals.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Tue Jul 15 2003 - 18:44:18 CDT