Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unlocking Locked records
Pete Bretz wrote:
> I'm running Workgroup Server 7.3.4 in a web application environment -
> Oracle webserver 2.1.1. I am having problem with one table developing
> locked rows, even though the user is done modifying records. Any
> suggestions on:
>
> 1. how do I clear the locked records
> 2. troubleshoot why they are remaining locked in the first place.
>
> Thanks for any help!
>
> Pete Bre
Sorry if this is too simplistic, but is the user somehow leaving a transaction without committing/rolling back? Is there some GUI bug that causes a transaction to remain open under some circumstances? HTH. Received on Thu Mar 11 1999 - 17:23:03 CST