Re: anyway to commit/rollback for another session?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Tue, 15 Jul 2003 21:31:43 GMT
Message-ID: <3f147231.700423726@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 Received on Tue Jul 15 2003 - 16:31:43 CDT