do DESCRIBE DBMS_LOCK (it's a package)
Killing a session should do it though.
On Mon, 4 Oct 1999 13:33:56 +0200, "Ivan Bajon"
<iba_at_no_spam_at_post1.tele.dk> wrote:
>Hi Kenneth
>
>All you can do is kill the session. You can't release the locks held by
>another session by other means.
>
>Regards,
>Ivan Bajon, ocp
>
>Kenneth Yue <cwyue_at_se.cuhk.edu.hk> wrote in message
>news:7t9b07$hlo$1_at_eng-ser1.erg.cuhk.edu.hk...
>> Dear all,
>>
>> suppose I used a SELECT ... for update nowait statement to lock a row in a
>table. And, may be
>> there are some problems with my programs that the lock is left on the
>server. How can I
>> release the lock by logging in through another session?
>>
>> thanks!
>>
>>
>> --
>> Cheers,
>> Kenneth (Milk Ken)
>>
>>
>> ___\/ __ _____ ___ _____ The Chinese University
>> //////`\\\\ _( \/ )/ )__ of
>> |;;;;/~\\\| ( Touch me at : ) Hong Kong
>> (|($)-($)|) ( )
>> | '. | _/ cwyue_at_se.cuhk.edu.hk ) Department of Sys. Eng. &
>> \ O / ~~~\ kenneth.yue_at_alumni.ust.hk) Eng. Mgmt.
>> ___/|\=/|\___ ( keyue_at_asl.com.hk ___)
>> / | \\___// | \ ( ___)
>> | |* === | (_____)\____/\_____) Tutor of SEG6460
>>
>
>
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
AOL: NetComrade ICQ: 11340726 remove NSPAM to email
Received on Mon Oct 04 1999 - 12:40:38 CDT
