Re: Strange thing

From: Mladen Gogala <>
Date: Wed, 13 Jun 2012 16:06:52 +0000 (UTC)
Message-ID: <jradqs$f50$>

On Tue, 12 Jun 2012 21:55:35 +0100, Jonathan Lewis wrote:

> If you want to play around with controlling user resources with Oracle's
> locking mechanism you need to look at package dbms_lock which, from
> memory has key procedures called: request, release and convert (plus a
> couple of supporting bits).
> Regards Jonathan Lewis

Jonathan, I don't want to play around, I was just wandering how did Oracle release the locks before the transaction had committed. I believe you gave me an answer: it didn't release them, it converted them to NULL mode. The practical effect is pretty much the same.

Received on Wed Jun 13 2012 - 11:06:52 CDT

Original text of this message