Re: Locks in Oracle 9i

Hi everybody,

thanks for the answers. The alter system command does the trick.

Greetings - Jan

Jan Pompe schrieb:
> Hi Daniel,
>
> you're right: I don't need locking at all and I don't do it explicitly
> either. Oracle does it for me, unwanted though.
>
> Situation: I sit at home and try to write a Java-application (for my
> Bachelor's thesis) that connects to the Oracle-Server at the university.
> Normally, everything is ok, but every now and then my application hangs
> (for reasons yet unknown to me). So I shut down the app on my side, but
> when I restart it, it doesn't do any database operations at all, but
> waits infinitely instead. When I start Oracle's Lock-Manager
> (server-side via mstsc) it tells me, that the table is locked - by me.
> The only way to resolve this (so far) is to reboot the server (which is
> ok, because I'm the only one who uses this server at the moment), wait
> for 5 - 10 Minutes and then start my application again.
>
> But there should be another way to remove persistent locks, right?
>
> Regards - Jan
>
>
>
> Daniel Morgan schrieb:
>

>> Jan Pompe wrote:
>>
>>> Hi,
>>>
>>> is there any way to manually remove locks on tables under Oracle 9i?
>>>
>>> Sometimes, when I hack in a procedure that updates a table, I forget 
>>> the COMMIT at the end. Or I cancel a Java-program on my client, 
>>> because it takes to long to finish. In these cases the lock on the 
>>> specific table persists.
>>>
>>> Is there any way to remove these persisting locks? I do have 
>>> admin-access to the database server and I can see the locks sitting 
>>> there in lock-manager, but there doesn't seem to be a way to clear them.
>>>
>>> Any ideas?
>>>
>>> TIA   - Jan
>>>
>> End your session.
>>
>> But why are you locking anything? Based on your description it seems 
>> highly unlikely you need any locks at all.
>>