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: anyway to commit/rollback for another session?

Re: anyway to commit/rollback for another session?

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Tue, 15 Jul 2003 16:44:18 -0700
Message-ID: <3F1491D2.14A4B8D2@exxesolutions.com>


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

Original text of this message

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