Re: lock Oracle db objects, but only a lock for others?

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 21 Apr 2003 03:40:50 GMT
Message-ID: <6LJoa.282556$OV.330727@rwcrnsc54>

> So, given that this is bad, I want to know how best to lock what needs to be
> locked, if it needs to be locked at all (if not, I don't), in such a way as
> to assure reasonable security (or concurrency, or whatever - you Oracle
> types can help me out here) for the data while simplifying the code and code
> maintenance until such time as this company Does The Right Thing and
> rewrites the entire code base, carefully coached by duely qualified Oracle
> gurus. That is all.

Read up on DBMS_LOCK at tahiti.oracle.com. Be very careful with it's usage. Received on Sun Apr 20 2003 - 22:40:50 CDT