Re: GET_LOCK/RELEASE_LOCK - Active Lock Holders
Posted by:
Van Stokes
Date: March 01, 2009 01:25AM
Just in case anyone else stumbles onto this post like I did. Here is what I found:
"IS_USED_LOCK() checks if the lock is used and returns the connection identifier of the client that holds the lock otherwise 0. NULL is used for error cases."
Source:
http://optimmysql.blogspot.com/2007/11/getlock-family.html
Subject
Views
Written By
Posted
22300
September 05, 2007 10:36AM
9308
April 24, 2008 12:54AM
Re: GET_LOCK/RELEASE_LOCK - Active Lock Holders
8146
March 01, 2009 01:25AM
9484
March 17, 2009 02:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.