DBMS_LOCK problem

From: Steve Dover <swd_at_strata-group.Xcom>
Date: 1997/12/18
Message-ID: <34998B57.6AD6687C@strata-group.Xcom>#1/1

Has anyone encountered the following:

Various programs are using dbms_lock as a semaphore mechanism to prevent multiple copies of the same program from accessing the same resource.

The locks are setup to be exclusive, No release on commit.

Rarely, when the process finishes, the lock is not released. The only way to clear this up is to re-start oracle.

The environment is Oracle 7.1.3, on Solaris 2.5 Sparc with multiple processors.

TIA

-- 
Steve
To reply via e-mail, remove the X

Received on Thu Dec 18 1997 - 00:00:00 CST